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

You want to convert your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task?

• A.the BACKUP AS COPY command of RMAN
• B.the CONVERT command of RMAN
• C.conventional export and import
• D.Data Pump Export and Import

What happens when you run the SQL Tuning Advisor with limited scope?

• A.SQL structure analysis is not performed for SQL statements.
• B.SQL Profile recommendations are not generated for SQL statements.
• C.Access path analysis is not performed for SQL statements.
• D.Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor.

What are the two different types of database duplication? (Choose two.)

• A.Backup-based
• B.Failure driven
• C.Active
• D.Online
• E.Passive

Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates?

• A.AWR baselines are always created using the Automatic Workload Repository (AWR) retention period as expiration duration.
• B.AWR baselines can be created on the basis of two time values.
• C.AWR baselines are always created as repeating baselines.
• D.AWR baselines are always created with infinite expiration duration.

You create a new Automatic Database Diagnostic Monitor (ADDM) task: instance_analysis_mode_task. To view the ADDM report, you use the following command:
SQL> SELECT dbms_addm.get_report('my_instance_analysis_mode_task') FROM dual; You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT's segments.
What would you do to achieve this?

• A.Add a parameter directive for the ADDM task.
• B.Add a segment directive for the ADDM task.
• C.Add a finding directive for the ADDM task.
• D.Disable the Segment Advisor from the Automatic Maintenance Task.