1z0-062 試験問題を無料オンラインアクセス

Which three statements are true about Oracle Restart? (Choose three.)

• A.It runs periodic check operations to monitor the health of Oracle components.
• B.It can be configured to automatically attempt to restart various components after a hardware or software failure.
• 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.While starting any components, it automatically attempts to start all dependencies first and in proper order.

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.2, 1, 4, 3, 5
• B.1, 2, 3, 4, 5
• C.1, 2, 4, 5
• D.2, 4, 5

You plan to upgrade your Oracle Database 9i to Oracle Database 12c.
Which two methods can you use? (Choose two.)

• A.Install the Oracle Database 12c software, create a new Oracle 12c database, and then use the Oracle Data Pump to import data from the source Oracle 9i database to the target Oracle 12c database.
• B.Perform a direct upgrade by manually running the catctl.pl and catupgrd.sql scripts before issuing the STARTUPUPGRADE command.
• C.Perform a direct upgrade by running the Database Upgrade Assistant (DBUA).
• D.Perform a rolling upgrade.
• E.Upgrade your current database to Oracle Database release 10.2.0.5, and then upgrade to Oracle Database
  12c.

You determine that database performance is sub-optimal due to hard parsing statements. Automatic Shared Memory Management (ASMM) is disabled for your database instance.
Which tool would you use to get advice on how to improve performance?

• A.SQL Access Advisor
• B.Memory Advisor for the shared pool
• C.SQL Tuning Advisor
• D.Memory Advisor for the PGA

A database uses Automatic Storage Management (ASM) as database storage, which has a diskgroup, DATA1, which is created as follows:

What happens when the FAILGRP1 failure group is corrupted?

• A.Transactions that are using the diskgroup fail.
• B.ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the FAILGRP2 failure group.
• C.Mirroring of allocation units occurs within the FAILGRP2 failure group.
• D.Data in the FAILGRP1 failure group is moved to the FAILGRP2 failure group and rebalancing is started.