2008 中国首届Oracle数据库精英工程师评选电子试题

2008 中国首届Oracle数据库精英工程师评选电子试题 和答案(2008年9月3日)
===========================================================
2008 中国首届Oracle数据库精英工程师评选电子试题 和答案(2008年9月3日)
作者: zhulch(http://zhulch.itpub.net)
发表于: 2008.09.02 16:12
分类: ERP(Oracle/SAP)
出处: http://zhulch.itpub.net/post/17395/470005
---------------------------------------------------------------
.............
一、选择题
1．Which six files are maintained in the Flash Recovery Area? (Choose six.)
A. control file
B. RMAN files
C. password file
D. parameter file
E. flashback logs
F. data file copies
G. core dump files
H. archived log files
I. RMAN recovery scripts
J. control file autobackpus
回答: A，B，E，F，H，J
2．You are unable to move the Unified Job Scheduler occupant from the SYSAUX
tablespace to the USERS tablespace. What could be the reason?
A. None of the SYSAUX occupants can be relocated.
B. The USERS tablespace is a bigfile tablespace (BFT).
C. The united Job Scheduler occupant cannot be relocated.
D. The SYSAUX occupants can be relocated to the SYSTEM tablespace only.
回答: C
3．You want to enforce a company's business policy on several objects by using a single
policy function.
Which two types of policies can be assigned to the policy_type argument in the
dbms_rls.add_policy procedure to achieve the above objective? (Choose two.)
A. DBMS_RLS.STATIC
B. DBMS_RLS.DYNAMIC
C. DBMS_RLS.SHARED_STATIC
D. DBMS_RLS.CONTEXT_SENSITIVE
E. DBMS_RLS.SHARED_CONTEXT_SENSITIVE
回答: C,E
4．You need to ensure that the database users should be able to use the various
flashback query features in order to go back in time by four hours. What should
you do? (Choose two.)
A. set SQL_TRACE=true
B. set UNDO_RETENTION=14400
C. set FAST_ST =240
D. set LOG_CHECKPOINT_INTERVAL=240
E. set DB_FLASHBACK_RETENTION_TARGET=14400
F. Issue the AART_MTTR_TARGETLTER DATABASE FLASHBACK ON; command.
G. set the RETENTION GUARANTEE clause for the undo