网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
ExaminethefollowingPL/SQLblock：DECLAREmy_planspls_integer；BEGINmy_plans：=DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE（sql_id=>？9twu5t2dn5xd？；END；WhichstatementistrueabouttheplanbeingloadedintotheSQLplanbaselinebytheabovecommand？（）
A.ItisloadedwiththeFIXEDstatus.
B.ItisloadedwiththeACCEPTEDstatus.
C.ItisnotloadedwiththeENABLEDstatus.
D.ItisnotloadedwiththeACCEPTEDstatus.
参考答案
更多 “ ExaminethefollowingPL/SQLblock：DECLAREmy_planspls_integer；BEGINmy_plans：=DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE（sql_id=？9twu5t2dn5xd？；END；WhichstatementistrueabouttheplanbeingloadedintotheSQLplanbaselinebytheabovecommand？（）A.ItisloadedwiththeFIXEDstatus.B.ItisloadedwiththeACCEPTEDstatus.C.ItisnotloadedwiththeENABLEDstatus.D.ItisnotloadedwiththeACCEPTEDstatus. ” 相关考题
考题
WhichtypeofPL／SQLconstructwouldyouusetoautomaticallycorrecttheerrorresultingfromastatementthatwassuspendedduetoaspacerelatedproblem?()
A.functionB.packageC.procedureD.databasetriggerE.anonymousPL/SQLblock
考题
Which statement describes the effect of the execution of the above PL／SQL block?()
A. The plan baselines are verified with the SQL profiles.B. All fixed plan baselines are converted into nonfixed plan baselines.C. All the nonaccepted SQL profiles are accepted into the plan baseline.D. The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.
考题
ExaminethefollowingPL/SQLblock：SETSERVEROUTPUTONSETLONG10000ECLAREreportclob；BEGINreport：=DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE（）；DBMS_OUTPUT.PUT_LINE（report）；END；WhichstatementdescribestheeffectoftheexecutionoftheabovePL/SQLblock？（）A.TheplanbaselinesareverifiedwiththeSQLprofiles.B.Allfixedplanbaselinesareconvertedintononfixedplanbaselines.C.AllthenonacceptedSQLprofilesareacceptedintotheplanbaseline.D.ThenonacceptedplansintheSQLManagementBaseareverifiedwiththeexistingplanbaselines.
考题
WhichtypeofPL／SQLconstructwouldyouusetoautomaticallycorrecttheerrorresultingfromastatementthatwassuspendedduetoaspace－relatedproblem?()
A.functionsB.packageC.procedureD.databasetriggerE.anonymousPL/SQLblock
考题
YouobservethatinyourPRODdatabase，customerinformationisbeingmodifiedbysomeunauthorizedusers.YouwanttokeeptrackofallofthetransactionshappeningonthetableusingPL/SQL.WhichtypeofPL/SQLsubprogramorconstructwouldyouusetoaccomplishthistask？（）A.functionsB.packagesC.proceduresD.databasetriggersE.anonymousPL/SQLblock
热门标签
最新试卷