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 本新闻共2页,当前在第1页 1 2
