Oracle考试真题精选（附答案）

会计考友

本试卷共包含Oracle DBA逻辑备份、Oracle DBA创建数据库、Oracle DBA存储管理、Oracle DBA回滚段管理、Oracle DBA用户管理、Oracle DBA审计数据库六大部分试题。

/ w" o: B% |  i" d, `$ b例： Oracle DBA逻辑备份试题部分
q. 1 : what option of exporting allows quicker data extractions
1. grants =y
. k2 |' |! J( H4 t; x6 e6 o2. consistent =y
. v; a9 w" s. U" _  |! x3. direct = true
) L9 G0 k- m. X0 a4 i0 {7 s* B. {4. direct=y
答：4 : direct=y option bypasses the sql layer to allow quicker data extractions
. Q! t% i6 N/ P  k' ?

......
4 i6 c. Z5 o2 f# WOracle DBA创建数据库试题部分

会计考友

</p>q.1:this symbol, when you put infront of a line in the parameter file, signifies a comment
, T" D/ ]; d) A0 J+ U( w( G1.$
2.@
; K. i( K. o# A; B  N% v3 M3.#
: v# h# g% A% L2 u  c5 a4.!
$ r5 i' Q  k5 z$ L3 L; C. ?答：3
4 L3 d% @+ s+ r, K, }* Q6 o0 b
0 k! m# d+ [$ U. e7 X+ p+ t
5 n( G6 W% v5 U! S+ a0 w...... Oracle DBA存储管理试题部分
$ U. l% y, \  _1 Jq.1:oracle immediately re-uses the space assigned to row-directory portion of the data block once you delete the corresponding rows.
) O, c! s! b6 ]( u4 \1.true
' a  M- }; _- V) s0 e' f2.false
答：2


...... Oracle DBA回滚段管理试题部分
$ l' \8 q& P( d2 U  ]& k9 oq.1:what system privilege is required to create a rollback segment ?
1.create database
  S$ u' _5 I( \+ i2 r( Y+ G2.create rollback segment
3.alter database
4.create segment
答：2
, b" j  t: V1 a  J

, R9 ^8 i4 e4 `- r5 j6 n......
Oracle DBA用户管理试题部分

会计考友

</p>q.1:the default tablespace clause in the create user command sets the location for
5 ~: h4 t6 R% g# U8 u. `1.database objects created by the user
2.temporary objects created by the user
3.system objects created by the user
4.none of the above

% @" H6 ~! ]1 F, R0 Y3 @
( |  K9 G) \5 f* K2 R/ [...... Oracle DBA审计数据库试题部分
2 ^$ G  A# i- l6 aq.1:what feature in oracle allows you to monitor suspicious activity on the datbase
1.replication
! T1 {  Z! i: Q2.auditing
3.monitoring
4.tuning
  b* x, G8 T" y+ R. r: R
5 ^& S( }5 @' v6 j4 _......