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’）；Whichstatementiscorrectregarding

题目

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.

相似考题

1.You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11.You executed the following commands:Which two statements are true regarding the tasks accomplished with these commands?（）A. They import all metadata from the RCAT10 catalog.B. They unregister the database from the RCAT10 catalog.C. They do not register the databases registered in the RCAT10 catalog.D. They register all databases registered in the RCAT10 catalog.

2.Fal10t四联症包括一组复杂的心血管畸形，其中不包括A、肺动脉狭窄B、高位室间隔缺损C、主动脉骑跨D、右心室肥厚E、房间隔缺损

3.窗体上有3个按钮Commandl、Command2和Command3，如以下代码： Private Sub Commandl Click() Command2．Enabled：Fal3e Command3．Vi3ible＝Fal3e End Sub 该程序的功能是 ( )A．当单击按钮Command1时, Command2和Command3按钮不可用B．当单击按钮Command1时, Command2和Command3按钮不可见C．当单击按钮Command1时, Cammand2按钮不可用和Command3按钮不可见D．当单击按钮Command1时, Command2按钮不可见和Command3按钮不可用

4.You executed the following commands:Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?()A. The statistics are stored in the pending statistics table in the data dictionary.B. The statistics are treated as the current statistics by the optimizer for all sessions.C. The statistics are treated as the current statistics by the optimizer for the current sessions only.D. The statistics are temporary and used by the optimizer for all sessions until this session terminates.

更多“Youexecutedthefollowingcommands:SQL>ALTERSESSIONSETOPTIMIZER_USE_PENDING_STATISTICS=fal ”相关问题

  • 第1题：

    设a=2,b=3,c=4,d=5,下列表达式的值是______。Not a<=c Or 4*c=b^2 And b<>a＋cA. －1B.1C.TrueD.Fal

    设a=2,b=3,c=4,d=5，下列表达式的值是______。 Not a＜=c Or 4*c=b^2 And b＜＞a+c

    A． -1

    B．1

    C．True

    D．False


    正确答案：D
    解析：本题考的是运算符的优先顺序。在表达式中，当运算符不只一种时，要先处理算术运算符，接着处理比较运算符，然后再处理逻辑运算符。本题中a=c返回真，4*c=b^2返回假，b＞a+c返回真。Not真就是假，假And真也返回假，最后假Or假，也返回假，所以最后值为False。

  • 第2题：




    墙体采用MU10蒸压粉煤灰砖、M5砂浆砌筑，砌体施工质量控制等级为B级，L梁下局部受压承载力验算结果(Nl≤ηγfAl)，其左右端项数值与下列何组最为接近 ( )

    A..41.4kN＜136.08kN
    B..73.8kN＜136.08kN
    C..82.8kN＜108.86kN
    D..82.8kN＜136.08kN

    答案：D
    解析：
    根据《砌体结构设计规范》(GB 50003—2001)第7.4.4条，该墙体局部受压面积为：Al=1.2bhb=1.2×240×300=86400mm2，η=0.7，γ=1.5；ηγfA1=0.7×1.5×1.5×86400=136.08kN；又挑梁的倾覆荷载设计值为：R=[1.2×16+1.4×6.4]×(1.38+0.09)=41.395kN；Nl=2R=2×41.395=82.79kN。

  • 第3题：

    Fal10t四联症包括一组复杂的心血管畸形，其中不包括

    A.右心室肥厚
    B.肺动脉狭窄
    C.房间隔缺损
    D.高位室间隔缺损
    E.主动脉骑跨

    答案：C
    解析：

  • 第4题：

    Ames试验中FAl00菌株用于检测

    A、移码突变

    B、碱基置换

    C、非整倍体

    D、DNA大段损伤

    E、平衡易位


    参考答案：B

  • 第5题：

    下列哪种心脏病常出现左心室增大

    A.房间隔缺损
    B.二尖瓣狭窄
    C.肺心病
    D.Fal10t四联征
    E.高血压心脏病

    答案：E
    解析：

相关内容