快捷搜索:

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

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 %26gt; NEXT

2. INITIAL = NEXT

3. INITIAL %26lt; 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.

您可能还会对下面的文章感兴趣: