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

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

You are managing an Oracle Database 11 g instance. You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication? (Choose all that apply.)

• A.A net service name should be set up and a listener configured with the target as well as the source database.
• B.The source database must be shut down cleanly if the database is in mounted state.
• C.The source database must be run in ARCHIVELOG mode if the database is open.
• D.The source database backup must be copied over the net for test database,

Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)

• A.failures that require no archive logs to be applied for recovery
• B.failures due to loss of connectivity-for example, an unplugged disk cable
• C.failures because a data file is renamed by error
• D.failures when no standby database is configured

You are managing an Oracle Database 11 g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statements regarding the ASM disk group compatibility attributes are true in this scenario? (Choose all that apply.)

• A.ASM compatibility controls which features for the ASM will be enabled.
• B.RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group
• C.The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances.
• D.The RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk.

In which cases is reference partitioning effective in enhancing performance?

• A.It is effective only in partitionwise joins provided that the query predicates are different from the partitioning key.
• B.It is effective in both partition pruning as well as partitionwise joins provided that the query predicates are identical to the partitioning key.
• C.It is effective only in partition pruning.
• D.It is effective in both partition pruning as well as partitionwise joins irrespective of whether the query predicates are different from or identical to the partitioning key.