Oracle 1Z0-060 問題集

質問 1：
You created a new database using the "create database" statement without specifying the
"ENABLE PLUGGABLE" clause.
What are two effects of not using the "ENABLE PLUGGABLE database" clause?
A. The database is created as a non-CDB and can never be plugged into a CDB.
B. The database is created as a non-CDB but can be plugged into an existing CDB.
C. The database is created as a non-CDB but will become a CDB whenever the first PDB is plugged in.
D. The database is treated as a PDB and must be plugged into an existing multitenant container database (CDB).
E. The database is created as a non-CDB and can never contain a PDB.
正解：B,E
解説: (Topexam メンバーにのみ表示されます)

質問 2：
You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB).
The characteristics of the non-CDB are as follows:
- Version: Oracle Database 11gRelease 2 (11.2.0.2.0) 64-bit
- Character set: AL32UTF8
- National character set: AL16UTF16
- O/S: Oracle Linux 6 64-bit
The characteristics of the CDB are as follows:
- Version: Oracle Database 12c Release 1 64-bit
- Character Set: AL32UTF8
- National character set: AL16UTF16
- O/S: Oracle Linux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?
A. Data Pump full export/import
B. The DBMS_PDB package
C. RMAN
D. Transportable tablespace
E. Transportable database
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the PDB HR_PDB. You execute the following command:

What is the result?
A. It fails and reportsan error because the CONTAINER=ALL clause is not specified in the command.
B. It fails and reportsan error because the CONTAINER=CURRENT clause is not specified in the command.
C. It executes successfully but neither tablespace nor the data file is created.
D. It falls and reports an error because there can be only one undo tablespace in a CDB.
E. It executes successfully and creates an UNDO tablespace in HR_PDB.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which statement is true regarding the default behavior of the order by clause?
A. NULL values are not considered at all by the sort operation.
B. In a character sort, the values are case-sensitive.
C. Numeric values are displayed from the maximum to the minimum value if they have decimal positions.
D. Only those columns that are specified in the select list can be used in the order by clause.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column?
A. All the components may be moved from the SYSAUX tablespace.
B. The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.
C. The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.
D. All the components may be moved into SYSAUX tablespace.
正解：B,C
解説: (Topexam メンバーにのみ表示されます)

質問 6：
You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.
Which method or feature should you use?
A. AWR Compare Period report
B. Compare Period ADDM report
C. Taking a new snapshot and comparing it with a preserved snapshot
D. Active Session History (ASH) report
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 7：
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. Mount the container database (CDB) and restore the control file from the control file auto backup.
B. Start the database instance in the nomount stage and restore the control file from control file auto backup.
C. Recover each pluggable database.
D. Mount the CDB and then recover and open the database, with the RESETLOGS option.
E. Recover and open the CDB in NORMAL mode.
F. Open all the pluggable databases.
正解：B,D,F
解説: (Topexam メンバーにのみ表示されます)

質問 8：
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