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.
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.
相关考题:
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.
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.
窗体上有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按钮不可用
设a=2,b=3,c=4,d=5,下列表达式的值是______。Not aa+cA. -1B.1C.TrueD.Fal 设a=2,b=3,c=4,d=5,下列表达式的值是______。 Not a<=c Or 4*c=b^2 And b<>a+cA. -1B.1C.TrueD.False
墙体采用MU10蒸压粉煤灰砖、M5砂浆砌筑,砌体施工质量控制等级为B级,L梁下局部受压承载力验算结果(Nl≤ηγfAl),其左右端项数值与下列何组最为接近 ( )A..41.4kN<136.08kNB..73.8kN<136.08kNC..82.8kN<108.86kND..82.8kN<136.08kN
Fal10t四联症包括一组复杂的心血管畸形,其中不包括A.右心室肥厚B.肺动脉狭窄C.房间隔缺损D.高位室间隔缺损E.主动脉骑跨