ORCALDBA有关回滚段管理试题精选

文章作者 100test 发表时间 2007:11:14 12:45:47
来源 100Test.Com百考试题网

　　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.