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
相关文档：
不是ORACLE的问题
2009-12-30 15:00
......
1、转换服务器归档模式，如果已是归档模式可跳过此步：
%sqlplus /nolog (启动sqlplus)
SQL> conn / as sysdba (以DBA身份连接数据库)
SQL> shutdown immediate; (即时关闭数据库)
SQL> startup mount (启动实例并加载数据库，但不打开)
SQL> alter database archivelog; (更改� ......
在Where子句中，可以对datetime、char、varchar字段类型的列用Like子句配合通配符选取那些“很像...”的数据记录，以下是可使用的通配符：
% 零或者多个字符
_ 单一任何字符（下划线）
\ 特殊字符
[] 在某一范围内的字符，如 ......
2009年12月24日，宁波银行在全行引入Oracle Siebel CRM，以全新管理理念及业务流程构建宁波银行统一的CRM（客户关系管理）系统，实现以客户为中心的客户关系管理和企业工作效率的全面提升。“以客户为中心”的销售服务平台，能提供全行统一的客户视图，同时实现了跨部门协同工作，并提供客户生命周期管理与服务， ......
