万能百科  > 所属分类  > 

Evaluatethefollowingcode:SQL>VARIABLEtask_nameVARCHAR2(255);SQL>VARIABLEsq

Evaluatethefollowingcode:SQL>VARIABLEtask_nameVARCHAR2(255);SQL>VARIABLEsql_stmtVARCHAR2(4000);SQL>BEGIN:sql_stmt:=’SELECTCOUNT(*)FROMcustomersWHEREcust_state_province=’’CA’’’;:task_name:=’MY_QUICKTUNE_TASK’;DBMS_ADVISOR.QUICK_TUNE(DBMS_ADVISOR.SQLACCESS_ADVISOR,:task_name,:sql_stmt);END;Whatistheoutcomeofthisblockofcode?()

A.Itcreatesataskandworkload,andexecutesthetask.

B.Itcreatesataskandworkloadbutdoesnotexecutethetask.

C.Itproducesanerrorbecauseatemplatehasnotbeencreated.

D.ItproducesanerrorbecausetheSQLTuningSethasnotbeencreated.

正确答案:

参考A

词条内容仅供参考,如果您需要解决具体问题
(尤其在法律、医学等领域),建议您咨询相关领域专业人士。

标签