2 ; r8 M' d9 D3 I$ i/ L
* `- t* X3 E- r& y) p
q. 6 : which of the following is not a background server process in an oracle server
( W3 W Z$ X8 o& T, V% f
5 t, U7 i, k H+ I5 | 1. db writer ! B& A. ]' K. q
2. db reader & c9 P' D) e5 j
3. log writer
6 [4 J. [/ W8 L; S0 k( z 4. smon
3 E j z- O; G' Y2 t: f
, ?+ r! A: F1 M% V# w- s 2
- l' ?& i: }) O- m# x! g
+ R) z, }: k( [# h2 J+ Y: o q. 7 : which of the following is a valid background server processes in oracle
$ L! a8 }; C1 ?) [. R2 _. \% e& t' ?, i, `
1. archiver 4 A& O; \( F ?0 a& Q; p' `
2. lgwr ( log writer ) 5 z7 t+ `9 A1 L Q
3. dbwr ( dbwriter ) * g# Q9 Q8 J( r9 n/ Z0 y; e2 H
4. all of the above & ~( a% B+ s! H/ K
+ x+ ^+ t6 F& Z$ G 4 ' J2 k+ i! S; n- y! ]. M
% A/ S2 [7 d0 X/ ]- N( F# w
q. 8 : the process that writes the modified blocks to the data files is 8 W/ J6 V- A& F! s
9 S: A4 I9 V' B" ~9 k0 f( | 1. dbwr 2 o9 e/ F/ n4 n9 J9 [
2. lgwr # e# o% L4 K% S. v( @
3. pmon
, S0 A1 H" R! a5 N v 4. smon 5 K( W, z- @( m' G% r
& t1 [. b" j. Y! e9 f
1 : oracle does not modify the data in data file. once the server process makes a change in the memory, dbwr writes the modified blocks back to disk. 7 I1 W* p. ?! i% {7 E
4 O, H/ E6 _; k& l+ I q. 9 : the process that records information about the changes made by all transactions that commit is
# C! F; q% D8 {/ v
[7 t: n; h7 _3 l 1. dbwr
& I2 Z& D. H2 Z* x$ F 2. smon
$ a$ V7 |! S4 B0 [+ a( J. t 3. ckpt - i; G* H& N5 `
4. none of the above
1 M, G8 C z) j# X6 a) F2 s- e% q) L3 j% _5 f
4 : lgwr process records the information about changes to database
) z) i4 A8 [; x- G9 j7 B* p* i* @; }2 k/ G, Z P4 H% l; z
q. 10 : oracle does not consider a transaction committed until & G( t! Z: m4 T9 F6 T- m
2 [. B3 F3 s8 j, g5 ]
1. the data is written back to the disk by dbwr / `* s: l9 I7 u5 q# s" p7 w( U
2. the lgwr successfully writes the changes to redo a$ k& S+ I0 d+ l7 F1 q
3. pmon process commits the process changes
* w7 v( j( u% f: T 4. smon process writes the data</p> |