当前位置:1Z0-053题库

问题:

[单选]

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,’TASK1’); 
END; / 
BEGIN 
dbms_advisor.set_task_parameter(’TASK1’,’ANALYSIS_SCOPE’,’ALL’); dbms_advisor.set_task_parameter(’TASK1’,’MODE’,’COMPREHENSIVE’); 
END; 
/ 
BEGIN 
dbms_advisor.execute_task(’TASK1’); 
dbms_output.put_line(dbms_advisor.get_task_script(’TASK1’)); 
END; 
/ 
The blocks of code execute successfully;however,you do not get the required outcome. 
What could be the reason?()  

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

A competitor in the IBM Maximo Asset Management (IMAM) domain claims that their product contains pre-built workflows and common tasks that span and integrate across asset applications. What should a solution advisor do when a customer is considering such a solution?() Dispute the vendor's claims that these pre-built workflows even exist. 。 Inform the organization that workflow is an unimportant component in asset . 。 Inform the organization that all vendors have the same pre-built workflows incorporated in their products. 。 Inform the customer that if current business processes do not exactly match these workflows, customization is required.。 立体划线是在工件上几个互成()的表面上划线。 Which two statements are true about simple views?() Views can be created as read only.。 Views are data segments like tables.。 Views can be created on the basis of more than one table.。 Data manipulation language (DML) operations cannot be performed on views.。 Identify the channel settings that can be performed using the CONFIGURE CHANNEL or ALLOCATECHANNEL commands in RMAN() (choose all that apply) Limiting the input/output (I/O) bandwidth consumption。 Specifying the size of backup sets and backup pieces。 Specifying vendor-specific information for a media manager。 Specifying the parallelism for backup and restore operatio。 hich of the following RMAN structures can data from a datafile span?() RMAN backup-set pieces spanning backup sets 。 RMAN backup-set pieces within a given backup sets 。 RMAN backups 。 RMAN channels 。 None of the above。

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,’TASK1’); 
END; / 
BEGIN 
dbms_advisor.set_task_parameter(’TASK1’,’ANALYSIS_SCOPE’,’ALL’); dbms_advisor.set_task_parameter(’TASK1’,’MODE’,’COMPREHENSIVE’); 
END; 
/ 
BEGIN 
dbms_advisor.execute_task(’TASK1’); 
dbms_output.put_line(dbms_advisor.get_task_script(’TASK1’)); 
END; 
/ 
The blocks of code execute successfully;however,you do not get the required outcome. 
What could be the reason?()  

参考答案:

  参考解析

本题暂无解析

在线 客服