A.ItignoresNULLvalues
B.Reversingtheorderoftheintersectedtablesalterstheresult
C.ThenamesofcolumnsinallSELECTstatementsmustbeidentical
D.ThenumberofcolumnsanddatatypesmustbeidenticalforallSELECTstatementsinthequery
第1题
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题
A.TheLOBvaluesareautomaticallycompressed.
B.TheLOBvaluesarecachedbydefaultinthebuffercache.
C.TheLOBvaluesareautomaticallystoredinencryptedmode.
D.AllLOBdatathatisidenticalintwoormorerowsinaLOBcolumnsharethesamedatablocks.
第3题
A.NoflashbackispossibletobringbacktheITEMtable.
B.TheORDERtableisdroppedalongwiththeITEMtable.
C.ThedependentreferentialintegrityconstraintsintheORDERtablearedisabled.
D.ThedependentreferentialintegrityconstraintsintheORDERtableareremoved.
E.ThetabledefinitionoftheITEMtableandassociatedindexesareplacedintherecyclebin.
第4题
=’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题
failureresultedincorruptionofadatafilebelongingtotheTOOLStablespace.BackupsaretakenoneverySunday.Whatwouldyoudointhissituation?()
A.recoverusingOracleFlashbackDatabasetechnology
B.restorethedatafilesfrombackupandperformacompleterecovery
C.restoreonlythecorrupteddatafileandperformtablespacerecovery
D.restorethedatafilesfrombackupandperformcancel-basedrecovery
E.restoretheentiredatabasefromthemostrecentbackupandstarttheinstanceandopenthedatabase
第6题
A.SetthevalueoftheDB_BLOCK_CHECKINGinitializationparametertoTRUE
B.UsetheANALYZEutility.
C.UsetheDBVERIFYutility.
D.UsetheDBMS_REPAIRpackage.
第7题
A.BothUSINGandONclausescanbeusedforequijoinsandnonequijoins
B.AmaximumofonepairofcolumnscanbejoinedbetweentwotablesusingtheONclause
C.TheONclausecanbeusedtojointablesoncolumnsthathavedifferentnamesbutcompatibledatatypes
D.TheWHEREclausecanbeusedtoapplyadditionalconditionsinSELECTstatementscontainingtheONortheUSINGclause
第8题
catethisdatabaseinthesamesystemwiththenameDUPDB.Youwanttocreatethesamedirectorystructureforduplicatedatabasefilesasofthetargetdatabase.YouexecutedthefollowingRMANcommands:RMAN>CONNECTTARGETsys/sys@APPPRODRMAN>CONNECTAUXILIARYsys/sys@DUPDBRMAN>DUPLICATETARGETDATABASETOdupdbFROMACTIVEDATABASEPASSWORDFILESPILENOFILENAMECHECK;Whataretheimplicationsofthiscommand?()
A.ItcreatesdatabasefilesfortheduplicatedatabaseundertheOraclebasewithadifferentdirectoryfortheduplicatedatabase.
B.Itoverwritesdatafilesofthetargetdatabasebecauseadifferentlocationfordatafilesisnotmentionedfortheduplicatedatabase.
C.ItcreatesdatabasefilesfortheduplicatedatabaseunderthesameOraclehomeasthatofthetargetdatabasewiththesamedirectorystructure.
D.ItcreatesdatabasefilesfortheduplicatedatabaseunderthesameOraclehomeasthatofthetargetbutwithadifferentdirectoryfortheduplicatedatabase.
第9题
ablefirstbecauseitisgoingtobealongtransactionanddatafortheparenttablewillbeavailableinalaterstage,whichcanbeinsertedaspartofthesametransaction.ViewtheExhibittoexaminethecommandsusedtocreatetables.Whichactionwouldyoutaketodelaythereferentialintegritycheckinguntiltheendofthetransaction()
A.Settheconstrainttodeferredbeforestartingthetransaction.
B.AltertheconstrainttoNOVALIDATEstatebeforestartingthetransaction.
C.Enabletheresumablemodeforthesessionbeforestartingthetransaction.
D.SettheCOMMIT_WAITparametertoFORCE_WAITforthesessionbeforestartingthetransaction.
第10题
ablearecomplexandperformedonthetablefrequently.Whichadvisorhelpsyouachievethebestperformanceofdatabaseforqueriesbyrecommendingtheappropriateindexes?()
A.SQLAccessAdvisor
B.MemoryAdvisor
C.SQLTuningAdvisor
D.SegmentAdvisor
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!