Q. 15 : If an application requests data that is already in the memory, it is 1. Cache Read 2. Cache Hit 3. Cache Miss 4. Cache Latch 2 Q. 16 : If the data requested is in the memory but had to be reloaded due to 1. CACHE HIT 2. CACHE REFRESH 3. CACHE RELOAD 4. None of the above 3 Q. 17 : If the data requested is not in the servers memory, it is referred to 1. CACHE DISK 2. CACHE MISS 3. CACHE READ 4. None of the above 2 Q. 18 : You can Dynamically resize the following Parameters in the SGA 1. Buffer Cache 2. Library Cache 3. Dictionary Cache 4. None of the above 4 Q. 19 : The memory area that stores the parsed representation of most 1. BUFFER CACHE 2. LIBRARY CACHE 3. DICTIONARY CACHE 4. NONE OF THE ABOVE 2 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 Q. 21 : The server memory that holds session-specific information is referred 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 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 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 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
|