注:答案在选项后面 # V, U/ T8 t7 B* D
q. 1 : this symbol, when you put infront of a line in the parameter file, signifies a comment 4 [% f1 S H3 L, u* I
1. $
1 [7 J; R! f- S0 F2 g0 R 2. @
5 k. r: `, X3 |' m+ C( A0 i5 W 3. # # n: m2 e( t; f: [
4. ! ! A8 }3 B! u$ t Q& e/ K9 J/ t
3 ' Y+ g* P: R1 i: M4 \3 B
q. 2 : when you change a parameter value in the parameter file, when will that change takes affect?
! o* C' p# A7 B 1. immediately after saving the parameter file
4 n0 K* Y- ~$ t+ Y" |$ A( h; S 2. at the first checkpoint after saving the paramter file ) s) I. v+ t9 l
3. when the dbwr finishes writing all the dirty buffers to the disk 6 f% [2 d. u2 \/ T
4. at the next instance startup
$ c; X1 H0 a0 q+ S% G! A( H 4 - v! i5 h5 ]! {2 V6 b+ Q
q. 3 : alter system deffered command modifies the global parameters for
5 x2 `+ n7 U) Y9 ` 1. existing sessions after a certain amount of time / H- `2 [) E* t/ r! Q# L6 u. @
2. new sessions only 1 i& Z% ]/ C# q0 v
3. existing and new sessions
- r3 \5 s7 u: R8 B( A: S9 V# z 4. depends on the spin_count initialization parameter ' f) @) T/ {$ B+ I
2 ; _0 y0 M' E4 g Y8 w
q. 4 : the location where debugging trace files for back ground processes are written, is specified by
+ k- X: A/ p; _0 V1 `3 F 1. logfile_dest 2 R( `. Q. D) S$ N
2. oracle_home / \7 ?1 h/ V; U* Y5 x4 h3 [
3. background_dump_dest
' x, e$ s: u/ e 4. core_dump_dest $ z$ j( S8 ~/ ?9 E
3 4 ]7 ~$ c! w5 {% Z7 M- w
q. 5 : in case of heavy contention for latches,set the log_simultaneous_copies initialization parameter to . f* ~/ L, \8 I) I
1. twice the number of cpus # i7 G! J6 v8 K4 `+ D' R# h
2. same as the db block buffers
8 c% }' w2 L4 g) R2 ^ 3. same as the shared pool size . H" H/ q2 o- P4 l2 g
4. none of the above
' Y: ~8 ?; M* G, c' I E+ ~9 z 4 . b$ ?; E( |3 a- x6 P+ b+ p
q. 6 : what is the first step in manually creating a new database ! S. Y1 x/ T+ |+ e% q3 b2 h
1. startup an instance
7 f8 I: A+ h4 u, k" }3 ] 2. start sql*plus and connect to oracle as sysdba 4 p2 } x. j/ v0 w" C. s& z
3. check the instance identifier for your system $ F Y* v+ \$ `: L; [/ X$ L% f
4. create a parameter file
9 ^: |* A& q' j1 C0 ^ 4
- \5 x5 [2 b! ?: N" {8 m) l1 V q. 7 : which of the following is true regarding control files
" R( L- j. e; ^ Q: S, w* H 1. oracle recommeds atleast two control files stored on two separate disks
1 v( Y* V/ n5 G! B1 k3 w4 h 2. oracle recommeds atleast two control files stored on one disk
5 A) K3 d8 d5 t+ a3 _! _2 W 3. oracle recommeds to store one control file
% O# f: l& i7 ?; r5 R @' h( T2 R* L 4. one control file is not enough to run a database
& z& t Y9 c8 y1 `' b 1 / N# ^% D2 f2 ^; g
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 |