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
2
q. 2 : oracle recommends this number of minimum extents in a rollback segment
1. 0
2. 1
3. 2
4. 3
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
2
q. 4 : the optimal parameter for a rollback segment should be set
1. large for long-frequently running transactions, small for short transactions.
2. small for long-frequently running transactions, large for small transactions.
3. small for all transactions
4. large for all transactions
1
q. 5 : in case of system failure, this type of segment is used to undo the changes
1. data segment
2. temp segment
3. redo segment
4. rollback segment
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
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
2 |
