Oracle MCQ Quiz

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.

1. Which processes is an instance made of Oracle?

  • Memory processes
  • Oracle background processes
  • Data processes
  • All of the Mentioned
View Answer

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

  • Database related background processes
  • Datafiles
  • Tablespaces
  • All of the Mentioned
View Answer

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

  • All of the Mentioned
  • Permanent Segment
  • Object Segment
  • Data Segment
View Answer

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

  • Segment
  • Data Block
  • Extent
  • Data File
View Answer

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

  • Database Instance
  • Database Abstraction
  • Database Schema
  • none of these
View Answer

6. Where is the data dictionary kept?

  • Stack Space
  • Data file
  • SYSTEM tablespace
  • None of these
View Answer

7. How many layers does the Oracle database have?

  • 1
  • 3
  • 2
  • 4
View Answer

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

  • Object
  • Datafiles
  • Tablespace
  • Database
View Answer

9. Which prefixes are available to Oracle triggers?

  • :new
  • :old
  • Both :new and :old
  • Neither :new nor :old
View Answer

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

  • Datafile
  • Control file
  • OnLine ReDo file
  • Offline ReDo file
View Answer

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

  • Inconsistent backup
  • Consistent backup
  • Full backup
  • Differential backup
View Answer

12. Which processes is an instance made of Oracle?

  • Memory processes
  • Oracle background processes
  • Data processes
  • All of the above
View Answer

13. What is the use of extent in Oracle?

  • Stores rollback information used when data must be rolled back
  • Minimize the amount of wasted (empty) storage
  • Stores user data within the database
  • None of the Mentioned
View Answer

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

  • The user can not create tables
  • The user cannot query any table
  • The user can create tables
  • None of the Mentioned
View Answer

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

  • OPEN
View Answer

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

  • User disconnects from Oracle
  • COMMIT or ROLLBACK is issued
  • User process terminates abnormally
  • All of the mentioned
View Answer

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

  • Yes
  • No
View Answer

18. Insert & Update are DML Statements.

  • True
  • false
View Answer

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

  • Replica group
  • Replication
  • Replica
  • Replication group
View Answer

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

  • .sql.
  • .txt.
  • .pls.
  • .ora.
View Answer

Write For Us.

Contribute the Community.