2006年资格考试OracleDBA数据库结构题选1

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