Oracle MCQ Quiz

  1. Which processes is an instance made of Oracle?
  2. Which of the following components comprise an Oracle architecture?
  3. In Oracle, which of below are types of segments?
  4. Which is the smallest unit of storage in an Oracle database?
  5. Oracle database’s design is also called as -
  6. Where is the data dictionary kept?
  7. How many layers does the Oracle database have?
  8. A ..................... is used to logically group data together.
  9. Which prefixes are available to Oracle triggers?
  10. What Oracle backup and recover file contains user and system data
  11. What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?
  12. Which processes is an instance made of Oracle?
  13. What is the use of extent in Oracle?
  14. Which of the following is true in this scenario?
Oracle MCQ

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.

  • Memory processes
  • Oracle background processes
  • Data processes
  • All of the Mentioned
View Answer
  • Database related background processes
  • Datafiles
  • Tablespaces
  • All of the Mentioned
View Answer
  • All of the Mentioned
  • Permanent Segment
  • Object Segment
  • Data Segment
View Answer
  • Segment
  • Data Block
  • Extent
  • Data File
View Answer
  • Database Instance
  • Database Abstraction
  • Database Schema
  • none of these
View Answer
  • Stack Space
  • Data file
  • SYSTEM tablespace
  • None of these
View Answer
  • 1
  • 3
  • 2
  • 4
View Answer
  • Object
  • Datafiles
  • Tablespace
  • Database
View Answer
  • :new
  • :old
  • Both :new and :old
  • Neither :new nor :old
View Answer
  • Datafile
  • Control file
  • OnLine ReDo file
  • Offline ReDo file
View Answer
  • Inconsistent backup
  • Consistent backup
  • Full backup
  • Differential backup
View Answer
  • Memory processes
  • Oracle background processes
  • Data processes
  • All of the above
View Answer
  • 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
  • The user can not create tables
  • The user cannot query any table
  • The user can create tables
  • None of the Mentioned
View Answer
  • CURRENTLY ONLINE
  • OFFLINE
  • CLOSED
  • OPEN
View Answer
  • User disconnects from Oracle
  • COMMIT or ROLLBACK is issued
  • User process terminates abnormally
  • All of the mentioned
View Answer
  • Yes
  • No
View Answer
  • True
  • false
View Answer
  • Replica group
  • Replication
  • Replica
  • Replication group
View Answer
  • .sql.
  • .txt.
  • .pls.
  • .ora.
View Answer