q. 1 : what feature in oracle allows you to monitor suspicious activity on the datbase
V" @) s+ p6 L4 L3 D 5 Y/ ?: ~: m( G% A' O1 l, r( k0 e
1. replication % Y. I4 L( E+ r& H: V0 ?
2. auditing
0 R. |! _/ @4 {& x& z. U 3. monitoring 6 K& l1 G+ c/ b! i# k# \
4. tuning
4 |0 S& b2 h$ _2 s/ {2 M
# z/ W2 q G1 ]2 o v0 G, `1 i! Z q. 2 : auditing can be turned on by setting this parameter 1 s2 D9 T; i& n# h4 H
+ g5 H* \3 B3 e3 O 1. db_audit_trail
& S( I- p8 U% c 2. audit_trail
" Y1 `7 P% a3 r- j' O) d 3. audit_db " ~: t( r7 @$ v) C9 V# c* A
4. none of the above * p! p# b" {7 f5 I
+ A1 Z" f7 n! Z7 j q. 3 : what are the valid values for audit_trail parameter $ O7 i* w; e- f% ^
- n9 T! Q8 K! u2 ?# c 1. db 1 h( b/ [- r) j) Z! G
2. os
) u3 k% `2 c4 Z6 C5 [* i1 V+ ^+ S 3. none
' s) r6 ]/ ?. _7 W 4. all of the above ( j! C* P8 a1 d/ `
, T& k, J. k7 a6 I: ^5 T5 A& l: Q
q. 4 : where are the records stored if the following value is set in the parameter file. "audit_trail=db" * Z! V/ B7 i! v7 W8 `1 L7 t
% w3 K; a6 y. q% e6 T" N 1. database
% t X3 ` g( D 2. operating system file - r; {. t u& _; [9 e/ k1 Q( ^
3. tape , i9 A7 T. a) q/ t' A* ?* x
4. none of the above ) M$ [$ k. t- f
1 }- s0 E: c+ J5 h# y1 k q. 5 : where is the audit information written to when the audit_trail parameter is set to none ! |" ]1 n! |5 q, u& g; E) u# p
1 g( F' v H# [1 \
1. parameter file
8 B6 _) V' d6 m 2. redo log , J% R' f y$ n3 O
3. os file
% ]3 D& |+ x3 d* y1 t. f$ C 4. audit trail is not turned on |
发表于 2012-8-4 14:01:27
