Q. 1 : Physical Disk Resources in an Oracle Database are
1. Control Files
2. Redo Log Files
3. Data Files
4. All of the above
4
Q. 2 : What is a Schema
1. A Physical Organization of Objects in the Database
2. A Logical Organization of Objects in the Database
3. A Scheme Of Indexing
4. None of the above
2
Q. 3 : An Oracle Instance is
1. Oracle Memory Structures
2. Oracle I/O Structures
3. Oracle Background Processes
4. All of the Above
4
Q. 4 : The SGA Consists of the Following Items
1. Buffer Cache
2. Shared Pool
3. Redo Log Buffer
4. All of the Above
4
Q. 5 : The area that stores the blocks recently used by SQL statements is
1. Shared Pool
2. Buffer Cache
3. PGA
4. UGA
2
Q. 6 : Which of the following is not a Background Server Process in an Oracle
1. DB Writer
2. DB Reader
3. Log Writer
4. SMON
2
Q. 7 : Which of the following is a valid background server processes in Oracle
1. ARCHiver
2. LGWR ( Log Writer )
3. DBWR ( Dbwriter )
