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 > 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.