1 : the default tablespace clause in the create user command sets the location for
! i3 r4 H: U' r) j+ y9 b2 U8 \
. e1 a& n3 T7 s! b1 z, A8 y/ ] 1. database objects created by the user
K3 l% |% G! y# n 2. temporary objects created by the user
( z! u! x" R' D/ g* u0 A: A; o 3. system objects created by the user
0 L/ F' N% o1 J: j# M 4. none of the above & r3 ?1 p* @- b
- `# J0 S1 x% } q. 2 : what does sessions_per_user in a resource limit set ; ^" B, h1 U1 j5 R& X6 N
" v, v$ d8 d. |# _# M0 j8 u5 q7 J 1. no of concurrent sessions for the database $ z' o& F; l5 Z- G. M6 f* u
2. no of sessions per user 8 K- g% ~' f' {8 X. o
3. no of processes per user
3 F! o9 {. Y1 g" w8 s' B 4. none of the above
- u7 z8 R; X7 s % d; b5 U6 V3 l8 }; u! b
q. 3 : what keyword during the create user command, limits the space used by users objects in the database
. Y7 V( V. d# Z2 l( j5 w 1 G! A% n/ ]/ E( @" t
1. size 4 ?: R9 C- j" }1 y
2. next_extent - ~: w( d) K0 }/ {& z
3. max_extents . V2 E% {6 C5 c' K, k+ h
4. quota
, `4 }+ T, i% [# n$ g
- N$ D6 [+ I Q2 I' i6 j, z , n/ u& e; h. s( f J7 R" d
q. 4 : what value sets the no activity time in minutes before a user is disconnected 5 z; P9 m/ D# M; q/ O% h& A
7 l! @. C$ J7 }- p 1. idle_time
' j7 s* _, f3 u( V& Y# k 2. disconnect_time 2 \. Y' O8 g5 r5 }2 P
3. connect_time * }4 `- e' g6 p% T2 N5 n1 ]9 @
4. none of the above
$ Y: i7 W6 i7 P# m/ d+ f+ x
9 l/ ^& H* F, T$ ]9 e3 f5 N2 z% a* J q. 5 : what operations are limited by the quota on a tablespace ' N1 R, z6 K* j4 n" g; ^* F& j1 {
) `# {% s/ F) Q' N2 D 1. update 9 M" V5 P! W- Z/ g$ X
2. delete
' j1 o' y: v! f" `2 s 3. create " K1 K+ |; t& [5 w& S4 U
4. all of the above |