网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
What recommendations does the SQL Access Advisor provide for optimizing SQL queries?()
A. selection of SQL plan baselines
B. partitioning of tables and indexes
C. creation of index-organized tables
D. creation of bitmap, function-based, and B-tree indexes
E. optimization of materialized views for maximum query usage and fast refresh
参考答案
更多 “ What recommendations does the SQL Access Advisor provide for optimizing SQL queries?() A. selection of SQL plan baselinesB. partitioning of tables and indexesC. creation of index-organized tablesD. creation of bitmap, function-based, and B-tree indexesE. optimization of materialized views for maximum query usage and fast refresh ” 相关考题
考题
关于SQL查询,以下说法中不正确的是( )。A.SQL查询是用户使用SQL语句创建的查询B.SQL查询可以用结构化的查询语言(SQL)来查询、更新和管 Access这样的关系数据库C.在查询设计视图中创建查询时,Access将在后台构造等效的SQL语句D.SQL查询更改之后,可以以以前设计视图中所显示的方式显示,也可以在设计网格中进行创建
考题
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.
考题
Access支持的查询类型有( )。A.选择查询、交叉表查询、参数查询、SQL查询和操作查询B.多表查询、选择查询、参数查询、SQL查询和操作查询C.单表查询、多表查询、交叉表查询、SQL查询和操作查询D.选择查询、统计查询、交叉表查询、SQL查询和操作查询
考题
Access2010支持的查询类型有()。A.选择查询、交叉表查询、参数查询、SQL查询和操作查询B.选择查询、基本查询、参数查询、SQL查询和操作查询C.多表查询、单表查询、参数查询、SQL查询和操作查询D.汇总查询、参数查询、SQL查询和操作查询
热门标签
最新试卷