课
程
程
资
讯
讯
综
合
合
Q. 1 : What system privilege is required to create a rollback segment ?
1. Create database
2. Create rollback segment
3. Alter database
4. Create segment
KEY:2
Q. 2 : Oracle recommends this number of minimum extents in a rollback segment
1. 0
2. 1
3. 2
4. 3
KEY:3
Q. 3 : Oracle recommends that the following segment size when creating a rollback segment
1. INITIAL NEXT
2. INITIAL = NEXT
3. INITIAL NEXT
4. NONE OF THE ABOVE
KEY:2
KEY:4 : Rollback Segments are used to rollback information that has already been applied to database. During recovery， the database is rolled forward and then backwards to a consistent state. Q. 6 : This is a valid storage parameter when creating a rollback segment
1. FREELISTS
2. OPTIMAL
3. PARTITION
4. NONE OF THE ABOVE
KEY:2
Q. 7 : Madhu created a couple of private rollback segments. What should he do now to make them online automatically during startup
1. Grant online during startup to the segments
2. Add rollback_segments=(rbs1，rbs2) in parameter file
3. Drop segments and recreate them as protected
4. None of the above
KEY:2
Q. 8 : Which is true regarding rollback segm
morewww.examer.cn
KEY:4 : Rollback Segments are used to rollback information that has already been applied to database. During recovery， the database is rolled forward and then backwards to a consistent state.
| 广告合作：400-664-0084 全国热线：400-664-0084 Copyright 2010 - 2017 www.my8848.com 珠峰网 粤ICP备15066211号 珠峰网 版权所有 All Rights Reserved 
|
