【CUUG内部资料】OCP-12C-1Z0-062题库解析-第3次课

【CUUG内部资料】OCP-12C-1Z0-062题库解析-第3次课

序：2018年的时候，OCP 11g考试题库大更新，052 053出现了很多新题，2019年，11g即将停考的前期，Oracle又出现了一

次大变动，12c出现了很多新题，比如062 063题库大更新

G

U

U

C

Which two are true concerning a multitenant container database with three pluggable database?

A. All administration tasks must be done to a specific pluggable database.

G

U

B. The pluggable databases increase patching time.

U

C

料

C. The pluggable databases reduce administration effort.

资

试

D. The pluggable databases are patched together.

G

考

U

E. Pluggable databases are only used for database consolidation.

U

部

C

Correct Answer: CE

内

料

1

资

8

4

试

7

6

考

2

5

部

1

内

0

1

QUESTION 32

：

群

Examine the current value for the following parameters in your database instance:

论

SGA_MAX_SIZE = 1024M

讨

P

C

G

SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M

U

O

U

C

LOG_BUFFER = 200M

You issue the following command to increase the value of DB_8K_CACHE_SIZE:

G

U

SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;

U

C

料

Which statement is true?

资

A. It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically.

试

G

考

U

B. It succeeds only if memory is available from the autotuned components if SGA.

U

部

C

内

C. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within

料

SGA_TARGET.

资

试

D. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within

考

SGA_MAX_SIZE.

部

传

内

Correct Answer: B

外

1

严

禁

8

4

7

6

2

5

1

0

1

QUESTION 33

：

Which three statements are true concerning unplugging a pluggable database (PDB)?

群

A. The PDB must be open in read only mode.

讨

论

P

C

B. The PDB must be closed.

O

C. The unplugged PDB becomes a non-CDB.

QUESTION 31

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: BDE

QUESTION 34

Examine the following command:

G

U

U

INVISIBLE);

C

Which three statements are true about using an invisible column in t he PRODUCTS

G

U

table?

U

C

A. The %ROWTYPE attribute declarations in PL/SQL to access a row will not

料

资

display the invisible column in the output.

试

G

考

U

B. The DESCRIBE commands in SQL *Plus will not display the invisible column in t

U

部

C

he output.

内

料

C. Referential integrity constraint cannot be set on t he invisible column.

1

资

8

4

D. The invisible column cannot be made visible and can only be marked as unused.

试

7

6

考

2

E. A primary key constraint can be added on t he invisible column.

5

部

1

内

0

Correct Answer: ABE

1

：

(解析：一般来说,看不见列帮助迁移和发展在线应用程序。一个用例可能是一个应用程序,

群

论

SELECT *声明。第四列添加到表会破坏应用程序,预计三该应用程序可以查询一个三列的表

讨

P

列的数据。添加第四个无形的列使应用程序正常运转。开发人员可以改变应用程序来处理第

C

G

U

O

U

四列,并使列可见当应用程序上线。）

C

G

U

U

C

料

资

试

G

考

QUESTION 35

U

U

部

C

You 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?

1

严

8

A. All users except SYS

4

7

6

B. All users except SCOTT

2

5

1

C. All users except sys and SCOTT

0

1

：

D. All users except sys, system, and SCOTT

群

论

Correct Answer: B

讨

P

C

O

CREATE TABLE (prod_id number(4),

Prod_name varchar2 (20), Category_id number(30), Quantity_on_hand number (3)

QUESTION 36

On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES

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 settings if the EMPLOYEES table belonging to HR is already defined

in t he database.

G

U

U

D. It fails because no SQL *Loader control file location is specified.

C

Correct Answer: AC

G

U

Section: (none)

U

C

Explanation：sqlldr hr/hr

料

资

table=employees能够执行，会默认找文件，然后临时创建一个directory，如

试

G

考

U

果没有权限，会报如下错误：

U

部

C

SQL*Loader-816: error creating temporary directory object

内

料

SYS_SQLLDR_XT_TMPDIR_00000 for file

1

资

8

4

试

7

6

考

2

5

部

1

0

内

1

：

群

论

QUESTION 37

讨

P

After implementing full Oracle Data Redaction, you change the default value for the NUMBER

C

G

U

O

U

data type as follows:

C

After changing the value, you notice that FULL redaction continues to redact numeric

G

data with zero. （您注意到 FULL 编校继续以零编校数值数据）也就是上面的修

U

U

C

改还没有生效，该命令是把 number 的数据类型编辑以后默认值为－1）。

料

资

What must you do to activate the new default value for numeric full redaction?

试

G

考

A. Re-enable redaction policies that use FULL data redaction.

U

U

部

C

B. Re-create redaction policies that use FULL data redaction.

内

C. Re-connect the sessions that access objects with redaction policies defined on

料

资

them.

试

考

D. Flush t he shared pool.

部

传

内

E. Restart the database instance.

外

禁

Correct Answer: E

1

严

8

Section: (none) Explanation：

4

7

6

（解析：这道题题目比较难理解，甲骨文在 Oracle 数据库 12c 中加入了数据校订作为一

2

5

1

个新的安全特性。Oracle Data Redaction（Oracle 数据校订）提供了一个有效且易于实现的

0

1

：

方法来屏蔽敏感信息。该工具能够实时地从数据校订得出的查询结果会返回到它们原来的应

群

论

用程序。

讨

P

DBMS__FULL_REDACTION_VALUES — 更改完全编辑的默认返回值。必须重启

C

O

数据库才能生效。）

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.

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 database with a retention of one day.

Which two must you do to track the transactions?

G

U

U

C. Create a Flashback Data Archive in t he tablespace where the tables are stored.

C

D. Create a Flashback Data Archive in any suitable tablespace.

G

U

E. Enable Flashback Data Archiving for the tables that require tracking.

U

Correct Answer: DE

C

料

资

试

G

考

U

U

部

C

内

料

1

资

8

4

试

7

6

考

2

QUESTION 39

5

部

1

内

0

Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table

1

：

containing several DATE, CHAR, VARCHAR2, and NUMBER data types,

群

论

and the table's indexes, to another tablespace.

讨

P

The table does not have a primary key and is used by an OLTP application. Which technique will

C

G

U

O

U

move the table and indexes while maintaining the highest level of

C

availability to the application?

G

A. Oracle Data Pump.

U

U

C

B. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the

料

资

indexes.

试

G

考

C. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move

U

U

部

the indexes.

C

内

D. Online Table Redefinition.

料

E. Edition-Based Table Redefinition.

试

资

考

Correct Answer: D

部

传

内

外

禁

1

严

8

4

7

6

2

5

1

QUESTION 40

0

1

：

To implement Automatic Management (AMM), you set t he following parameters:

群

论

When you try to start the database instance with these parameter settings, you receive

讨

P

the following error message:

C

O

SQL > startup

A. Enable supplemental logging for the database.

B. Specify undo retention guarantee for t he database.

ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing

internal settings, see alert log for more information.

Identify the reason t he instance failed to start.

A . The PGA_AGGREGATE_TARGET parameter is set to zero.

B. The STATISTICS_LEVEL parameter is set to BASIC.

C. Both t he SGA_TARGET and MEMORY_TARGET parameters are set.

D. The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal.

Correct Answer: B

试

G

考

U

A. Effectively implements role separation

U

部

C

B. Enables you to take advantage of Oracle Managed Files.

内

料

C. Automatically registers t he database with Oracle Restart.

1

资

8

4

D. Helps you to easily upgrade the database from a prior release.

试

7

6

考

2

E. Enables the Installation of Grid Infrastructure files on block or raw devices.

5

部

1

内

0

Correct Answer: CE

1

：

Section: (none)

群

论

Explanation

讨

P

Explanation/Reference:

C

G

U

O

U

C: To use Oracle ASM or Oracle Restart, you must first install Oracle Grid Infrastructure for a

C

standalone server before you install and create the database.

G

Otherwise, you must manually register the database with Oracle Restart.

U

U

C

料

资

试

G

考

U

U

部

C

内

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 databases (PDBs) share certain multitenant container database (CDB)

1

严

8

resources.

4

7

6

C. Multiple CDBs share certain PDB resources.

2

5

1

D. Multiple non-RAC CDB instances can mount the same PDB as long as they are on t he same

0

1

：

server.

群

E. Patches are always applied at t he CDB level.

论

讨

P

F. A PDB can have a private undo tablespace.

C

O

Correct Answer: BE

installing and creating an Oracle database?

Section: (none)

Explanation

Explanation/Reference:

B: Using 12c Resource manager you will be able control CPU, Exadata I/O, sessions and parallel

QUESTION 41

What are two benefits of installing Grid Infrastructure software for a stand-alone server before

G

U

C

U

G

U

U

C

料

资

servers. A new 12c CDB Resource Manager Plan will use so-

called "Shares" (resource allocations) to specify how CPU is distributed between PDBs. A CDB

Resource Manager Plan also can use "utilization limits" to limit the

CPU usage for a PDB. With a default directive, you do not need to modify t he resource plan for

each PDB plug and unplug.

G

U

U

patching

C

all of its many pluggable databases. To patch a single pluggable

G

U

database, you simply unplug/plug to a multitenant container database at a different Oracle

U

C

Database software version.

料

资

试

G

考

U

U

部

C

内

料

1

资

8

4

试

7

6

考

2

QUESTION 43

5

部

1

内

0

You upgrade your Oracle database in a multiprocessor environment. As a

1

：

recommended you execute the following script:

群

论

SQL > @

讨

P

Which two actions does the script perform?

C

G

U

O

U

A. Parallel compilation of only the stored PL/SQL code

C

B. Sequential recompilation of only the stored PL/SQL code

C. Parallel recompilation of any stored PL/SQL code

U

G

U

C

D. Sequential recompilation of any stored PL/SQL code

料

资

E. Parallel recompilation of Java code

试

G

考

F. Sequential recompilation of Java code

U

U

部

C

Correct Answer: CE

内

Section: (none)

料

资

Explanation

试

考

Explanation/Reference: and

部

传

内

The and scripts are provided by Oracle to recompile all invalid

外

禁

objects in t he database. They are typically run after major database changes such

1

严

8

as upgrades or patches. They are located in t he $ORACLE_HOME/rdbms/admin

4

7

6

directory and provide a wrapper on the UTL_RECOMP package. The

2

5

1

script simply calls t he script with a command line parameter of "0". The

0

1

：

accepts a single integer parameter that indicates the level of parallelism

群

论

as follows.

讨

P

0 - The level of parallelism is derived based on t he CPU_COUNT parameter. 1 - The

C

O

recompilation is run serially, one object at a time.

E: New paradigms for rapid patching and upgrades.

The investment of time and effort to patch one multitenant container database results in

N - The recompilation is run in parallel with "N" number of threads. Both scripts must

be run as the SYS user, or another user with SYSDBA, to work correctly.

Reference: Recompiling Invalid Schema Objects

QUESTION 44

Which statement is true concerning dropping a pluggable database (PDB)?

A. The PDB must be open in read-only mode.

G

U

D. The PDB data files are always removed from disk.

U

C

E. A dropped PDB can never be plugged back into a multitenant container database

G

U

(CDB).

U

Correct Answer: C

C

料

资

Section: (none)

试

G

完全的从一个 CDB 中把 PDB 删除，我们可以用

考

U

Explanation DROP PDB。这个

U

部

C

操作仅仅支持当一个 PDB 被拔出以后

内

料

1

资

8

4

试

7

6

考

2

5

部

1

0

内

1

：

QUESTION 45

群

论

You notice a high number of waits for t he db file scattered read and db file

讨

P

sequential read events in t he recent Automatic Database Diagnostic Monitor

C

G

U

O

U

(ADDM) report. After further investigation, you f ind that queries are performing

C

too many full table scans and indexes are not being used even though the filter

G

columns are

U

U

C

indexed.

料

资

Identify three possible reasons for this.

试

G

考

A. Missing or stale histogram statistics

U

U

部

C

B. Undersized shared pool

内

C. High clustering factor for the indexes

料

资

D. High value for the DB_FILE_MULTIBLOCK_READ_COUNT parameter

试

考

E. Oversized buffer cache

部

传

内

Correct Answer: ACD

外

禁

Section: (none)

1

严

8

Explanation

4

7

6

Explanation/Reference:

2

5

1

D: DB_FILE_MULTIBLOCK_READ_COUNT is one of t he parameters you can use to minimize

0

1

：

I/O during table scans. It specifies the maximum number of blocks

群

论

read in one I/O operation during a sequential scan. The total number of I/Os needed to perform

讨

P

a full table scan depends on such factors as the size of the table, the

C

O

multiblock read count, and whether parallel execution is being utilized for the operation.

B. The PDB must be in mount state.

C. The PDB must be unplugged.