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

[主观题]

WhichstatementistrueregardingtheINTERSECToperator？（）

A.ItignoresNULLvalues

B.Reversingtheorderoftheintersectedtablesalterstheresult

C.ThenamesofcolumnsinallSELECTstatementsmustbeidentical

D.ThenumberofcolumnsanddatatypesmustbeidenticalforallSELECTstatementsinthequery

查看答案

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

您可能会需要：

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

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

更多“Whichstatementistrueregardingt…”相关的问题

第1题

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

点击查看答案

第2题

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

A.TheLOBvaluesareautomaticallycompressed.

B.TheLOBvaluesarecachedbydefaultinthebuffercache.

C.TheLOBvaluesareautomaticallystoredinencryptedmode.

D.AllLOBdatathatisidenticalintwoormorerowsinaLOBcolumnsharethesamedatablocks.

点击查看答案

第3题

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

A.NoflashbackispossibletobringbacktheITEMtable.

B.TheORDERtableisdroppedalongwiththeITEMtable.

C.ThedependentreferentialintegrityconstraintsintheORDERtablearedisabled.

D.ThedependentreferentialintegrityconstraintsintheORDERtableareremoved.

E.ThetabledefinitionoftheITEMtableandassociatedindexesareplacedintherecyclebin.

点击查看答案

第4题

Williamspecifiedthefollowinginitializationparametersettingsinthepfile：BACKGROUND_DUMP_DEST

=’u01\oradata\dir_A’USER_DUMP_DEST=’u01\oradata\dir_B’DB_CREATE_FILE_DEST=’u01\oradata\dir_C’DB_CREATE_ONLINE_LOG_DEST_n=’u01\oradata\dir_D’Williamenabledthechange-trackingfeaturebecausehedoesnotwanttoscantheentiredatafileduringbackup.Whatisthedefaultstoragelocationforthechangetrackingfile？（）

A.’u01\oradata\dir_A’

B.’u01\oradata\dir_B’

C.’u01\oradata\dir_C’

D.’u01\oradata\dir_D’

点击查看答案

第5题

YourdatabaseisinNOARCHIVELOGmodeandalogswitchhappensevery20minutes.OnThursdaymorning，media

failureresultedincorruptionofadatafilebelongingtotheTOOLStablespace.BackupsaretakenoneverySunday.Whatwouldyoudointhissituation？（）

A.recoverusingOracleFlashbackDatabasetechnology

B.restorethedatafilesfrombackupandperformacompleterecovery

C.restoreonlythecorrupteddatafileandperformtablespacerecovery

D.restorethedatafilesfrombackupandperformcancel-basedrecovery

E.restoretheentiredatabasefromthemostrecentbackupandstarttheinstanceandopenthedatabase

点击查看答案

第6题

YouwanttocheckallthedatablocksbeingwrittentothedatafilesbyanalyzingthedataoneachblockeverytimetheDBWnprocesswrites.Whichactionwillyouperformtocheckthedatablocks？（）

A.SetthevalueoftheDB_BLOCK_CHECKINGinitializationparametertoTRUE

B.UsetheANALYZEutility.

C.UsetheDBVERIFYutility.

D.UsetheDBMS_REPAIRpackage.

点击查看答案

第7题

WhichtwostatementsaretrueregardingtheUSINGandONclausesintablejoins?（）

A.BothUSINGandONclausescanbeusedforequijoinsandnonequijoins

B.AmaximumofonepairofcolumnscanbejoinedbetweentwotablesusingtheONclause

C.TheONclausecanbeusedtojointablesoncolumnsthathavedifferentnamesbutcompatibledatatypes

D.TheWHEREclausecanbeusedtoapplyadditionalconditionsinSELECTstatementscontainingtheONortheUSINGclause

点击查看答案

第8题

YouaremanagingtheAPPPRODdatabaseasaDBAwhichisnotusingtheOracle-managedfiles.Youplantodupli

catethisdatabaseinthesamesystemwiththenameDUPDB.Youwanttocreatethesamedirectorystructureforduplicatedatabasefilesasofthetargetdatabase.YouexecutedthefollowingRMANcommands：RMAN>CONNECTTARGETsys/sys@APPPRODRMAN>CONNECTAUXILIARYsys/sys@DUPDBRMAN>DUPLICATETARGETDATABASETOdupdbFROMACTIVEDATABASEPASSWORDFILESPILENOFILENAMECHECK；Whataretheimplicationsofthiscommand？（）

A.ItcreatesdatabasefilesfortheduplicatedatabaseundertheOraclebasewithadifferentdirectoryfortheduplicatedatabase.

B.Itoverwritesdatafilesofthetargetdatabasebecauseadifferentlocationfordatafilesisnotmentionedfortheduplicatedatabase.

C.ItcreatesdatabasefilesfortheduplicatedatabaseunderthesameOraclehomeasthatofthetargetdatabasewiththesamedirectorystructure.

D.ItcreatesdatabasefilesfortheduplicatedatabaseunderthesameOraclehomeasthatofthetargetbutwithadifferentdirectoryfortheduplicatedatabase.

点击查看答案

第9题

Youhavetwotableswithreferentialintegrityenforcedbetweenthem.Youneedtoinsertdatatothechildt

ablefirstbecauseitisgoingtobealongtransactionanddatafortheparenttablewillbeavailableinalaterstage，whichcanbeinsertedaspartofthesametransaction.ViewtheExhibittoexaminethecommandsusedtocreatetables.Whichactionwouldyoutaketodelaythereferentialintegritycheckinguntiltheendofthetransaction（）

A.Settheconstrainttodeferredbeforestartingthetransaction.

B.AltertheconstrainttoNOVALIDATEstatebeforestartingthetransaction.

C.Enabletheresumablemodeforthesessionbeforestartingthetransaction.

D.SettheCOMMIT_WAITparametertoFORCE_WAITforthesessionbeforestartingthetransaction.

点击查看答案

第10题

Youcreateatableinyourdatabasethatcontains50，000rowsapproximately.Thequeriesperformedonthet

ablearecomplexandperformedonthetablefrequently.Whichadvisorhelpsyouachievethebestperformanceofdatabaseforqueriesbyrecommendingtheappropriateindexes？（）

A.SQLAccessAdvisor

B.MemoryAdvisor

C.SQLTuningAdvisor

D.SegmentAdvisor

点击查看答案