题目内容（请给出正确答案）

[主观题]

WhichstatementistruewhenyouruntheSQLTuningAdvisorwithlimitedscope？（）

A.AccesspathanalysisisnotperformedfortheSQLstatements.

B.SQLstructureanalysisisnotperformedfortheSQLstatements.

C.SQLProfilerecommendationsarenotgeneratedfortheSQLstatements.

D.ThestalenessandabsenceofthestatisticsarenotcheckedfortheobjectsinthequerysuppliedtotheSQLTuningAdvisor.

查看答案

如搜索结果不匹配，请联系老师获取答案

您可能会需要：

重置密码查看订单联系客服

安装上学吧APP，拍照搜题省时又省心！

更多“Whichstatementistruewhenyourun…”相关的问题

第1题

WhichthreedescriptionsarecorrectabouttheeffectsoftheTRUNCATEcommandonatable（）

A.Thecorrespondingindexesforthetablearealsotruncated.

B.DeletetriggersonthetablearefiredduringtheexecutionoftheTRUNCATEcommand.

C.ThechildtableistruncatedwhentheTRUNCATEcommandisappliedontheparenttable.

D.Thehigh-watermark（HWM）issettopointtothefirstusabledatablockinthetablesegment.

E.NoundoorverylittleundodataisgeneratedduringtheexecutionoftheTRUNCATEcommand

点击查看答案

第2题

YouareusingtheDBVERIFYutilitytocheckthedatafilesforanyblockcorruption.Youwanttowritetheoutputofthedbvcommandtoafilenottothescreen.WhichparameteroftheDBVERIFYutilitywillyouuse？（）

A.FILE

B.PARFILE

C.LOGFILE

D.FEEDBACK

点击查看答案

第3题

TheORDERStablebelongstotheuserOE.OEhasgrantedtheSELECTprivilegeontheORDERStabletotheuserHR.WhichstatementwouldcreateasynonymORDsothatHRcanexecutethefollowingquerysuccessfully?（）

A.CREATESYNONYMordFORorders;ThiscommandisissuedbyOE

B.CREATEPUBLICSYNONYMordFORorders;ThiscommandisissuedbyOE

C.CREATESYNONYMordFORoe.orders;Thiscommandisissuedbythedatabaseadministrator

D.CREATEPUBLICSYNONYMordFORoe.orders;Thiscommandisissuedbythedatabaseadministrator

点击查看答案

第4题

Consider the following scenario for your database:- Backup optimization is enabled in RMAN

.- The recovery window is set to 7 days in RMAN.- The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007.- The TOOLS tablespace is read-only since November 4, 2007.On November 23, 2007, you issue the RMAN command to back up the database to disk.Which statement is true regarding the backup of the TOOLS tablespace?（）

A. The RMAN backup fails because the TOOLS tablespace is read-only

B. The RMAN skips the backup of the tablespace because backup optimization is enabled

C. The RMAN makes backup because optimization can be enabled only for backups to disk

D. The RMAN makes the backup because no backup of the tablespace exists within the seven day window

点击查看答案

第5题

YouwanttochecktheEMPtableintheuser，Scott’sschemaforblockcorruption.Youalsowanttofixthecorruptedblocks，ifany.Howwillyouaccomplishtherequiredtask？（）

A.byusingtheANALYZEutility

B.byusingtheDBVERIFYutility

C.byusingtheDB_BLOCK_CHECKINGparameter

D.byusingtheDBMS_REPAIRpackage

点击查看答案

第6题

YourdatabaseisrunningunderautomaticundomanagementandtheUNDO_RETENTIONparameterissetto900se

c.Youexecutedthefollowingcommandtoenableretentionguarantee：SQL>ALTERTABLESPACEundotbs1RETENTIONGUARANTEE；Whateffectwouldthisstatementhaveonthedatabase？（）

A.Theextentsinundotablespaceretaindatauntilthenextfulldatabasebackup.

B.Theextentscontainingcommitteddataintheundotablespaceareneveroverwritten.

C.Theextentswhichnolongercontainuncommitteddataintheundotablespacearenotoverwrittenforatleast15minutes.

D.Theextentscontainingcommitteddataintheundotablespacearenotoverwrittenuntiltheinstanceisshutdown.

点击查看答案

第7题

WhichstatementistrueregardingtheINTERSECToperator?（）

A.ItignoresNULLvalues

B.Reversingtheorderoftheintersectedtablesalterstheresult

C.ThenamesofcolumnsinallSELECTstatementsmustbeidentical

D.ThenumberofcolumnsanddatatypesmustbeidenticalforallSELECTstatementsinthequery

点击查看答案

第8题

Which two statements are true about setting the per-thread buffers higher than required?（）

A.More memory per thread is beneficial in all scenarios

B.It causes increased overhead due to initial memory allocation

C.It can affect system stability during peak load times, due to swapping

D.It requires increasing the thread_cache_size variable

点击查看答案

第9题

Evaluatethefollowingcommand：SQL>CREATETABLEdesign_data（idNUMBER，docCLOB）LOB（doc）STOREASSECUREFILE（DEDUPLICATE）；Whichstatementistrueregardingtheabovecommand？（）

A.TheLOBvaluesareautomaticallycompressed.

B.TheLOBvaluesarecachedbydefaultinthebuffercache.

C.TheLOBvaluesareautomaticallystoredinencryptedmode.

D.AllLOBdatathatisidenticalintwoormorerowsinaLOBcolumnsharethesamedatablocks.

点击查看答案

第10题

YouexecutethiscommandtodroptheITEMtable，whichhastheprimarykeyreferredintheORDERtable：SQL>DROPTABLEscott.itemCASCADECONSTRAINTSPURGE；Whichtwostatementsaretrueabouttheeffectofthecommand（）

A.NoflashbackispossibletobringbacktheITEMtable.

B.TheORDERtableisdroppedalongwiththeITEMtable.

C.ThedependentreferentialintegrityconstraintsintheORDERtablearedisabled.

D.ThedependentreferentialintegrityconstraintsintheORDERtableareremoved.

E.ThetabledefinitionoftheITEMtableandassociatedindexesareplacedintherecyclebin.

点击查看答案