Q. 1 : Physical Disk Resources in an Oracle Database are
- g3 p' H7 F2 o& \* r' ] 1. Control Files 8 J/ g( K4 U3 }- Y5 g \8 i9 @2 n
2. Redo Log Files
5 {( K/ L: B. u! E8 i 3. Data Files $ y- c7 z4 \! o( ?" j, B; W
4. All of the above
. J3 ]* h3 t" p: o 4
7 ? Q' D, R) r2 } Q. 2 : What is a Schema
! Z9 Y) C8 G) Y$ V8 ? 1. A Physical Organization of Objects in the Database
7 d0 u8 U6 [+ V( @1 _" Y* N/ p 2. A Logical Organization of Objects in the Database $ d4 n+ E/ Z, `8 @# [6 D5 i
3. A Scheme Of Indexing & f9 X7 L" \( s/ ]9 y
4. None of the above
9 h* K# ~' o* `; N 2
0 \* s( C! C4 P6 V Q. 3 : An Oracle Instance is
, v3 C, Z0 z! `+ ^ 1. Oracle Memory Structures
* |/ g9 _$ X6 @* j 2. Oracle I/O Structures d5 k- L' ?; o# w! t& K
3. Oracle Background Processes
, F. O0 I& Z) C U& d) } 4. All of the Above 4 z) n+ |, f5 G
4 : Z7 o/ q& y4 b M5 N4 ^% z
Q. 4 : The SGA Consists of the Following Items 2 u5 ~* n3 Q5 M
1. Buffer Cache
8 l7 h, ~: m' t 2. Shared Pool 1 y6 Y" S: z4 h: e
3. Redo Log Buffer 8 S6 {3 \: n+ X7 E5 `& R0 a
4. All of the Above u7 e4 s2 o; X, T: }& V. I5 b$ A
4 # W. W9 Q0 M: o7 X1 o2 q) _
Q. 5 : The area that stores the blocks recently used by SQL statements is called
. A) F# h" q6 F; r 1. Shared Pool $ q+ X/ h9 O+ o' @6 J, L3 S+ Q: d7 ^
2. Buffer Cache ' Y/ h; G. S7 K" S- ^
3. PGA
5 @ N9 a" ^: k4 M 4. UGA % H8 l: d* y9 E i
2 |