1
: C0 D. E9 i; A# m8 o3 m bq. 1 : when will the rollback information applied in the event of a database crash 7 J% i" h. T$ N+ m* R; n
1. before the crash occurs
3 m+ ?$ l4 ~1 Q7 \2. after the recovery is complete ! ~( z8 N: J; y7 N- l
3. immediately after re-opening the database before the recovery
( w( w- @1 j% X; W( u0 L$ j4. roll back infrmation is never applied if the database crashes + g0 y6 T# V8 h% h- I0 L" l5 y) j1 w
2 ; S2 l) t- F+ H; E
q. 2 : the data dictionary tables and views are stored in ) n/ T% _# r0 @ Q: l& F. L/ ~
1. users tablespace & B1 `4 n" X# }9 v8 H
2. system tablespace
# t' v: W; p2 {2 T$ X$ |: B3. temporary tablespace , r# r/ ?0 s0 w' w$ ^
4. any of the three
' R" K0 \9 ^& P- w3
) d( B* D, U1 k: F% H3 }q. 3 : oracle uses the data dictionary tables and views ) y% ^5 I' V1 S- D
1. to make the database user friendly
6 D/ Y8 }! b+ L$ t2. to store user data 5 l" }/ w* x3 v
3. to store application data 7 K2 _: ~$ z! K" K# X8 ?. y2 i
4. for proper database functioning 2 m% ?2 \, o! [
4
2 f# L9 Y- r7 i# z, Q3 z, F8 Eq. 4 : no data in any data dictionary tables should be deleted or altered by any user. which of the following object is an exception to this rule, % G4 {8 \$ G# \2 \- Y
1. aud$ 5 U* L3 [/ W1 z# [0 _8 e9 ?$ S7 f
2. pending_sessions$
8 h" b2 R/ ?) q, x+ E3. user_history$
, L# V' R2 X' R2 U$ t) b# o. u4. pending_trans$
8 h$ j; s- R l2 {5 8 }% I( \ z# N" V
q. 5 : a collection of segments is a (an)
5 e3 @! b) d0 @1. extent ) {7 \' X& C$ T3 Y9 s" p
2. segment
) K4 r3 x0 r3 e* E- M0 t1 `1 k3. tablespace / i7 l( @5 [: L% f" b
4. database " [2 H8 @* q" x$ c% ]7 N2 |
6
* g) Y# U+ ~% Z5 e; m1 i; oq. 6 : when the database is open, which of the following tablespaces must be online - j6 X# t, E6 O0 `! G, ]. }0 i
1. system
U8 o+ ^, N& W: G p% D2. temporary
& K, S( B; N) b: _: ^1 a, V( V3. rollback
3 [: V# O8 ~! T' b) }! k A4. users |