oracle认证考试试题:OracleDBA审计数据库试题(4)

会计考友

　　5
+ Q7 X& a: n) e) o/ _　　q. 5 : a collection of segments is a (an)
　　1. extent
　　2. segment
: c7 }& _4 P& b2 V　　3. tablespace
$ @* n3 K$ I- [- G$ R　　4. database
; s# u5 }* o6 I, e. V　　6
1 c6 L6 Q- Q  v& v　　q. 6 : when the database is open, which of the following tablespaces must be online
# |. v, s! W. p% x+ S1 J0 J" @　　1. system
3 Z' h9 n+ j/ |( J4 z' i! \( `　　2. temporary
　　3. rollback
　　4. users
' F5 f9 @9 T3 c2 q+ X2 e6 ?& ~　　1
　　q. 7 : sorts can be managed efficiently by assigning ____ tablespace to sort operations.
　　1. sysem
* I0 O+ |8 |% K8 r, N3 m: A9 A; P　　2. temporary
$ k4 ^' W& M/ q1 A+ j$ S　　3. rollback
/ a8 G6 u& s1 l1 k6 \6 t　　4. users

9 G1 W0 i6 z) f. g+ S2 M9 f　　2

会计考友

</p>　　q. 8 : the sort segment of a temporary tablespace is created
4 f: U. V  [5 J3 }$ b. X, N- F　　1. at the time of the first sort operation
　　2. when the temporary tablespace is created
: ~7 J- O: p2 d; i: g( O( q9 W! d  A5 Y　　3. when the memory required for sorting is 1kb
- W- v8 I: W" m& H, b% b　　4. all of the above
, q$ u  x" n2 T2 W5 ?" q1 |　　1
" ]6 H  F  M! h- L6 I6 u& e　　q. 9 : which of the following segments is self administered
　　1. temporary
, g  c' v+ e# C0 t! }　　2. rollback
　　3. cache
7 O; d' c+ T7 F" T　　4. index
　　3
　　q. 10 : what is the default temp
　　orary tablespace, if no temporary tablespace is defined
　　1. rollback
( e- I1 e: V* ?( L& {　　2. users
, {9 l. E) Q; J0 k3 G3 X　　3. index
　　4. system
　　4