Oracle MCQ

Oracle MCQ

  • Admin
  • 09th Feb, 2023

Take Oracle Quiz To test your Knowledge 

Below are few Oracle MCQ test that checks your basic knowledge of Oracle. This Oracle Test contains around 20 questions of multiple choice with 4 options. You have to select the right answer to a question. You can see the correct answer by clicking view answer link.

Also, Read Best Oracle interview questions.

Oracle MCQ Quiz

1) Which processes is an instance made of Oracle?

  • A. Memory processes
  • B.Oracle background processes
  • C.Data processes
  • D.All of the Mentioned

2) Which of the following components comprise an Oracle architecture?

  • A. Database related background processes
  • B.Datafiles
  • C.Tablespaces
  • D.All of the Mentioned

3) In Oracle, which of below are types of segments?

  • A. All of the Mentioned
  • B.Permanent Segment
  • C.Object Segment
  • D.Data Segment

4) Which is the smallest unit of storage in an Oracle database?

  • A. Segment
  • B.Data Block
  • C.Extent
  • D.Data File

5) Oracle database’s design is also called as -

  • A. Database Instance
  • B.Database Abstraction
  • C.Database Schema
  • D.none of these
Download Free : Oracle MCQ PDF

6) Where is the data dictionary kept?

  • A. Stack Space
  • B.Data file
  • C.SYSTEM tablespace
  • D.None of these

7) How many layers does the Oracle database have?

  • A. 1
  • B.3
  • C.2
  • D.4

8) A ..................... is used to logically group data together.

  • A. Object
  • B.Datafiles
  • C.Tablespace
  • D.Database

9) Which prefixes are available to Oracle triggers?

  • A. :new
  • B.:old
  • C.Both :new and :old
  • D.Neither :new nor :old

10) What Oracle backup and recover file contains user and system data

  • A. Datafile
  • B.Control file
  • C.OnLine ReDo file
  • D.Offline ReDo file

11) What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?

  • A. Inconsistent backup
  • B.Consistent backup
  • C.Full backup
  • D.Differential backup

12) Which processes is an instance made of Oracle?

  • A. Memory processes
  • B.Oracle background processes
  • C.Data processes
  • D.All of the above

13) What is the use of extent in Oracle?

  • A. Stores rollback information used when data must be rolled back
  • B.Minimize the amount of wasted (empty) storage
  • C.Stores user data within the database
  • D.None of the Mentioned

14) Which of the following is true in this scenario?

  • A. The user can not create tables
  • B.The user cannot query any table
  • C.The user can create tables
  • D.None of the Mentioned

15) You can create any cluster and associated cluster index in any tablespace that is -

  • D.OPEN

16) Which of the following scenarios ends an Oracle transaction?

  • A. User disconnects from Oracle
  • B.COMMIT or ROLLBACK is issued
  • C.User process terminates abnormally
  • D.All of the mentioned

17) Is the size and content of the PGA independent on the Oracle server options installed ?

  • A. Yes
  • B.No

18) Insert & Update are DML Statements.

  • A. True
  • B.false

19) Which of the following is a collection of one or more replicated objects (typically tables) that are administrated together.

  • A. Replica group
  • B.Replication
  • C.Replica
  • D.Replication group

20) which is the extension of an Oracle SQL*Plus file ?

  • A. .sql.
  • B..txt.
  • C..pls.
  • D..ora.

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.

Related MCQ/Quiz

Robotics MCQ
Tableau MCQ