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

出題：1

You must configure Oracle Data Redaction for the EMP table to satisfy the following requirements:
- RANDOM redaction on the SAL and COMM columns
- PARTIAL redaction on the HIREDATE column
- FULL redaction on the MGR column
What would you define to implement this?

A. several redaction policies, with one redaction policy for each table column that must be redacted

B. one redaction policy on the table, which specifies the redaction types for all table columns that must be redacted

C. several redaction policies, with each redaction policy specifying the redaction for table columns of that redaction type

D. several redaction policies, with one redaction policy foe each data type defined for the table must be redacted

正解：B 解答を投票する

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

出題：2

Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?

A. Reduced logical I/O

B. Improved parallel Execution performance

C. Reduced virtual memory utilization

D. Reduced CPU utilization

E. Reduced physical I/O

F. Improved Serial Execution performance

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

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

出題：3

You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privileges and execute the following sequence statements:

What is the result of the last SET CONTAINERstatement and why is it so?

A. It fails because local users are unable to use the SET CONTAINER statement.

B. It fails because common users are unable to use the SET CONTAINER statement.

C. If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).

D. It succeeds because the PDB_ADMIN user has the required privileges.

正解：A 解答を投票する

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

出題：4

Which three tasks can be performed using SQL functions built into Oracle Database?

A. Finding the number of characters in an expression

B. Combining more than two columns or expressions into a single column in the output

C. Displaying a date in a nondefault format

D. Substituting a character string in a text expression with a specified string

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

出題：5

Identify three benefits of Unified Auditing.

A. Decreased use of storage to store audit trail rows in the database.

B. It improves overall auditing performance.

C. It guarantees zero-loss auditing.

D. It automatically audits Recovery Manager (RMAN) events.

E. The audit trail cannot be easily modified because it is read-only.

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

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

出題：6

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 メンバーにのみ表示されます)

出題：7

You execute the following PL/SQL:

Which two statements are true?

A. FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000 is accessed.

B. FGA is enabled for all DML operations by JIMon the PRODUCTS.PRICE column.

C. Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accessed.

D. FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.

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

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

出題：8

Which two partitioned table maintenance operations support asynchronous Global Index Maintenance in Oracle database 12c?

A. ALTER TABLE DROP PARTITION

B. ALTER TABLE TRUNCATE PARTITION

C. ALTER TABLE MERGE PARTITION

D. ALTER TABLE ADD PARTITION

E. ALTER TABLE MOVE PARTITION

F. ALTER TABLE SPLIT PARTITION

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

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

出題：9

You notice a performance change in your production Oracle 12c database and you want to know what change caused this performance difference. You generate the compare period Automatic Database Diagnostic Monitor (ADDM) report to further investigation.
Which three findings would you get from the report?

A. It detects the top wait events causing performance degradation.

B. It shows the resource usage for CPU, memory, and I/O in both time periods.

C. It detects any configuration change that caused a performance difference in both time periods.

D. It gives information about statistics collection in both time periods.

E. It identifies any workload change that caused a performance difference in both time periods

正解：B,C,E 解答を投票する

出題：10

Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs.
Which three steps should you perform to recover the control file and make the database fully operational?

A. Open all the pluggable databases.

B. Recover each pluggable database.

C. Recover and open the CDB in NORMAL mode.

D. Mount the CDB and then recover and open the database, with the RESETLOGS option.

E. Mount the container database (CDB) and restore the control file from the control file auto backup.

F. Start the database instance in the nomount stage and restore the control file from control file auto backup.

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

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

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