Oracle 1z0-062 問題集

質問 1：
Which two statements are true about extents? (Choose two.)
A. Data blocks in an extent are logically contiguous but can be non-contiguous on disk.
B. Blocks belonging to an extent can be spread across multiple data files.
C. The blocks of a newly allocated extent, although free, may have been used before.
D. Data blocks in an extent are automatically reclaimed for use by other objects in a tablespace when all the rows in a table are deleted.
正解：A,C

質問 2：
The following parameter 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_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 メンバーにのみ表示されます)

質問 3：
Which three statements are true about the purpose of checkpoints? (Choose three.)
A. They reduce the time required for recovery in case of an instance failure.
B. They ensure that dirty buffers in the buffer cache are written to disk regularly.
C. They ensure that all the dirty buffers are written to disk during a normal shutdown.
D. They ensure that instance recovery starts in the event of an instance failure.
E. They ensure that uncommitted transactions are rolled back in case of an instance failure.
正解：A,B,C

質問 4：
In your database, the STATISTICS_LEVEL parameter is set to TYPICAL and an Automatic Workload Repository (AWR) snapshot is taken every 30 minutes.
Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)
A. It always compares the latest snapshot with the baseline snapshot for analysis.
B. It requires at least four AWR snapshots for analysis.
C. It runs after each AWR snapshot is created and it requires at least two snapshots for analysis.
D. It measures database performance by analyzing the wait time and CPU time of all non-idle user sessions.
E. It calls other advisors if required, but does not provide recommendations about the advisors to be used.
正解：C,D

質問 5：
Examine the parameters:
Your database instance is started with a PFILE.

You want to increase the size of the buffer cache. Free memory is available to increase the size of the buffer cache.
You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
Which is the outcome?
A. It fails because the SCOPE clause is missing.
B. The value is changed only in the PFILE and takes effect at the next instance startup.
C. Change is applied to the current instance, but does not persist after instance restart.
D. The value is changed for the current instance and in the PFILE.
正解：C