网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
In Oracle 11g, which recommendations does the SQL Access Advisor generate?()
A. partitioning recommendations
B. statistics collection recommendations
C. index creation recommendations
D. materialized view recommendations
E. materialized view log recommendations
参考答案
更多 “ In Oracle 11g, which recommendations does the SQL Access Advisor generate?() A. partitioning recommendationsB. statistics collection recommendationsC. index creation recommendationsD. materialized view recommendationsE. materialized view log recommendations ” 相关考题
考题
Evaluatethefollowingcode:SQLVARIABLEtask_nameVARCHAR2(255);SQLVARIABLEsql_stmtVARCHAR2(4000);SQLBEGIN: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.
考题
oracle数据库(PLSQL)导入.sql文件出错:无效的字符集
sql脚本是前一阵子在XP系统上得ORACLE10g通过PLSQL—export导出的,后面把系统还成win7了oracle还是以前的安装文件安装了(也就是还是以前的oracle只不过在win重装了)之后导入前面的.sql脚本文件(用PLSQL-import)就报这个错了我不知道以前的oracle的字符集,所以不知道导入这个.sql文件要怎么修改现在的oracle的字符集??请高手帮忙
考题
关于SQL*PLUS的叙述正确的是()
A.SQL*PLUS是ORACLE数据库的专用访问工具B.SQL*PLUS是标准的SQL访问工具,可以访问各类关系型数据库C.SQL*PLUS是所有ORACLE应用程序的底层APID.SQL*PLUS是访问ORACLE数据库的唯一对外接口E.以上所述都不正确
考题
SQL*Plus是Oracle数据库的专用访问工具()
热门标签
最新试卷