Oracle DBA 数据库结构试题选1

[NextPage]

3. PMON


Q. 15 : If an application requests data that is already in the memory, it is referred to as a
　　1. Cache Read
　　3. Cache Miss


Q. 16 : If the data requested is in the memory but had to be reloaded due to aging, it is referred to as
　　2. CACHE REFRESH
　　4. None of the above
　　3
　　Q. 17 : If the data requested is not in the servers memory, it is referred to as
　　1. CACHE DISK
　　3. CACHE READ


Q. 18 : You can Dynamically resize the following Parameters in the SGA
　　1. Buffer Cache
　　3. Dictionary Cache


Q. 19 : The memory area that stores the parsed representation of most recently executed Statements is
　　2. LIBRARY CACHE
　　4. NONE OF THE ABOVE
　　2
　　Q. 20 : The Most recently used data dictionary information is stored in
　　1. DATA DICTIONARY CACHE
　　3. BUFFER CACHE


Q. 21 : The server memory that holds session-specific information is referred to as
　　2. Session Global Area
　　4. None of the above
　　1
　　Q. 22 : The area of memory used by the server as temporary area for sorting is called
　　1. TEMP SPACE 　　2. SORT AREA
　　4. SORT BUFFER
　　2
　　Q. 23 : The fundamental unit of storage in a data file is
　　1. BYTE
　　3. BLOCK


Q. 24 : The process that resolves the in-doubt transactions in a distributed environment is
　　1. ARCH
　　3. RECO


Q. 25 : The size of each buffer in the database is set using this parameter
　　1. DB_BLOCK_BUFFERS
　　3. DB_BYTE_SIZE


Q. 26 : The number of Block Buffers in the database is set in the init.ora using
　　1. DB_BLOCK_SIZE
　　3. DB_BUFFER_CACHE


　　Q. 27 : The Parameter that sets the size of the shared SQL Area is

　　2. SHARED_POOL_SIZE
　　4. NONE OF THE ABOVE
　　2