19 h# R4 J8 g- ^- h
q. 1 : when will the rollback information applied in the event of a database crash 3 L" Z9 u- s) i' |; L; ~3 Q2 v3 C
1. before the crash occurs 5 P L% M5 @$ e8 ?
2. after the recovery is complete + G# ~0 w& b$ [4 R8 }/ j
3. immediately after re-opening the database before the recovery
# `, _) {1 v5 t5 j4 U4. roll back infrmation is never applied if the database crashes 2 6 ]2 n3 ?' v: x4 T' O! y
q. 2 : the data dictionary tables and views are stored in 8 |; t$ x$ ~/ u
1. users tablespace
- P4 ]% R2 {9 G$ h& X' L1 d2. system tablespace
9 k8 Q1 j1 C9 B3. temporary tablespace ; S& U, R' @8 }; W( k: H
4. any of the three . G4 j/ Q2 K7 n; L5 B
3
, E w% N" o% n. O9 m0 K! tq. 3 : oracle uses the data dictionary tables and views
4 q3 l+ t" ?% y" ?! V3 _1. to make the database user friendly
) s" X! a; ?" u/ F4 n! R9 d& r2. to store user data 6 e ~$ t/ U# o. C2 G- R; s# m. n
3. to store application data
/ K' R5 c7 K8 f8 P3 {1 ]- ?4. for proper database functioning
+ Q! S' T+ U1 c! r" p0 V2 @4
+ T3 {" @* x o( A3 |( z6 mq. 4 : no data in any data dictionary tables should be deleted or altered by any user. which of the following object is an exception to this rule,
/ b) X ]# L9 c: P* K' |1. aud$
0 b3 H I6 d3 L0 Z; k) }1 C2. pending_sessions$
5 p, B: S5 D+ Y( S3. user_history$ * `7 y8 a+ u; o
4. pending_trans$
2 U9 }# z8 }5 m; \4 C5
S8 S" e; I; i7 o$ f. t$ a, i+ _q. 5 : a collection of segments is a (an) * _ a6 |. j2 v: r! [# j
1. extent
: c' x8 B# Q1 a# R8 h2. segment ; n9 G, j7 x! Q# q8 T2 h
3. tablespace " g# ] ?5 K. _9 l! ^$ ]2 L
4. database
. t% k4 B8 H U8 L6 4 g& L( T+ J% U( P4 P
q. 6 : when the database is open, which of the following tablespaces must be online
* k) r9 m' p, y* O# i/ f, b# Z3 y1. system
6 T6 g% N3 U: A! g7 k4 \! g, @2. temporary ( U" @/ ]! g7 U* W
3. rollback
, O9 I* L5 x; e' _5 E, E! v9 D4. users
* o; c# q7 S& g6 H' T5 b5 P4 ` 1
7 s! f7 h4 j/ ~; V2 e * C6 _4 f+ k: k+ {2 h. E, m
[nextpage]
# g5 r1 s) R) i3 A Q7 h, j/ b8 W6 U* [ ' C6 ^, E/ H& O
q. 7 : sorts can be managed efficiently by assigning ____ tablespace to sort operations.
/ V" H8 @: P0 _9 R% h
. P9 q( Y1 @% E: b3 Q, J 1. sysem ( R' _; T# L/ y* t$ p2 O
2. temporary ; U t; d- p$ ^, `3 s: t0 }0 [0 v
3. rollback N/ b f2 @: I7 k% v2 Y8 ?
4. users 7 \5 t0 [$ a7 W' ] g! G" O" G( y
" m6 @; h0 g' ^( s& B4 I$ f 2 9 k- ?& V% D2 [( X X/ l+ `
: }7 t# J7 B2 O. D3 s
q. 8 : the sort segment of a temporary tablespace is created ' i/ G4 t$ l3 D/ N3 M. }. m
0 e6 S7 k+ [' k- X 1. at the time of the first sort operation
/ u, `! h9 X/ k6 z9 Y G 2. when the temporary tablespace is created S' \) I; b: h- Y9 S
3. when the memory required for sorting is 1kb / Y' N, }4 k; N4 d E+ V9 u
4. all of the above " K: V! ^7 X, b* z1 Z
6 ]) T; m' z8 A1 f6 Y& E: x) E 1 9 T& n0 p/ ]1 A* J
8 t P3 k8 g. C6 h) |
q. 9 : which of the following segments is self administered
- E; C, p% Z, ^0 y2 q2 c0 U
1 c m% Z* V* S4 [$ z0 k 1. temporary / H9 Y; `4 g# l# v7 S& P h
2. rollback
( A: P, j# w- l# v/ ]! K! k 3. cache
: D+ K; R0 U9 \) q* P 4. index
" q: u0 ]8 g: g: X) ^
% V2 Z! b1 B5 ?# o% \2 \1 l/ j# }4 C 3
$ g( i: c# q6 m. G9 P4 q
" I# J9 C, P7 C6 K U# e q. 10 : what is the default temporary tablespace, if no temporary tablespace is defined K: i( W( U/ J6 x p1 L- z! s
0 t! u& c: ~; v5 d% f% F/ e 1. rollback ' H+ z) K* W* y o. n% D
2. users
/ r$ I2 J4 F+ b$ [5 m 3. index
# ^0 i& b8 D2 ~) D 4. system , C! Y- [! k) q6 z
/ N. D; j: t' i: [1 A! U- L 4
1 w$ K4 _& O) S5 C1 x; Y) K
6 N" [1 B% p$ ]- C7 j q. 11 : rollback segments are used for |
发表于 2012-8-4 14:01:27
