1z0-063 무료 덤프문제 온라인 액세스

Examine the parameters for your database instance:
NAME TYPE VALUE
------------------------------------------------
optimizer_adaptive_reporting_only boolean FALSE
optimizer_capture_sql_plan_baselines boolean FALSE
optimizer_dynamic_sampling integer 2
optimizer_features_enable string 12.1.0.1
Which three statements are true about the process of automatic optimization by using statistics feedback?
(Choose three.)

• A.After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.
• B.The optimizer can re optimize a query only once using cardinality feedback.
• C.The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.
• D.The optimizer enables monitoring for cardinality feedback after the first execution of a query.
• E.The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.

Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup? (Choose two.)

• A.Tables with NOT NULL constraints cannot be recovered.
• B.Tables or table partitions with a foreign key cannot be recovered.
• C.Tables or table partitions can be recovered only when the database is in MOUNT state.
• D.Tables or table partitions from the SYSTEM and SYSAUX tablespaces cannot be recovered.
• E.Tables or table partitions can be recovered by using an auxiliary instance only.

In the SPFILE, UNDO TABLESPACE is Set to UNDOTBS.
You rename the undotbs undo tablespace:
ALTER TABLESPACE undotbs RENAME TO undotbs_old;
Which statement is true?

• A.You must set the undo_tablespace parameter to some other tablespace name before renaming undotbs.
• B.The tablespace will be renamed and a message written to the alert log indicating that you should change the corresponding initialization parameter.
• C.The tablespace will be renamed but the data file headers will not be updated.
• D.The statement will fail because you cannot rename an undo tablespace.
• E.The tablespace will be renamed and all the changes will be logged in the alert log.

Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

• A.The ADR base keeps all diagnostic information in binary format.
• B.The ADR is used to store Automatic Workload Repository (AWR) snapshots.
• C.The ADR can be used for problem diagnosis even when the database instance is down.
• D.The ADR can be used to store statspack snapshots to diagnose database performance issues.
• E.The ADR base is shared across multiple instances.

Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users:
1. Create a policy to capture the privileges used by a user for privilege analysis.
2. Generate a report with the data captured for a specified privilege capture.
3. Start analyzing the data captured by the policy.
4. Revoke the unused privileges.
5. Compare the used and unused privileges' lists.
6. Stop analyzing the data.
Identify the correct sequence of steps.

• A.1, 3, 5, 6, 2, 4
• B.1, 3, 6, 2, 5, 4
• C.1, 3, 5, 2, 6, 4
• D.1, 3, 2, 5, 6, 4