【CUUG内部资料】OCP-12C-1Z0-062题库解析-第3次课
-
资源ID:89054920
资源大小:19.79KB
全文页数:7页
- 资源格式: DOCX
下载积分:0金贝
快捷下载
账号登录下载
微信登录下载
微信扫一扫登录
1、金锄头文库是“C2C”交易模式,即卖家上传的文档直接由买家下载,本站只是中间服务平台,本站所有文档下载所得的收益全部归上传人(卖家)所有,作为网络服务商,若您的权利被侵害请及时联系右侧客服;
2、如你看到网页展示的文档有jinchutou.com水印,是因预览和防盗链等技术需要对部份页面进行转换压缩成图而已,我们并不对上传的文档进行任何编辑或修改,文档下载后都不会有jinchutou.com水印标识,下载后原文更清晰;
3、所有的PPT和DOC文档都被视为“模板”,允许上传人保留章节、目录结构的情况下删减部份的内容;下载前须认真查看,确认无误后再购买;
4、文档大部份都是可以预览的,金锄头文库作为内容存储提供商,无法对各卖家所售文档的真实性、完整性、准确性以及专业性等问题提供审核和保证,请慎重购买;
5、文档的总页数、文档格式和文档大小以系统显示为准(内容中显示的页数不一定正确),网站客服只以系统显示的页数、文件格式、文档大小作为仲裁依据;
6、如果您还有什么不清楚的或需要我们协助,可以点击右侧栏的客服。
|
下载须知 | 常见问题汇总
|
【CUUG内部资料】OCP-12C-1Z0-062题库解析-第3次课
【CUUG内部资料】OCP讨论群:1015267481【CUUG内部资料】OCP-12C-1Z0-062题库解析-第1次课序:2018年的时候,OCP 11g 考试题库大更新,052 053出现了很多新题,2019年,11g 即将停考的前期,Oracle 又出现了一次大变动,12c 出现了很多新题,比如 062 063 题库大更新QUESTION 31Which two are true concerning a multitenant container database with three pluggable database?A. All administration tasks must be done to a specific pluggable database.B. The pluggable databases increase patching time.C. The pluggable databases reduce administration effort.D. The pluggable databases are patched together.E. Pluggable databases are only used for database consolidation.Correct Answer: CEQUESTION 32Examine the current value for the following parameters in your database instance:SGA_MAX_SIZE = 1024MSGA_TARGET = 700M DB_8K_CACHE_SIZE = 124MLOG_BUFFER = 200MYou issue the following command to increase the value of DB_8K_CACHE_SIZE:SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;Which statement is true?A. It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically.B. It succeeds only if memory is available from the autotuned components if SGA.C. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated withinSGA_TARGET.D. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated withinSGA_MAX_SIZE.Correct Answer: BQUESTION 33Which three statements are true concerning unplugging a pluggable database (PDB)?A. The PDB must be open in read only mode.B. The PDB must be closed.C. The unplugged PDB becomes a non-CDB.D. The unplugged PDB can be plugged into the same multitenant container database (CDB)E. The unplugged PDB can be plugged into another CDB.F. The PDB data files are automatically removed from disk.Correct Answer: BDEQUESTION 34Examine the following command:CREATE TABLE (prod_id number(4),Prod_name varchar2 (20), Category_id number(30), Quantity_on_hand number (3)INVISIBLE);Which three statements are true about using an invisible column in t he PRODUCTStable?A. The %ROWTYPE attribute declarations in PL/SQL to access a row will notdisplay the invisible column in the output.B. The DESCRIBE commands in SQL *Plus will not display the invisible column in the output.C. Referential integrity constraint cannot be set on t he invisible column.D. The invisible column cannot be made visible and can only be marked as unused.E. A primary key constraint can be added on t he invisible column.Correct Answer: ABE(解析:一般来说,看不见列帮助迁移和发展在线应用程序。一个用例可能是一个应用程序,该应用程序可以查询一个三列的表SELECT *声明。第四列添加到表会破坏应用程序,预计三列的数据。添加第四个无形的列使应用程序正常运转。开发人员可以改变应用程序来处理第四列,并使列可见当应用程序上线。)QUESTION 35You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.You issue the following statements:SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;For which database users is the audit policy now active?A. All users except SYSB. All users except SCOTTC. All users except sys and SCOTTD. All users except sys, system, and SCOTTCorrect Answer: BQUESTION 36On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEEStable in t he HR schema by issuing the following command:$> sqlldr hr/hrpdb table=employeesWhich two statements are true regarding the command?A. It succeeds with default settings if the EMPLOYEES table belonging to HR is already definedin t he database.B. It fails because no SQL *Loader data file location is specified.C. It fails if t he HR user does not have the CREATE ANY DIRECTORY privilege.D. It fails because no SQL *Loader control file location is specified.Correct Answer: ACSection: (none)Explanation:sqlldr hr/hrtable=employees能够执行,会默认找employees.dat文件,然后临时创建一个directory,如果没有权限,会报如下错误:SQL*Loader-816: error creating temporary directory objectSYS_SQLLDR_XT_TMPDIR_00000 for file employees.datQUESTION 37After implementing full Oracle Data Redaction, you change the default value for the NUMBERdata type as follows:After changing the value, you notice that FULL redaction continues to redact numericdata with zero. (您注意到 FULL 编校继续以零编校数值数据)也就是上面的修改还没有生效,该命令是把 number 的数据类型编辑以后默认值为1)。What must you do to activate the new default value for numeric full redaction?A. Re-enable redaction policies that use FULL data redaction.B. Re-create redaction policies that use FULL data redaction.C. Re-connect the sessions that access objects with redaction policies defined onthem.D. Flush t he shared pool.E. Restart the database instance.Correct Answer: ESection: (none) Explanation:(解析:这道题题目比较难理解,甲骨文在 Oracle 数据库 12c 中加入了数据校订作为一个新的安全特性。Oracle Data Redaction(Oracle 数据校订)提供了一个有效且易于实现的方法来屏蔽敏感信息。该工具能够实时地从数据校订得出的查询结果会返回到它们原来的应用程序。DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES 更改完全编辑的默认返回值。必须重启数据库才能生效。)QUESTION 38You must track all transactions that modify certain