q. 1 : what option of exporting allows quicker data extractions
( D1 y8 g" F) ^( z/ H
2 M* }* @+ \/ W+ _8 _ 1. grants =y
0 }: r* Q) {) T8 l0 y4 @2 p 2. consistent =y. b. G$ {4 b( W t0 K ?8 _4 c' K" J
3. direct = true; t$ ]' N# j/ J: Z Q$ E. H% u
4. direct=y
6 W- q$ o: d4 B, Z4 }6 m$ b" k- r- q+ \7 D( C u
4 : direct=y option bypasses the sql layer to allow quicker data extractions A8 O E7 g4 p8 ?( [7 `, I
# n" p2 Q6 f. K2 R: ?+ A m$ Z
q. 2 : how are exports useful ?! P* H7 d0 b6 I; C# K5 F
; W& j- _3 Z9 N8 G
1. can be used to recover to a point in time
S/ A' Q/ R- ?# ^5 m! ? 2. can be used to recover from a media failure
7 x+ e% W8 M' B4 z) F( u) Z 3. can be used to recover dropped tables due a user error
; F5 s! K D* @: r% V 4. none of the above
& D; k# F$ x, @8 j+ k$ m) t; ?( I# T6 N
6 u# a8 I& Q7 m8 y; }& \ 3
* v$ E" @( N( `0 n
- i5 T. h5 V+ A. P q. 3 : what are the 3 levels of exports
g# U k R) F+ b8 j* T$ w
. J' |8 Q" h1 J" H 1. global, user, tablespace- K' D8 h' X9 N, h6 d% \
2. full, user, table9 A( ?7 J& x( u5 t
3. full, tablespace, table* V% p; G; `* s# }3 N- _
4. global, local, transactional. X0 K% H* v6 D; K5 ~% c+ L
, T: K5 ^/ F! H5 p, _* H V 2+ a- G, ]: e1 ^9 k
/ O, ^& g+ [8 i* t/ r, A+ D, n q. 4 : the following methods can be used to run exports1 I2 U9 r' t6 B5 L& Z) f: q
9 S/ ?6 D d! C: P
1. interactive dialog
" a+ f( ~; S) |( L. ^! ]0 D; u% B6 w 2. export section of data manager in oem
; q8 W. {% v1 x. ^% o0 O. w0 L 3. command line interface with parameter file
9 X, v* d/ @: c" H 4. all of the above
6 R' p, {! `( ^7 j% H# r% s6 X, @9 ]" V' e A F" @$ K, ?4 `" n
4+ P2 ~6 H2 y0 D9 i; i9 E- i6 ]- { G
+ V: O4 ]. y4 e; k& w. S+ Z q. 5 : which of the following are valid parameters for an export utility
: J; x: R8 L1 `8 l! V) D5 k
8 I8 }5 m- I7 b& U- h: d 1. log5 t Q) E0 g( X) r4 F! q; Z2 V
2. statistics+ m: ~9 h8 `6 e8 A8 N. [
3. direct
$ n# n$ _/ [8 x) I# o* U: v7 E 4. all of the above
/ ?' `; K! ^: g# C: k/ E- [ _: A+ m
49 Q# S) _* `/ a2 L, d) f8 I& L( d' y
4 t, t3 z( k9 w
q. 6 : what incremental parameters can be used with exports, [! L/ O0 r8 D
3 \5 Q, X8 F P# O; J# D) o7 D 1. inctype = complete5 L- j& n2 i6 c0 i. w- V8 d
2. inctype = cumulative# v5 O; c4 T$ @. j5 a8 d
3. inctype = incremental
$ Q* z5 m+ p2 P0 X/ F# a 4. all of the above4 o+ |0 s& `( F: j
( t0 l+ f! f* E4 S 4 |
发表于 2012-8-4 14:01:27
