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

文章作者 100test 发表时间 2007:03:14 13:25:43
来源 100Test.Com百考试题网

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 called
　　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 Server
　　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 )
　　4. All of the above
　　4
　　Q. 8 : The process that writes the modified blocks to the data files is
　　1. DBWR
　　2. LGWR
　　3. PMON
　　4. SMON