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

会计考友

Q. 1 ： What system privilege is required to create a rollback segment ？
1. Create database
7 x/ R: I/ j% l) o2. Create rollback segment
+ ^( j1 W1 U# U( G# B, z; `3. Alter database
4. Create segment
( I8 y  @, \3 H2 Y5 T. QKEY:2
! x$ Z* s2 z) A' K* q2 _# X% HQ. 2 ： recommends this number of minimum extents in a rollback segment
1. 0
1 H5 T; p- ^( g2 w( B/ ]) a& T2. 1
' z% ]1 J7 Q' H; ]' ?2 E& S' U: P. y3. 2
! G" B, U4 ~) ~9 o0 ?4. 3
4 n5 |  K9 x) k- A1 B9 `KEY:3
6 \" B! F9 A6 \0 B5 @! M& hQ. 3 ： Oracle recommends that the following segment size when creating a rollback segment
5 h5 }( u0 Q; v1 Q$ N9 u7 ~) n9 ^) u  H1. INITIAL 》 NEXT
8 F) p9 G" }7 Y% E' P0 h- S2. INITIAL = NEXT
3. INITIAL 《 NEXT
4. NONE OF THE ABOVE
: L3 E% D7 b6 \" v( T4 qKEY:2
7 [$ @, D$ |+ IQ. 4 ： The OPTIMAL parameter for a rollback segment should be set
1. large for long-frequently running transactions， small for short transactions.
- q, Y! J1 g: |6 ], S2. small for long-frequently running transactions， large for small transactions.
3. small for all transactions
4. large for all transactions
KEY:1
Q. 5 ： In case of system failure， This type of segment is used to undo the changes
1. Data Segment
- j* E3 F3 D8 \  _: I2. 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.
2 Y, t- O: o) H1 SQ. 6 ： This is a valid storage parameter when creating a rollback segment
1. FREELISTS
5 C' }$ o8 n) ?0 D! [) l8 E3 |2. OPTIMAL
3. PARTITION
4. NONE OF THE ABOVE
+ K% a6 J% p& ]/ Q# y( R3 y% tKEY: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
! I' S- `/ E; R/ u) m6 n- W* O* i) |2. Add rollback_segments=（rbs1，rbs2） in parameter file
3. Drop segments and recreate them as protected
4. None of the above
+ Z% f- k& v' z  ~1 ?& g* EKEY:2
* Q3 \5 n6 Y$ L7 @8 X" h8 @Q. 8 ： Which is true regarding rollback segments
' ?' w9 |! g  S* T1. System Rollback Segment Cannot be put in an offline mode
1 Q7 x5 G# L4 c; A2. Tablespaces containing rollback segments with active transactions can be put in offline mode
3. All of the above
4. None of the above
KEY:1
Q. 9 ： A rollback segment ____
$ J; q9 ~% @" W4 P. E' G- O1. writes to the redo logs
# P& K! b( M0 q  y" n; q4 Q2. requires one for each tablespace
3. records changes only after they are committed
4. provides for read consistency
KEY:4
" j  T* e8 x3 P4 ]; JQ. 10 ： Which type of segment can record changes for multiple transactions
. z. B$ @# H" ~: c3 f& S7 b1. DATA SEGMENT
2. TEMP SEGMENT
3. ROLLBACK
8 k4 O+ T) b2 C7 b9 n% k' i. `4. NONE OF THE ABOVE
KEY:3
Q. 11 ： The type of rollback segment that is created when a tablespace goes offline is
1. PRIVATE
/ b6 \9 N  C2 G, n2. PUBLIC
3. DEFFERED
. x8 z' X( G/ O9 Q. g- H  p4. PROTECTED