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

来源：长理培训发布时间：2017-10-17 20:10:51

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