1 : the default tablespace clause in the create user command sets the location for 5 ^; M/ Y: c; k# ^- E
W9 j9 P* p1 @7 } 1. database objects created by the user
7 H: ]/ ~1 H3 ^ 2. temporary objects created by the user
' G. U# W) W2 W7 y# q6 k# `% p/ f3 ^ 3. system objects created by the user / e* R% ]# y- ]- \# L- E1 r7 q% u& F
4. none of the above " z' }# ~/ a# s7 j9 B7 q. l+ t
# \4 \2 I" ]% \9 [ q. 2 : what does sessions_per_user in a resource limit set
. e- L3 ]$ p9 k* c % b/ f+ Z: t# {# C
1. no of concurrent sessions for the database + y5 L0 S6 T- [* }+ K7 i3 j( r
2. no of sessions per user & T) ~$ S: H, P8 Q. \1 r7 _! Z8 ~
3. no of processes per user
- v7 J: Y/ U: f- u0 J- U. N+ o 4. none of the above
1 O8 u n! A" l4 ]
9 p) I2 d' J* |, P3 [9 \ q. 3 : what keyword during the create user command, limits the space used by users objects in the database
0 z! y( W9 u$ P# v+ n0 f$ ^9 Y0 w - M b; o, F! Q) Y
1. size
8 U, ?9 p5 r# ^/ p) K 2. next_extent
( T% k+ J7 V7 M) S" Q 3. max_extents
) d9 ~8 F9 k; [/ z% J 4. quota $ v/ j" `$ H- h1 U2 r$ d
; ]- ]- J, ?5 p& u2 o7 E8 G$ t1 c
0 m9 G5 R* e q9 ^# _' I- B q. 4 : what value sets the no activity time in minutes before a user is disconnected 2 p4 ~# Y" ~" d2 A9 F0 v
Z' J" \# @4 ^. `
1. idle_time
6 f! H0 a9 y+ y/ j: ?2 X5 T 2. disconnect_time
% H5 S- |. W* [( W 3. connect_time
# [4 m- M; k, }* H3 J/ r 4. none of the above ; o7 q! W: T6 |! Y8 d6 z
6 Y& b" S' p/ b9 ~ q. 5 : what operations are limited by the quota on a tablespace
& @2 ^5 k9 X+ i 4 y, Q* Y- x* P+ r; G& \
1. update
* ?7 e, ]: Z# s* H1 U 2. delete " `: b+ b3 O! d6 T
3. create / {! T" | f+ R5 H, B/ y" C
4. all of the above |
发表于 2012-8-4 14:01:27
