网友您好， 请在下方输入框内输入要搜索的题目：

题目内容 （请给出正确答案）
Examine this command:SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’);Which three statements are true about the effect of this command?()

A. Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.

B. Statistics collection is not done for the CUSTOMERS table when database stats are gathered.

C. Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.

D. Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.

E. Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.

参考答案

更多 “ Examine this command:SQL exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’);Which three statements are true about the effect of this command?() A. Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.B. Statistics collection is not done for the CUSTOMERS table when database stats are gathered.C. Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.D. Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.E. Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics. ” 相关考题
考题 下面哪个函数可以返回逻辑值TRUE()。 A、AND(TRUE，TRUE，FALSE)B、OR(TRUE，TRUE，FALSE)C、OR(FALSE，FALSE，FALSE)D、NOT(TRUE)
查看答案
考题 Youexecutedthefollowingcommands：SQLALTERSESSIONSETOPTIMIZER_USE_PENDING_STATISTICS=false；SQLEXECUTEDBMS_STATS.SET_TABLE_PREFS（’SH’，’CUSTOMERS’，’PUBLISH’，’false’）；SQLEXECUTEDBMS_STATS.GATHER_TABLE_STATS（’SH’，’CUSTOMERS’）；WhichstatementiscorrectregardingtheabovestatisticscollectionontheSH.CUSTOMERStableintheabovesession？（）A.Thestatisticsarestoredinthependingstatisticstableinthedatadictionary.B.Thestatisticsaretreatedasthecurrentstatisticsbytheoptimizerforallsessions.C.Thestatisticsaretreatedasthecurrentstatisticsbytheoptimizerforthecurrentsessionsonly.D.Thestatisticsaretemporaryandusedbytheoptimizerforallsessionsuntilthissessionterminates.
查看答案
考题 下面文件在启动MS－DOS后,()已驻留内存。 A.COMMAND.COMB.FORMAT.EXEC.DISKCOPY.EXED.QIN.EXE
查看答案
考题 An operator has been asked if a system was rebooted. Which of the following commands should be used to determine if a reboot has occurred?() A. The name?command.The ?name?command.B. The ptime?command.The ?ptime?command.C. The hutdown ast?command.The ?hutdown ?ast?command.D. The ?etc/rc.shutdown?command.
查看答案
考题 Examinethecommand:SQLDBMS_STATS.SET_TABLE_PREFS(’SH’,’CUSTOMERS’,’PUBLISH’,’false’);Whichstatementdescribestheeffectoftheabovecommand() A.AutomaticstatisticscollectionisstoppedfortheCUSTOMERStable.B.StatisticsfortheCUSTOMERStablearelockedandcannotbeoverwritten.C.ExistingstatisticsfortheCUSTOMERStablebecomeunusableforthequeryoptimizer.D.Subsequently，statisticsgatheredontheCUSTOMERStablearestoredaspendingstatistics
查看答案
考题 Command对象可以执行SQL语句
查看答案
考题 表示SQL语句类别的Command属性是（）。A．CommandTextB．CommandStringC．SqlCommandD．CommandType
查看答案
考题 执行SQL语句时，SQL语句应设置在Command对象的（)属性中。A．SqlCommandB．CommandStringC．CommandTextD．CommandSql
查看答案
考题 3、command1 comman2 || command3的含义是：（)A．当command1，command2成功时才执行command3B．当command1，command2失败时才执行command3C．当command1失败，command2成功时才执行command3D．当command1成功，command2失败时才执行command3
查看答案
热门标签
最新试卷