来源:Oracle认证 发布时间:2012-11-12 Oracle认证视频 评论
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
① 凡本网注明稿件来源为"原创"的所有文字、图片和音视频稿件,版权均属本网所有。任何媒体、网站或个人转载、链接转贴或以其他方式复制发表时必须注明"稿件来源:我考网",违者本网将依法追究责任;
② 本网部分稿件来源于网络,任何单位或个人认为我考网发布的内容可能涉嫌侵犯其合法权益,应该及时向我考网书面反馈,并提供身份证明、权属证明及详细侵权情况证明,我考网在收到上述法律文件后,将会尽快移除被控侵权内容。