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

会计考友

　　1
　　q. 1 : when will the rollback information applied in the event of a database crash
　　1. before the crash occurs
* N) N3 ~# Q( |7 x+ _5 x% N! ]' R8 W　　2. after the recovery is complete
" l) r9 x4 X1 H% L　　3. immediately after re-opening the database before the recovery
　　4. roll back infrmation is never applied if the database crashes
0 U! `& p; z& M4 K+ d2 k　　2
　　q. 2 : the data dictionary tables and views are stored in
　　1. users tablespace
　　2. system tablespace
# H9 g1 }! e8 u; t! z& S/ X　　3. temporary tablespace
　　4. any of the three
# r. w/ I- @1 ]* y3 P7 @( W' q) ~　　3
3 V; q& [4 o5 K! B* U, p$ V) z8 g　　q. 3 : oracle uses the data dictionary tables and views
4 M5 l9 w2 v, E- O　　1. to make the database user friendly
4 x% W+ t4 V  N2 Y  L, d' `- ^5 A7 q　　2. to store user data
　　3. to store application data
　　4. for proper database functioning
　　4
1 m$ s  Y* L! w: s　　q. 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,
  Z; _, `# K% t9 D　　1. aud$
' q! e; G0 O$ h- G; }　　2. pend