注:答案在选项后面 5 h C+ D2 I% C q2 Z
q. 1 : this symbol, when you put infront of a line in the parameter file, signifies a comment
9 [- E5 Y$ J9 c5 B 1. $ b( I/ V( T$ n% Q8 ]
2. @
2 y+ X4 E: Z- Z- Z0 l+ \ 3. #
) d2 N7 l& g2 ^ 4. !
' Y3 m3 [, c0 v0 j9 e; p$ N4 u 3 1 ] P `; R. `1 ~* W
q. 2 : when you change a parameter value in the parameter file, when will that change takes affect?
; p% a+ d' P2 S 1. immediately after saving the parameter file
( b) x) Q0 E ~9 u$ K 2. at the first checkpoint after saving the paramter file ) A3 d* O3 i+ t- t, b
3. when the dbwr finishes writing all the dirty buffers to the disk
3 \1 B) n# F+ t 4. at the next instance startup 3 Z3 Z4 ?9 z0 E0 ]0 y
4
0 S/ [$ v6 ]# {; _& ? q. 3 : alter system deffered command modifies the global parameters for % L% ]1 V7 P. U% h0 ]1 T* ]
1. existing sessions after a certain amount of time
7 W/ U! @' F8 v; K5 g, S G* j 2. new sessions only
( G; ?) a+ @8 H6 i 3. existing and new sessions 1 o, T, d5 n% E& [# j; J# s
4. depends on the spin_count initialization parameter $ }1 [2 M6 n( q6 x7 G$ ^
2 0 o9 ^: V' U& t, T$ b
q. 4 : the location where debugging trace files for back ground processes are written, is specified by
7 O, d1 K( A& F 1. logfile_dest
+ A6 O U7 Q6 j! o1 q7 G' t2 | 2. oracle_home 5 i' O& @& U+ |; i/ N/ C' l
3. background_dump_dest
) [1 @: M$ l" v3 G 4. core_dump_dest * [& d/ x. K6 I9 s/ C
3
; D# o7 c) Y* X q. 5 : in case of heavy contention for latches,set the log_simultaneous_copies initialization parameter to
0 b; P' Z, ^. K* L' u! U! P! m 1. twice the number of cpus
. s+ G1 X: v) Z9 _, R 2. same as the db block buffers 6 X7 E0 i' ^3 q0 B; }: \6 X
3. same as the shared pool size 0 y( q9 L: w! r# Z# ?
4. none of the above
1 R9 h6 S& n/ ^* t9 E; J 4 ! w) g8 f) p1 M6 X- E
q. 6 : what is the first step in manually creating a new database - ^* F% r+ D$ I$ Z7 t* d
1. startup an instance & P8 _1 M- c& o* D
2. start sql*plus and connect to oracle as sysdba " n m2 g& @( X3 Z# g+ ^
3. check the instance identifier for your system
3 S/ j( F* Z# O( T. y1 o 4. create a parameter file
6 j4 d/ e$ R0 q7 L# U! U/ Z 4 / H( e! X2 @. P. S9 @
q. 7 : which of the following is true regarding control files ( K8 h" r3 u' [
1. oracle recommeds atleast two control files stored on two separate disks ; Q M" c+ `. J3 n- ]( t
2. oracle recommeds atleast two control files stored on one disk : C3 ?. o: a1 a: k
3. oracle recommeds to store one control file / f3 R% K$ s" \2 A8 B% l
4. one control file is not enough to run a database
9 j* K: O2 e5 h# J 1
, y- `; Y, u, W8 R7 E; I q. 8 : tom created a database with a db_block_size of 2k, he wants to increase this to 4k, what is his next step |