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

会计考友

Q. 1 ： What system privilege is required to create a rollback segment ？
1. Create database
9 h" q1 n3 P- v' \* t2. Create rollback segment
3. Alter database
4. Create segment
. J) x( \: ^  {7 D' ~; RKEY:2
! ^, y" Y% m* p) O2 iQ. 2 ： recommends this number of minimum extents in a rollback segment
1 O* U  l4 j& |- Y0 s1. 0
! O+ T! E* X/ ?0 E  Q$ d2. 1
3. 2
$ }+ m, {& d# e- l$ |0 l4. 3
KEY:3
* ^7 ]% R# L0 H# ]( N* xQ. 3 ： Oracle recommends that the following segment size when creating a rollback segment
1. INITIAL 》 NEXT
7 j8 M+ Y( z3 h" a' N( X# @* M2. INITIAL = NEXT
- }/ N/ x3 G+ [1 Q9 N; ^; ?3. INITIAL 《 NEXT
4. NONE OF THE ABOVE
KEY: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.
0 F7 _/ S) P+ P. q& D3. small for all transactions
* v, t7 u, a5 o+ I4. large for all transactions
" ?0 N4 r; ?8 ^% L+ J/ h5 l# c% mKEY:1
! i6 K: }" h) z7 [6 n3 b1 R4 U& gQ. 5 ： In case of system failure， This type of segment is used to undo the changes
1. Data Segment
" }4 S, t/ N2 P9 z6 H2. Temp Segment
3. Redo Segment
4. Rollback Segment

会计考友

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
* _$ |, _9 U5 b! O" S2. OPTIMAL
3. PARTITION
3 z: k, E9 R7 R. ?% h9 N4. 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
) ^6 ]  u0 T& |2 h. P1. Grant online during startup to the segments
9 `0 v4 K3 I- C2. Add rollback_segments=（rbs1，rbs2） in parameter file
3. Drop segments and recreate them as protected
4. None of the above
KEY:2
9 {) i: V/ H, T& CQ. 8 ： Which is true regarding rollback segments
8 ^1 ?/ v& Q- E) Q1. System Rollback Segment Cannot be put in an offline mode
7 ?) d, |3 V" I! b2. Tablespaces containing rollback segments with active transactions can be put in offline mode
3. All of the above
' C8 R% k  S) k/ S, V5 l0 s4. None of the above
  Z) y  M# A1 E1 X* ~+ j  gKEY:1
Q. 9 ： A rollback segment ____
3 Q, x5 U& Y- k! u/ k1. writes to the redo logs
. K; ~2 _  n) A6 s! u2. requires one for each tablespace
2 D/ w- Q/ ~1 g0 u1 d3. records changes only after they are committed
' K4 R& E% u% V4. provides for read consistency
KEY:4
Q. 10 ： Which type of segment can record changes for multiple transactions
1. DATA SEGMENT
2. TEMP SEGMENT
* H8 t* k! R. Z3 g4 T3. ROLLBACK
/ N# ?7 l7 i: e+ X4. NONE OF THE ABOVE
  I) h* E# ]9 s9 U" aKEY:3
5 ]# c& t) ^& |7 wQ. 11 ： The type of rollback segment that is created when a tablespace goes offline is
# Y, G  ?+ w$ C6 r" P1. PRIVATE
& ]  D3 W: _, r5 W2. PUBLIC
8 M9 H  Z6 P& d3. DEFFERED
4. PROTECTED