Q. 1 : Physical Disk Resources in an Oracle Database are 1. Control Files $ e+ M, z5 I& c+ C. I* z* Z
2. Redo Log Files & A% N- P, ?. U9 |7 P/ X
3. Data Files 7 P- y; J. z. W: X
4. All of the above & s# f" x, l0 D; A$ ?
4 ' \$ x; Y' q+ ~8 O
Q. 2 : What is a Schema
" m5 x' K) i/ i! `( q3 J3 y 1. A Physical Organization of Objects in the Database , u) `6 L& e, x8 w3 W
2. A Logical Organization of Objects in the Database
# y9 v6 ?& O2 i6 S, I 3. A Scheme Of Indexing ; A, l4 i/ `) k, Q3 c
4. None of the above
# A. d. q4 N- P 2 & N! C4 R t r$ f
Q. 3 : An Oracle Instance is
! O+ \% |1 b% v1 N7 l- Z4 o* W) D" z) ^ 1. Oracle Memory Structures & x3 `$ u6 K" F$ x" W
2. Oracle I/O Structures 9 k f5 Q. [0 z: R3 S# [
3. Oracle Background Processes
3 G" w* K5 X' v* u; O- Z {4 V+ A8 J 4. All of the Above
+ ~! @" I9 D. V# O, I 4 5 G* l n! a5 R3 |' ~0 L* G
Q. 4 : The SGA Consists of the Following Items
: j! ^, {5 n8 N 1. Buffer Cache
/ z$ I5 k P9 w9 W1 E' \& F 2. Shared Pool
+ z) O' @, p% c2 d- ]6 W& z6 | 3. Redo Log Buffer J+ [# C6 N/ [* f- V" x" j
4. All of the Above
) n# ?7 e# y* b5 `& [+ e$ e( V 4 6 J0 T8 b- F2 X, L; b
Q. 5 : The area that stores the blocks recently used by SQL statements is called
( S( P' A4 Z2 v5 t& ~- z( h' K 1. Shared Pool
! L9 K' k9 ~: C9 w 2. Buffer Cache + D+ {, p0 o* f7 F
3. PGA
6 r; r, x7 r) s2 O" i! S2 d2 a: l 4. UGA + j$ P* i. @. P9 r
2 |