Oracle MCQ

Oracle MCQ

  • Sharad Jaiswal
  • 25th Nov, 2021

We have listed here the best Oracle MCQ Questions for your basic knowledge of Oracle MCQ. This Oracle MCQ Test contains 20+ Oracle Multiple Choice Questions. You have to select the right answer to every question to check your final preparation for the Oracle MCQ Interview or Exams.

Practice Best Oracle MCQ Questions;

1) Which processes is an instance made of oracle?

  • A. Data processes
  • B.Data Segment
  • C.Datafiles
  • D.Oracle background processes

2) The redo log buffer and Shared pool are elements

  • A. PGA
  • B.SGA
  • C.CGA
  • D.Session area

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

  • C.Terminates
  • D.All of the above

4) Smallest Unit of storage in an database?

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

5) ________Oracle backup and recover file containes userr and system data

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

6) What is the use of extent in oracle?

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

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

  • A. Data Segment
  • B.Object Segment
  • C.Permanent Segment
  • D.None of the above

8) Which kind of components comprise an Oracle architecture?

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

9) ............. is used to logically group data together.

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

10) Which prefixes are available to Oracle triggers?

  • A. :old
  • B.:new
  • C.Both :old & :new
  • D.None of the above

11) The Oracle database have ............ layers.

  • A. 2
  • B.4
  • C.6
  • D.8

12) ............ is the smallest unit of storage in an Oracle database?

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

13) Which of the following package procedure is UNRESTRICTED In Oracle?


14) Oracle server configuration is dedicated for ............

  • A. Many server processes – Many user processes
  • B.One server process – Many user processes
  • C.One server process – One user process
  • D.None of the above

15) Which kind of system variable is used to refer DATABASE TIME ?

  • A. $$time$$
  • B.$$dbtime$$
  • C.$$datetime$$
  • D.None of the above

16) Which processes is an instance made of Oracle?

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

17) Where is the data dictionary kept?

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

18) You can use the DROP statement to remove structures from the database.

  • A. True
  • B.False

19) To obtain the structure of an Oracle table, the command to use is:

  • A. DESCRIBE [TableName]
  • C.DESC TABLE [TableName]
  • D.STRUCTURE [TableName]

20) An Oracle System Change Number (SCN):

  • A. is a value that keeps track of explicit locks.
  • incremented whenever a deadlock occurs.
  • a value that is incremented whenever a dirty read occurs.
  • a value that is incremented whenever database changes are made.

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.