- 21 Nov, 2021
- 0 Comments
- 2 Mins Read
Oracle Database Architecture MCQ
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?