Evaluatethefollowingcode:SQL>VARIABLEtask_nameVARCHAR2(255);SQL>VARIABLEsql_stmtVARC
23 查阅
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.
参考答案: