1Z1-050 무료 덤프문제 온라인 액세스

Observe the following warning in an RMAN session of your database instance:
WARNING: new failures were found since last LIST FAILURE command
Which statement describes the scenario that must have produced this warning?

• A.The CHANGE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR).
• B.The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE command was executed.
• C.The ADVISE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE
• D.The VALIDATE DATABASE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR).

What recommendations does the SQL Access Advisor provide for optimizing SQL queries? (Choose all that apply.)

• A.optimization of materialized views for maximum query usage and fast refresh
• B.selection of SQL plan baselines
• C.creation of bitmap, function-based, and B-tree indexes
• D.creation of index-organized tables
• E.partitioning of tables and indexes

To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code:
BEGIN
dbms_advisor.create_task(dbms_advisor.sqlaccess_advisor,lTASK1l);
END;
/
BEGIN
dbms_advisor.set_task_parameter(lTASK1l,lANALYSIS_SCOPElllALLl);
dbms_advisor.set_task_parameter(lTASK1,,,MODE,llCOMPREHENSIVEl);
END;
/
BEGIN
dbms_advisor.execute_task('TASK1');
dbms_output.put_line(dbms_advisor.get_task_script('TASK11));
END;
/
The blocks of code execute successfully; however, you do not get the required outcome.
What could be the reason?

• A.The type of structures (indexes, materialized views, or partitions) to be recommended need to be specified for the task.
• B.A template needs to be associated with the task.
• C.The partial or complete workload scope needs to be associated with the task.
• D.A workload needs to be associated with the task.

Which statements are true regarding table compression? (Choose all that apply.)

• A.It incurs extra CPU overhead during DML but not direct loading operations.
• B.It requires uncompress operation during I/O.
• C.It saves disk space but has no effect on memory usage.
• D.It saves disk space and reduces memory usage.
• E.It incurs extra CPU overhead during DML as well as direct loading operations.

When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this? (Choose two.)

• A.It automatically calls the SQL Tuning Advisor for recommendations.
• B.It produces less accurate results of the comparison analysis.
• C.Only the changes in the execution plan, and not performance regression, are detected.
• D.It shortens the time of execution and reduces the impact on system resources