q. 1 : physical disk resources in an oracle database are
. Q: j8 C2 M, m* f1 a& V2 {; h1 M! b7 o \
1. control files * Q6 |# x3 w; U! S# U1 X2 I
2. redo log files
& Z! a& }0 Z/ P9 d* n 3. data files 3 f7 B2 s" j! G& O
4. all of the above
" E. s2 [9 k6 i2 P
# x5 @0 p) o/ W+ _ 4 ' J" _8 @$ n0 j. U" Q8 O# k; T
- w% O+ G7 q+ A, v
q. 2 : what is a schema 8 ^% U5 y, e$ g( Y' K( ^7 F- j
- @5 f" }3 M( ?+ Z! s8 o
1. a physical organization of objects in the database 3 W ^6 z& \& G5 \, [# P
2. a logical organization of objects in the database , g- r6 L$ B: N: ~7 r6 E
3. a scheme of indexing
5 I3 I' O2 @0 p' _) `$ ^- Q 4. none of the above
& p0 c5 m) G' o: A' v9 b$ e5 M7 j& @6 U1 Y
2 : Z4 f$ |) A* _# Z% Q* C
8 W+ ^$ d" I. Q! ` q. 3 : an oracle instance is
% j0 u4 @( X1 y1 O( i7 W$ ~
0 h: H; m, [9 l 1. oracle memory structures + ]" b/ \. F3 w
2. oracle i/o structures ' B) f0 b6 `2 r6 v; Z
3. oracle background processes
Y8 ~+ ^/ @) K6 z9 l$ D ~0 @5 n 4. all of the above
5 Z: \- U( e6 M% R# o' Y9 F" N) ?8 L2 B) [" _0 P. V
4 " R H m( k: C9 p- ?5 W* U7 }! o
. i3 j6 l6 t/ l, @( o
q. 4 : the sga consists of the following items 1 w) r% e* x {' R+ n5 U$ ]
& h) C/ y" G% o( d7 \+ z- H" r
1. buffer cache
3 Y! k! a. T/ x8 n5 c" K8 U 2. shared pool
2 j+ }% J8 @4 w/ ~5 V 3. redo log buffer ; I3 `& h) a. V0 x1 O/ k
4. all of the above . B* E0 m( L- x. k- i3 u
2 R" V0 ?( N+ X+ k' } 4
1 h6 A) T0 [ n8 g$ L; j- H% ]) [+ K& l3 @, U2 p
q. 5 : the area that stores the blocks recently used by sql statements is called
2 b: A' q' W7 |. [9 h/ Z s/ @; E# R$ @! s5 v* a4 h, |
1. shared pool ' y2 z' r8 W C6 a. X" S2 o
2. buffer cache
! f! r0 a4 ~" ~ 3. pga
; S" ~$ [, I1 n0 k 4. uga |