Oracle 1z0-067 問題集

質問 1：
Which three statements are true about Oracle Restart?
A. While starting any components, it automatically attempts to start all dependencies first and in proper order.
B. It runs periodic check operations to monitor the health of Oracle components.
C. It can be used to only start Oracle components.
D. It can be configured to automatically restart a database in case of normal shutdown of the database instance.
E. It can be configured to automatically attempt to restart various components after a hardware or software failure.
正解：A,B,E
解説: (Topexam メンバーにのみ表示されます)

質問 2：
You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2. You are connected to pdb2 as a common user with DBA privileges.
The statistics_level parameter is PDB modifiable.
As the user sys, execute the following command on pdb2:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE;
Which statement is true about the result of this command?
A. The statistics_level parameter is set to all when any of the PDBs is reopened.
B. The statistics_level parameter is set to all when the root database is restarted.
C. The statement is ignored because there is no SPFILE for a PDB.
D. The statistics_level parameter is set to all only for PDB2 when it is reopened.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?
A. Reduced physical I/O
B. Reduced logical I/O
C. Reduced CPU utilization
D. Reduced virtual memory utilization
E. Improved Serial Execution performance
正解：C,D

質問 4：
On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table in the hr schema by issuing the command:
S>sqlldrhr/hr@pdb table=employees
Which two statements are true about the command?
A. It fails because no SQL*Loader control file location is specified.
B. It succeeds with default settings if the employees table exists in the hr schema.
C. It fails if the hr user does not have the create any directory privilege.
D. It succeeds and creates the employees table in the HR schema.
E. It fails because no SQL*Loader data file location is specified.
正解：B,C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
You plan to duplicate the multitenant container database (CDB) cdb1 that contains the pluggable database (PDB) SALES:
RMAN> DUPLICATE TARGET DATABASE TO cdbdup
PLUGGABLE DATABASE sales
FROM ACTIVE DATABASE
PASSWORD FILE
SPFILE
NOFILENAMECHECK;
Which two statements are true? (Choose two.)
A. An auxiliary instance must have been started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.
B. RMAN must be connected to a recovery catalog for the execution of the command.
C. Only the SALES PDB is duplicated as the non-CDB CDBDUP.
D. The root and seed databases are included in the duplication.
E. A backup of the SALES PDB must exist before the execution of the command.
正解：A,D

質問 6：
You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).
Examine the steps required to perform the migration:
1. Use Data Pump export to perform a full transportable export on the source database with the export parameter VERSION=12.
2. Place all tablespaces in read-only mode on the source database.
3. Upgrade the source database to Oracle Database 12c.
4. Copy the dump file and data files to the desired location in the target database.
5. Create a new PDB in the target CDB.
6. Synchronize the PDB on the target CDB.
7. Use Data Pump import on the new PDB by using the full transportable import options.
Identify the required steps in the correct order.
Choose the best answer.
A. 2, 1, 3, 5, 7, and 6
B. 2, 5, 1, 4, 7, and 6
C. 1, 5, 4, 7, and 6
D. 3, 2, 5, 1, 4, and 7
正解：B

質問 7：
You create two Resource Manager plans, one for night time workloads, the other for day time.
How would you make the plans switch automatically?
A. Use scheduler schedules.
B. Use the mapping rule for the consumer groups.
C. Use job classes.
D. Use scheduler windows.
E. Set the switch_time plan directive for both plans.
正解：D
解説: (Topexam メンバーにのみ表示されます)