Q. 1 : Physical Disk Resources in an Oracle Database are
2. Redo Log Files
4. All of the above
4
Q. 2 : What is a Schema
1. A Physical Organization of Objects in the Database
3. A Scheme Of Indexing
Q. 3 : An Oracle Instance is
1. Oracle Memory Structures
3. Oracle Background Processes
Q. 4 : The SGA Consists of the Following Items
1. Buffer Cache
3. Redo Log Buffer
Q. 5 : The area that stores the blocks recently used by SQL statements is called
1. Shared Pool
3. PGA
Q. 6 : Which of the following is not a Background Server Process in an Oracle Server
1. DB Writer
3. Log Writer
2. LGWR ( Log Writer )
4. All of the above
4
Q. 8 : The process that writes the modified blocks to the data files is
2. LGWR
4. SMON
1 : Oracle does not modify the data in data file. Once the server process makes a change in the Memory, DBWR writes the modified blocks back to disk.
Q. 9 : The process that records information about the changes made by all transactions that commit is
1. DBWR
3. CKPT
Q. 10 : Oracle does not consider a transaction committed until
2. The LGWR successfully writes the changes to redo
4. SMON Process Writes the data
2
Q. 11 : The process that performs internal operations like Tablespace Coalescing is
2. SMON
4. ARCH
2
Q. 12 : The process that manages the connectivity of user sessions is
1. PMON
3. SERV
Q. 13 : The ARCH process is enabled when the database runs in a
1. PARALLEL Mode
3. NOARCHIVELOG Mode
[NextPage]
Q. 14 : What performs the Check Point in the absence of a CKPT Process
2. LGWR
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
编辑推荐：
温馨提示：因考试政策、内容不断变化与调整，长理培训网站提供的以上信息仅供参考，如有异议，请考生以权威部门公布的内容为准！ (责任编辑：长理培训)
点击加载更多评论>>