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

题目

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.