OracleDBA数据库结构笔试题

OracleDBA数据库结构笔试题

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