1Z0-060試験無料問題集（205題）「Oracle Upgrade to Oracle Database 12c 認定」

出題：1

In your Oracle 12c database, you create two roles: AUDITORand AUDIT_ADMIN. You then execute the following commands:

To create a privilege analysis policy for the AUDIT_ADMINrole, you execute the following PL/SQLblock:

Which statement is correct about the procedure?

A. It only captures the use of the privileges used through the AUDIT_ADMIN role when the ACCOUNT module is used.
PAYABLE

B. It always captures the use of the CREATE VIEW and CREATE TABLE privileges.

C. It always captures the use of the privileges exercised through the AUDITOR and AUDIT_ADMIN roles.

D. It captures the use of the privileges used through the AUDIT_ADMIN and AUDITOR roles when the module is used.
ACCOUNT PAYABLE

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：2

In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation.
How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?

A. It collects data from SGA, analyzes it, and provides a report.

B. It collects data from SGA and compares it with the latest snapshot.

C. It collects data from SGA and compares it with a preserved snapshot.

D. It collects data from both SGA and PGA, analyzes it, and provides a report.

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：3

Which Oracle Database component is audited by default if the unified Auditing option is enabled?

A. Oracle Database Vault

B. Oracle Data Pump

C. Oracle Label Security

D. Oracle Real Application Security

E. Oracle Recovery Manager (RMAN)

正解：E 解答を投票する

出題：4

Examine the following command;
ALTER SYSTEM SET enable_ddl_logging = TRUE;
Which statement is true?

A. All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.

B. Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.

C. All DDL commands are logged in the alert log file.

D. Only DDL commands that resulted in the creation of new segments are logged.

E. All DDL commands are logged in a different log file that contains DDL statements and their execution dates.

正解：E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：5

Which three SQL statements would display the value 1890.55 as $1, 890.55?

A. Option E

B. Option D

C. Option C

D. Option A

E. Option B

正解：A,B,D 解答を投票する

出題：6

You plan to use the In Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.
Which three storage options support the use of HCC?

A. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

B. ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array

C. Database files stored in ZFS and accessed using conventional NFS mounts.

D. Database files stored in any file system and accessed using the Oracle Direct NFS feature

E. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files

F. ASM disk groups with ASM disks consisting of Exadata Grid Disks.

G. Database files stored in ZFS and accessed using the Oracle Direct NFS feature

正解：A,F,G 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

Your multitenant container database (CDB) containing two pluggable databases, PDB2_1 and PDB2_2, is running in ARCHIEVELOGmode. An RMAN backup exists for the databases.
You issue the following commands and get an error:

Examine the following commands:

Identify two correct sequences of commands to perform a recovery and make the data available.

A. 1,2,10,5,6,9

B. 10,3,4,8,9

C. 1,2,3,4,7,8

D. 1,2,5,6,7,8

正解：A,D 解答を投票する

出題：8

You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege.
The CDB has several pluggable databases (PDBs) open in the read/write mode.
There are ongoing transactions in both the CDB and PDBs.
What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?

A. The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.

B. The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.

C. The shutdown proceeds immediately.
The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolled hack.

D. The statement results in an error because there are open PDBs.

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：9

Which three statements are true about using flashback database in a multitenant container database (CDB)?

A. To enable flashback database, the CDB must be mounted.

B. The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB.

C. The root container can be flashed back without flashing back the pluggable databases (PDBs).

D. A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

E. Individual PDBs can be flashed back without flashing back the entire CDB.

正解：A,B,D 解答を投票する

1Z0-060試験無料問題集「Oracle Upgrade to Oracle Database 12c 認定」