Oracle 1Z0-060 問題集

質問 1：
The following parameter are set for your Oracle 12c database instance:

You want to manage the SQL plan evolution task manually. Examine the following steps:
1. Set the evolve task parameters.
2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK
function.
3. Implement the recommendations in the task by using the
DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.
4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK
function.
5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK
function.
Identify the correct sequence of steps:
A. 1, 2, 4, 5
B. 1, 2, 3, 4, 5
C. 2, 4, 5
D. 2, 1, 4, 3, 5
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
You enabled an audit policy by issuing the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;
For which database users and for which executions is the audit policy now active? Select two.
A. SCOTT
B. Only for failed executions
C. Only for successful executions
D. SYS, SYSTEM
E. Both successful and failed executions
正解：D,E
解説: (Topexam メンバーにのみ表示されます)

質問 3：
An application accesses a small lookup table frequently.
You notice that the required data blocks are getting aged out of the default buffer cache.
How would you guarantee that the blocks for the table never age out?
A. Increase the database buffer cache size.
B. Configure Automatic Memory Management-
C. Configure the RECYCLE bufferpool and alter the table with the corresponding storage clause.
D. Configure Automata Shared Memory Management.
E. Configure the KEEP buffer pool and alter the table with the corresponding storage clause.
正解：E
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which two statements are true about the working of system privileges in a multitenant control database (CDB) that has pluggable databases (PDBs)?
A. System privileges apply only to the PDB in which they are used.
B. The granter of system privileges must possess the set container privilege.
C. Common users connected to a PDB can exercise privileges across other PDBs.
D. System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.
E. Local users cannot use local system privileges on the schema of a common user.
正解：B,D

質問 5：
Which three statements are true about adaptive SQL plan management?
A. The optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline.
B. The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.
C. It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.
D. The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.
E. It adds new, bettor plans automatically as fixed plans to the baseline.
正解：B,C,D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Which three statements are true about adaptive SQL plan management?
A. The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.
B. It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.
C. It adds new; bettor plans automatically as fixed plans to the baseline.
D. The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.
正解：A,B,D

質問 7：
In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs.
You execute the following command from the root container:
SQL > REVOKE create table FROM C # # A_ADMIN;
What is the result?
A. It fails and reports an error because the CONTAINER=CURRENT clause is not used.
B. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.
C. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.
D. It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.
E. It fails and reports an error because the CONTAINER=ALL clause is not used.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 8：
You are administering a database stored in Automatic Storage Management (ASM).
You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure.
In which three ways can you re-create the lost disk group and restore the data?
A. Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.
B. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.
C. Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.
D. Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.
E. Use the MKDG command to restore the disk group with the same configuration as the backed- up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.
F. Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.
正解：A,E,F
解説: (Topexam メンバーにのみ表示されます)