Oracle 1z0-067 問題集

質問 1：
Your multitenant container database (CDB) cdb1, which has no startup triggers and contains multiple pluggable databases (PDBs), is started up by using the command:
SQL>STARTUP
Which two statements are true about the successful execution of the command?
A. All the PDBs are in closed state.
B. All redo log files are opened.
C. Only the root database is opened in read-write mode.
D. All the PDBs are opened in read-write mode.
E. The root, the seed, and all the PDBs are opened in read-write mode.
正解：B,C
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Your database is running in ARCHIVELOG mode. You use RMAN to take image copies and you update these copies incremental every six hours.
After a regular maintenance task, when you attempt to restart the instance, it halts in MOUNT state with an error indicating that one of the data files belonging to the EXAMPLE tablespace is lost. You want to recover the data file as quickly as possible while maximizing availability for the database.
Examine the possible steps involved in the recovery process:
Mount the database
Take the data file offline
Bring the tablespace online
Use the RMAN SWITCH command to switch to the image copy
Recover the tablespace
Open the database
Use the RMAN RESTORE command to switch to the image copy
Identify the correct sequence of the required steps:
A. 2, 6, 4, 5, 3
B. 1, 2, 4, 6, 3
C. 1, 2, 7, 5, 3, 6
D. 2, 4, 5, 3, 6
E. 2, 7, 5, 3
正解：A

質問 3：
Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?
Choose two.
A. If no PDB plan is enabled for a pluggable database, all sessions for that PDB are treated to an equal share of resources.
B. To enable a resource plan for a PDB, a CDB resource plan must be created and enabled.
C. If a PDB plan is enabled for a pluggable database, Resource Manager uses the resource allocation at the PDB level and ignores the limits set at the CDB level.
D. If a PDB plan is enabled for a pluggable database, resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.
E. If no PDB plan is enabled for a pluggable database, the PDB uses the CDB plan.
正解：D,E

質問 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 created a tablespace with this statement:
CREATE BIGFILE TABLESPACE adtbs
DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G;
The tablespace is nearly full and you need to avoid any out of space errors for the load of a 5 gig table.
Which two alter statements will achieve this?
A. ALTER TA3LESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf AUTOEXTEND ON;
B. ALTER TA3LESPACE adtbs ADD DATAFILE;
C. ALTER TABLESPACE adtbs AUTOEXTEND ON;
D. ALTER TA3LESPACE adtbs RESI2E 20G;
E. ALTER TA3LESPACE adtbs ADD DATAFILE '/proddb/data/adtbsl.dbf' SIZE 1QG;
正解：C,D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. This consumes a lot of undo tablespace and is affecting undo retention.
Which two actions would you take to solve this problem?
A. Enable temporary undo for the database.
B. Enable Automatic Memory Management (AMM).
C. Increase the size of the temporary tablespace.
D. Increase the size of the redo log buffer.
E. Enable undo retention guarantee.
正解：A,C

質問 7：
You plan to migrate a production database to Real Application Clusters (RAC).
You created a test RAC database by cloning the production database and plan to replay a workload, captured from the production database.
Examine these steps:
1) Preprocess the captured workload.
2) Restart the database instance in RESTRICTED mode.
3) Set up Replay Clients.
4) Restore the test database to the point when the capture started on the production database.
5) Remap connections.
Which is the correct sequence of required steps?
A. 1, 2, 4, 5, 3
B. 2, 1, 5, 3, 4
C. 1, 4, 3, 5
D. 1, 4, 5, 3
正解：C