Q. 1 : When will the rollback information applied in the event of a database crash
+ x+ k* e! {' N7 T . ^4 o7 `$ N; e( a& @2 r
1. before the crash occurs 3 N6 |5 h4 U* P. K
2. after the recovery is complete $ r' R3 f, c& a" H9 W
3. immediately after re-opening the database before the recovery & T! z& [8 P6 N0 K3 Z
4. roll back infrmation is never applied if the database crashes 0 Z0 d3 P7 y1 L3 o k0 R, k
8 O* N: _) M) d0 |, W
2 # l& m; J) M5 n+ L, g! \% k) ^
H* A5 y8 M/ l* H7 r4 I; S n Q. 2 : The data dictionary tables and views are stored in : H9 b- T. J+ Z' C- w
. T) }& h5 k; Q4 L/ h2 k% p 1. USERS tablespace ; t3 N, I1 k: Q5 ]( A7 W
2. SYSTEM tablespace - m; C- O' K5 _5 Q& l+ L" j7 z2 O3 N
3. TEMPORARY tablespace
. l7 n% s3 ^1 v6 u/ m4 }9 K 4. any of the three
: Y2 c2 h+ h0 Z $ y" V+ [' K" p4 ?
3 1 w- P! w8 c$ X
% o9 ]6 e" B, b6 J Q. 3 : Oracle uses the data dictionary tables and views
% u& H5 {" K3 s6 `0 f0 P4 g4 V' z7 D 2 ?( }" |6 e/ K0 D1 Q6 C r8 |) |
1. to make the database user friendly 9 ~1 q1 m) h, A2 W3 r! W
2. to store user data - F$ P: G6 ]( f) s
3. to store application data
V h# x, o5 h$ |; J 4. for proper database functioning $ D( ?) O* q+ z5 U' `( W% w
5 Y/ a; W( @/ N* O 4
; a# f6 m4 w, Z! }
6 H/ g2 r; p! o1 k9 ]( E6 o. W
6 S% Q' I) z8 z Q. 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, 3 u) U; w3 Q o$ h( k
9 E& U# m _; O6 `
1. AUD$
7 z; d3 o' _, ?% l s4 K9 M 2. PENDING_SESSIONS$
) G* `: e" P6 N( p 3. USER_HISTORY$ : p$ J& `8 H' o) [) q) p
4. PENDING_TRANS$ 0 X* y; B0 r6 {4 k6 N# R
* a1 O# k5 n5 z+ z 1
2 x e. h G' u* Z+ c& q) A. a- E
[' Z' f- ?8 u& }3 m0 c( v9 L Q. 5 : A collection of segments is a (an)
8 e4 i3 L1 n8 M! ^; ?0 n; q% b @: q ; I. d* \' O- K7 \% y8 A
1. extent 6 o% e+ b' Y5 I' J) ^* u( G" F) c
2. segment ( d2 {7 r1 i! I; H% K" d/ x
3. tablespace
% y- \" v$ X3 z: m2 g. C# T1 H$ P 4. database / v- T+ Q) M0 Y7 \
: Y7 ]% p, Q u! b9 I) V* |
3
9 _/ e$ J8 M0 \4 a* r: N
+ o# i: }0 a$ U7 s2 J# I Q. 6 : When the database is open, which of the following tablespaces must be online
) @& E9 M+ j" e$ T% z! W " |- u% \& g1 R) {1 O) q. X: b
1. SYSTEM 2 i) V8 F6 P, l" g
2. TEMPORARY
, t- f2 f5 \) `- B 3. ROLLBACK
* [$ n" }& s q 4. USERS |