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 gather

题目
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.

相似考题

1.下面哪个函数可以返回逻辑值TRUE()。A、AND(TRUE，TRUE，FALSE)B、OR(TRUE，TRUE，FALSE)C、OR(FALSE，FALSE，FALSE)D、NOT(TRUE)

2.下面文件在启动MS－DOS后,()已驻留内存。A.COMMAND.COMB.FORMAT.EXEC.DISKCOPY.EXED.QIN.EXE

3.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.

4.Youexecutedthefollowingcommands：SQL>ALTERSESSIONSETOPTIMIZER_USE_PENDING_STATISTICS=false；SQL>EXECUTEDBMS_STATS.SET_TABLE_PREFS（’SH’，’CUSTOMERS’，’PUBLISH’，’false’）；SQL>EXECUTEDBMS_STATS.GATHER_TABLE_STATS（’SH’，’CUSTOMERS’）；WhichstatementiscorrectregardingtheabovestatisticscollectionontheSH.CUSTOMERStableintheabovesession？（）A.Thestatisticsarestoredinthependingstatisticstableinthedatadictionary.B.Thestatisticsaretreatedasthecurrentstatisticsbytheoptimizerforallsessions.C.Thestatisticsaretreatedasthecurrentstatisticsbytheoptimizerforthecurrentsessionsonly.D.Thestatisticsaretemporaryandusedbytheoptimizerforallsessionsuntilthissessionterminates.

更多“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?() ”相关问题

  • 第1题：

    Examinethecommand:SQL>DBMS_STATS.SET_TABLE_PREFS(’SH’,’CUSTOMERS’,’PUBLISH’,’false’);Whichstatementdescribestheeffectoftheabovecommand()

    A.AutomaticstatisticscollectionisstoppedfortheCUSTOMERStable.

    B.StatisticsfortheCUSTOMERStablearelockedandcannotbeoverwritten.

    C.ExistingstatisticsfortheCUSTOMERStablebecomeunusableforthequeryoptimizer.

    D.Subsequently，statisticsgatheredontheCUSTOMERStablearestoredaspendingstatistics


    参考答案：D

  • 第2题：

    表示SQL语句类别的Command属性是（）。

    A．CommandText

    B．CommandString

    C．SqlCommand

    D．CommandType


    CommandType

  • 第3题：

    3、command1 && comman2 || command3的含义是：（)

    A．当command1，command2成功时才执行command3

    B．当command1，command2失败时才执行command3

    C．当command1失败，command2成功时才执行command3

    D．当command1成功，command2失败时才执行command3


    当 command1 成功， command2 失败时才执行 command3

  • 第4题：

    Command对象可以执行SQL语句


    正确

  • 第5题：

    执行SQL语句时，SQL语句应设置在Command对象的（)属性中。

    A．SqlCommand

    B．CommandString

    C．CommandText

    D．CommandSql


    正确

相关内容