1Z0-060 試験問題を無料オンラインアクセス

You execute the following piece of code with appropriate privileges:

User SCOTT has been granted the CREATE SESSION privilege and the MGR role.
Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table?

• A.Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.
• B.Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.
• C.Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.
• D.Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.
• E.Data is never redacted for the EMP_V.SAL column.

You configure your database Instance to support shared server connections.
Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?

• A.Location of the runtime area for DML and DDL Statements
• B.Stack space
• C.Private SQL area
• D.Location of a part of the runtime area for SELECT statements
• E.User session data

Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.
Which two RMAN commands may be; used to back up only the PDB1 pluggable database?

• A.BACKUP PLUGGABLE database PDB1 while connected to PDB2
• B.BACKUP DATABASE while connected to the boot container
• C.BACKUP DATABASE while connected to the PDB1 container
• D.BACKUP PLUGGABLE DATABASE PDB1 while connected to the root container
• E.BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 container

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 any configuration change that caused a performance difference in both time periods.
• B.It identifies any workload change that caused a performance difference in both time periods
• C.It gives information about statistics collection in both time periods.
• D.It shows the resource usage for CPU, memory, and I/O in both time periods.
• E.It detects the top wait events causing performance degradation.

What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE" statement?

• A.It will create a CDB with root opened and seed read only.
• B.It will create a CDB that must be plugged into an existing CDB.
• C.It will create a CDB with root and seed opened and one PDB mounted.
• D.It will create a multitenant container database (CDB) with only the root opened.
• E.It will create a CDB with root opened and seed mounted.