Oracle 1z0-067 問題集

質問 1：
Which two resources might be prioritized between competing pluggable databases (PDBs) when creating a multitenant container database (COB) plan using Oracle Database Resource Manager?
A. maximum undo per consumer group
B. CPU
C. maximum number of sessions for a PDB
D. maximum idle time for a session in a PDB
E. parallel server limit
正解：B,E

質問 2：
Which three statements are true about the database instance startup after an instance failure?
A. Online redo log files and archived redo log files are required to complete the rollback stage of instance recovery.
B. The RECO process recovers the uncommitted transactions at the next instance startup.
C. Changes committed before the failure, which were not written to the data files, are re-applied.
D. Media recovery is required to complete the database recovery.
E. The SMON process automatically performs the database recovery.
F. Uncommitted changes are rolled back to ensure transactional consistency.
正解：C,E,F

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

質問 4：
The following parameters are set for your Oracle 12c database instance:
OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE
OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE
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_EVOVLE_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

質問 5：
You are connected to a pluggable database (PDB) as a common user with the sysdba privilege. The PDB is open and you issue the shutdown immediate command.
What is the outcome?
A. The command executes only if the common user is granted the set container privilege for the PDB.
B. The command results in an error because the PDB can be shut down only by a local user.
C. The PDB is closed.
D. The PDB is placed in mount state.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
You want to consolidate backup information and centrally manage backup and recovery scripts for multiple databases running in your organization.
Which two backup solutions can be used?
A. RMAN Media Management Library
B. Enterprise Manager Cloud Control
C. RMAN recovery catalog
D. Oracle Secure Backup
E. Enterprise Manager Database Express
正解：B,C
解説: (Topexam メンバーにのみ表示されます)

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