您现在的位置:您现在的位置: 一起学 >> 计算机 >> Oracle认证 >> 试题库 >> 正文

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

来源:网友上传  2012-4-25 22:48:54   【一起学:终身教育引导者
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
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. 来源:网友上传- 试题库

责编:上传用户270176  收藏此页 打印 回到顶部