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.
查看答案
WhichtwostatementsaboutFlashbackQueryaretrue？（）
A. Itisgeneratedbyusingtheredologfiles.
B. Ithelpsinrow-levelrecoveryfromusererrors.
C. ItcanbeperformedtorecoverALTERTABLEstatements
D. Itfailswhenundodatapertainingtothetransactionisoverwritten.
E. ThedatabasehastobeopenedwiththeresetlogsoptionafterperformingFlashbackQuery.
YouperformabackupusingthefollowingBACKUPcommand:RMAN>BACKUPASCOMPRESSEDBACKUPSETDATABASE,Whichstatementistrueofthiscommand？（）
Adifferentprocedureisrequiredtorestoreadatabasefromcompressedbackups
B. TheASCOMPRESSEDclauseoftheBACKUPcommandprovidedbyRMANisusedtocreatecompressedbackupsetsandimagecopies.
C. Usingthiscommandtocreatebackupsminimizesthebandwidthconsumed.
D. Usingthiscommandtocreatebackupsimprovestheperformanceofthebackupprocess
InSolaris10，thistoolprovidesanautomatedandproactiveapproachtopatchmanagement.Itprovidesagraphicaluserinterfaceaswellasacommandlineinterface.Whichtoolisit？（）
A. smpatch
B. Patchtool
C. Updatemanager
D. Patchmanager
AusercomplainsthathegetsthefollowingerrormessagerepeatedlyafterexecutingsomeSQLstatements.Theerrormessageforcestheusertologofffromandlogontothedatabasetocontinuehiswork.ORA-02392：exceededsessionlimitonCPUusage，youarebeingloggedoffWhichactionwouldyoutaketoincreasethesessionlimitonCPUusage？（）
A. Modifytheprofileassignedtotheuser.
B. Modifytherolesassignedtotheusers.
C. Modifytheobjectprivilegesassignedtotheuser.
D. Modifythesystemprivilegesassignedtotheusers.
E. ModifythevaluefortheRESOURCE_LIMITparameterintheparameterfile.
微信支付 
支付宝支付