Q. 20 : The Most recently used data dictionary information is stored in
1. DATA DICTIONARY CACHE
2. SHARED CACHE
3. BUFFER CACHE
4. NONE OF THE ABOVE
1
Q. 21 : The server memory that holds session-specific information is referred to as
1. Program or Private Global Area
2. Session Global Area
3. Temp Space
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
3. REDO BUFFER
4. SORT BUFFER
2
Q. 23 : The fundamental unit of storage in a data file is
1. BYTE
2. BIT
3. BLOCK
4. None of the above
3
Q. 24 : The process that resolves the in-doubt transactions in a distributed environment is
1. ARCH
2. PROC
3. RECO
4. NONE OF THE ABOVE
3
Q. 25 : The size of each buffer in the database is set using this parameter
1. DB_BLOCK_BUFFERS
2. DB_BLOCK_SIZE
3. DB_BYTE_SIZE
4. NONE OF THE ABOVE
2
Q. 26 : The number of Block Buffers in the database is set in the init.ora using
1. DB_BLOCK_SIZE
2. DB_BLOCK_BUFFERS
3. DB_BUFFER_CACHE
4. NONE OF THE ABOVE
2
Q. 27 : The Parameter that sets the size of the shared SQL Area is
1. SHARED_SQL_AREA
2. SHARED_POOL_SIZE
3. SHARED_CACHE_SIZE
4. NONE OF THE ABOVE
2
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
责任编辑:小草