【CUUG 内部资料】OCP-12C-1Z0-062题库解析-第3次课
序：2018年的时候，OCP 11g 考试题库大更新，052 053出现了很多新题，2019年，11g 即将停考的前期，Oracle 又出现了一次大变动，12c 出现了很多新题，比如062 063题库大更新
QUESTION 31
Which two are true concerning a multitenant container databa with three pluggable databa? A. All administration tasks must be done to a specific pluggable databa. B. The pluggable databas increa patching time. C. The pluggable databas reduce administration effort. D. The pluggable databas are patched together . E. Pluggable databas are only ud for databa consolidation. Correct Answer: CE
QUESTION 32
Examine the current value for the following parameters in your databa instance:
SGA_MAX_SIZE = 1024M SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M You issue the following command to increa the value of DB_8K_CACHE_SIZE:
SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M; Which statement is true? A. It fails becau 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 becau an increa in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET .棕蝠
D. It fails becau an increa in DB_8K_CACHE_SIZE cannot be accommodated within
SGA_MAX_SIZE. Correct Answer: B QUESTION 33
Which three statements are true concerning unplugging a pluggable databa (PDB)? A. The PDB must be open in read only mode. B. The PDB must be clod.
C. The unplugged PDB becomes a non-CDB.
D. The unplugged PDB can be plugged into the same multitenant container databa (CDB)
E. The unplugged PDB can be plugged into another CDB.
F. The PDB data files are automatically removed from disk. Correct Answer: BDE
C U U G C U U G C U U G 内部考试资料 内部考试资料 O C P 讨论群：1015267481C U U G C U U G C U U G 内部考试资料 内部考试资料 严禁外
传O C P 讨论群
：1015267481
QUESTION 34
Examine 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 PRODUCTS table?
A. The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.
B. The DESCRIBE commands in SQL *Plus will not display the invisible column in t he output.
C. Referential integrity constraint cannot be t on t he invisible column.
D. The invisible column cannot be made visible and can only be marked as unud.
E. A primary key constraint can be added on t he invisible column. Correct Answer: ABE (解析：一般来说，看不见列帮助迁移和发展在线应用程序。一个用例可能是一个应用程序，该应用程序可以查询一个三列的表
SELECT *声明。第四列添加到表会破坏应用程序，预计三列的数据。添加第四个无形的列使应用程序正常运转。开发人员可以改变应用程序来处理第四列，并使列可见当应用程序上线。） QUESTION 35 You wish to enable an audit policy for all databa urs, 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 databa urs is the audit policy now active?
A. All urs except SYS
B. All urs except SCOTT
C. All urs except sys and SCOTT
D. All urs except sys, system, and SCOTT
Correct Answer: B
QUESTION 36
On your Oracle 12c databa, you invoked SQL *Loader to load data into the EMPLOYEES
C U U G C U U G C U U G 内部考试资料 内部考试资料 O C P 讨论群：1015267481C U U G C U U G C U U G 内部考试资料 内部考试资料 严禁外传O C P 讨论群：1015267481
table in t he HR schema by issuing the following command: $> sqlldr hr/hr@pdb table=employees
Which two statements are true regarding the command?
读书英语怎么写
A. It succeeds with default ttings if the EMPLOYEES table belonging to HR is already defined in t he databa.
B. It fails becau no SQL *Loader data file location is specified.
C. It fails if t he HR ur does not have the CREATE ANY DIRECTORY privilege.
D. It fails becau no SQL *Loader control file location is specified. Correct Answer: AC Section: (none)
桃胶的禁忌Explanation ：sqlldr hr/hr table=employees 能够执行，会默认找employees.dat 文件，然后临时创建一个directory ，如果没有权限，会报如下错误： SQL*Loader-816: error creating temporary directory object SYS_SQLLDR_XT_TMPDIR_00000 for file employees.dat QUESTION 37
After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows: After changing the value, you notice that FULL redaction continues to redact numeric data 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 u FULL data redaction. B. Re-create redaction policies that u FULL data redaction. C. Re-connect the ssions that access objects with redaction policies defined on them. D. Flush t he shared pool.
E. Restart the databa instance.
Correct Answer: E
Section: (none) Explanation ： （解析：这道题题目比较难理解，甲骨文在 Oracle 数据库 12c 中加入了数据校订作为一个新的安全特性。Oracle Data Redaction （Oracle 数据校订）提供了一个有效且易于实现的方法来屏蔽敏感信息。该工具能够实时地从数据校订得出的查询结果会返回到它们原来的应
小学生春节的画
用程序。
DBMS_REDACT.UPDA TE_FULL_REDACTION_VALUES — 更改完全编辑的默认返回值。必须重启数据库才能生效。）
C U U G C U U G C U U G 内部考试资料 内部考试资料 O C P 讨论群：1015267481C U U G C U U G C U U G 内部考试资料 内部考试资料 严禁外传O C P 讨论群：1015267481
QUESTION 38
You must track all transactions that modify certain tables in t he sales schema for at least three years.
Automatic undo management is enabled for the databa with a retention of one day. Which two must you do to track the transactions?
A. Enable supplemental logging for the databa.
B. Specify undo retention guarantee for t he databa.
C. Create a Flashback Data Archive in t he tablespace where the tables are stored.
D. Create a Flashback Data Archive in any suitable tablespace.
E. Enable Flashback Data Archiving for the tables that require tracking.
Correct Answer: DE
QUESTION 39 Your are the DBA supporting an Oracle 11g Relea 2 databa and wish to move a table containing veral DATE, CHAR, VARCHAR2, and NUMBER data types, and the table's indexes, to another tablespace.
The table does not have a primary key and is ud by an OLTP application. Which technique will
move the table and indexes while maintaining the highest level of availability to the application? A. Oracle Data Pump. B. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to
move the indexes. C. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes. D. Online Table Redefinition. E. Edition-Bad Table Redefinition. Correct Answer: D
QUESTION 40 To implement Automatic Management (AMM), you t t he following parameters:
When you try to start the databa instance with the parameter ttings, you receive
the following error message: SQL > startup
ORA-00824: cannot t SGA_TARGET or MEMORY_TARGET due to existing internal ttings, e alert log for more information. Identify the reason t he instance failed to start.
A . The PGA_AGGREGATE_TARGET parameter is t to zero.
C U U G C U U G C U U G 内部考试资料 内部考试资料 O C P 讨论群：1015267481C U U G C U U G C U U G 内部考试资料
内部考试资料 严禁外传O C P 讨论群：1015267481
B. The STATISTICS_LEVEL parameter is t to BASI
C.景阳冈教学设计
C. Both t he SGA_TARGET and MEMORY_TARGET parameters are t.
D. The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal. Correct Answer: B
针石QUESTION 41
What are two benefits of installing Grid Infrastructure software for a stand-alone rver before
installing and creating an Oracle databa? A. Effectively implements role paration B. Enables you to take advantage of Oracle Managed Files.
C. Automatically registers t he databa with Oracle Restart.
D. Helps you to easily upgrade the databa from a prior relea.
E. Enables the Installation of Grid Infrastructure files on block or raw devices. Correct Answer: CE Section: (none) Explanation
Explanation/Reference: C: To u Oracle ASM or Oracle Restart, you must first install Oracle Grid Inf
rastructure for a standalone rver before you install and create the databa. Otherwi, you must manually register the databa with Oracle Restart. QUESTION 42 Identify two correct statements about multitenant architectures. A. Multitenant architecture can be deployed only in a Real Application Clusters (RAC)
configuration.
B. Multiple pluggable databas (PDBs) share certain multitenant container databa (CDB)
resources. C. Multiple CDBs share certain PDB resources. D. Multiple non-RAC CDB instances can mount the same PDB as long as they are on t he same rver.
E. Patches are always applied at t he CDB level.
F. A PDB can have a private undo tablespace. Correct Answer: BE
Section: (none)
Explanation
Explanation/Reference:
B: Using 12c Resource manager you will be able control CPU, Exadata I/O, ssions and parallel
C U U G
C U
面试官技巧
最火的网游U G
C U U G 内部考试资料 内部考试资
料 O C P 讨论群：1015267481C U U G C U U G C U U G 内部考试资料 内部考试资料 严禁外传O C P 讨论群：1015267481
