Q. 1 : Physical Disk Resources in an Oracle Database are / s7 g) A, p" E; }
1. Control Files [: V& M8 Y% J* V* n
2. Redo Log Files 3 W, {" k- W( f9 A5 C5 z) E+ G
3. Data Files $ A% Q2 T$ E. T* w$ e6 N
4. All of the above ( N! V- c' n! L* G+ W. j
4
# ]1 n/ d% ]; L/ }- s1 v; G v( j8 {- ? Q. 2 : What is a Schema : ^* \; E; I+ y' l) v3 l: j
1. A Physical Organization of Objects in the Database
, r" {3 V9 U# @/ d4 l4 ~ 2. A Logical Organization of Objects in the Database
; F$ |3 a( F3 C! C a 3. A Scheme Of Indexing
6 A% k5 o/ i, f1 M* A" x 4. None of the above
o; y& V9 p/ ?, x% ^ 2
6 E" \6 S# s, U: T2 e" V+ S Q. 3 : An Oracle Instance is
3 J; X( W8 @/ ^ 1. Oracle Memory Structures ) b6 H# n# k& n- s1 h' K [% P7 M, M
2. Oracle I/O Structures
$ z4 i/ E' Y$ Q7 L" m 3. Oracle Background Processes ' P/ i% H8 g5 X: Z. l( ~- s
4. All of the Above 5 r e: M5 @6 P1 V$ s ?- C# ]6 q
4 * X+ I4 a% s9 L" A5 {
Q. 4 : The SGA Consists of the Following Items
5 P& o& |1 n, @, J! l$ T1 _ 1. Buffer Cache 8 t0 h$ `2 M, e( J; W4 `
2. Shared Pool ' U/ R& N* y7 w( H& T5 \
3. Redo Log Buffer / q" [5 i2 j8 Q+ z& p+ I5 T
4. All of the Above
2 \* T+ Z; N( z3 K) Q 4 9 d8 Q, |# D2 V- Z
Q. 5 : The area that stores the blocks recently used by SQL statements is called
0 A7 x3 \2 Y0 X# k4 X 1. Shared Pool
& k0 i. Q) e6 W9 W8 S- `/ n 2. Buffer Cache
9 Q" U2 Y) ~$ ^, A4 T 3. PGA
W# a* V1 h+ n5 E( \: e 4. UGA ' u2 B+ a2 c3 w0 }$ V! j4 J! H) Q
2 |