Q. 1 : When will the rollback information applied in the event of a database crash
1. before the crash occurs
3. immediately after re-opening the database before the recovery
Q. 2 : The data dictionary tables and views are stored in
1. USERS tablespace
3. TEMPORARY tablespace
Q. 3 : Oracle uses the data dictionary tables and views
1. to make the database user friendly
3. to store application data
Q. 4 : No data in any data dictionary tables should be deleted or altered by any user. Which of the following object is an exception to this rule,
1. AUD$
3. USER_HISTORY$
Q. 5 : A collection of segments is a (an)
1. extent
3. tablespace
Q. 6 : When the database is open, which of the following tablespaces must be online
1. SYSTEM
3. ROLLBACK
[NextPage]
Q. 7 : Sorts can be managed efficiently by assigning ____ tablespace to sort operations.
1. SYSEM
3. ROLLBACK
Q. 8 : The sort segment of a temporary tablespace is created
1. at the time of the first sort operation
3. when the memory required for sorting is 1kb
Q. 9 : Which of the following segments is self administered
2. ROLLBACK
4. INDEX
3
Q. 10 : What is the default temporary tablespace, if no temporary tablespace is defined
2. USERS
4. SYSTEM
4
Q. 11 : Rollback segments are used for
1. read consistency
3. recovering the database
Q. 12 : Rollback segment stores
2. new values of the data changed by each transaction
4. none
1
编辑推荐：
温馨提示：因考试政策、内容不断变化与调整，长理培训网站提供的以上信息仅供参考，如有异议，请考生以权威部门公布的内容为准！ (责任编辑：长理培训)
点击加载更多评论>>