Blog
Oracle Database Architecture MCQ
- November 21, 2021
- Posted by: Ankush Thavali
- Category: Oracle DBA

Oracle Database Architecture - MCQ

1) How many layers does the Oracle database have?
2) Which of the following are types of segments
3) A _____________ is a set of tables physically stored together as one table that shares a common column.
4) What are the elements of the redo log buffer and Shared pool?
5) The size and content of the PGA is independent on the Oracle server options installed.
6) What do the schema objects comprise of?
7) The basic memory structures associated with Oracle are the System Global Area (SGA) and the Program Global Area (PGA).
8) Which of the following components comprise of an oracle architecture?
9) The size and content of the PGA is independent on the Oracle server options installed.
10) Which area of PGA stores binding variables and runtime buffers information?
11) Which of the following is the most probable use of an extent?
12) Which is the smallest unit of storage in an Oracle database?
13) A _______________ is used to logically group data together.
14) Which of the following segment is destroyed when the SQL statement is finished?
15) Can there be more than one datafile per tablespace?
16) Where is the data dictionary kept?
17) Oracle automatically creates the SYSTEM tablespace.
18) Which processes is an instance made of?
19) What is the use of an index?
20) What is the use of Library cache?
Oracle Database Architecture - MCQ

1) How many layers does the Oracle database have?
2) Which of the following are types of segments
3) A _____________ is a set of tables physically stored together as one table that shares a common column.
4) What are the elements of the redo log buffer and Shared pool?
5) The size and content of the PGA is independent on the Oracle server options installed.
6) What do the schema objects comprise of?
7) The basic memory structures associated with Oracle are the System Global Area (SGA) and the Program Global Area (PGA).
8) Which of the following components comprise of an oracle architecture?
9) The size and content of the PGA is independent on the Oracle server options installed.
10) Which area of PGA stores binding variables and runtime buffers information?
11) Which of the following is the most probable use of an extent?
12) Which is the smallest unit of storage in an Oracle database?
13) A _______________ is used to logically group data together.
14) Which of the following segment is destroyed when the SQL statement is finished?
15) Can there be more than one datafile per tablespace?
16) Where is the data dictionary kept?
17) Oracle automatically creates the SYSTEM tablespace.
18) Which processes is an instance made of?
19) What is the use of an index?
20) What is the use of Library cache?