WhichtaskscanbeaccomplishedusingtheEnterpriseManagerSupportWorkbenchinOracleDatabase11g？（）
A. Generatereportsondatafailuresuchasdatafilefailures.
B. YoucantracktheServiceRequest（SR）andimplementrepairs.
C. YoucanpackageanduploaddiagnosticdatatoOracleSupport.
D. Youcanmanuallyrunhealthcheckstogatherdiagnosticdataforaproblem.
查看答案
Youareworkingona24x7（available24hoursperday，7daysperweek）productiondatabase.Anoperatingsystem（OS）userdeletesthealertlogfileaccidentally.Whichstatementinthisscenarioistrue？（）
A. Thedatabasecrashes.
B. TheDBAneedstore-createthefile.
C. Thefilegetsre-createdautomatically.
D. Thefilegetsrestoredautomaticallyfromthelastbackup.
E. TheDBAneedstoperformacompletedatabaserecovery.
F. TheDBAneedstoperformanincompletedatabaserecovery.
Whichthreestatementsaretrueregardingpersistentlightweightjobs？（）
A. Persistentlightweightjobsmodifyseveraltablesinthedatadictionarytogeneratealotofredo.
B. Theusercannotsetprivilegesonpersistentlightweightjobs.
C. Persistentlightweightjobsareusefulwhenusersneedtocreatealargenumberofjobsinashorttime.
D. Persistentlightweightjobsareusefulwhenusersneedtocreateasmallnumberofjobsthatruninfrequently.
E. Theuseofatemplateismandatorytocreatepersistentlightweightjobs.
TheDB_BLOCK_CHECKINGinitializationparameterissettoFALSE.Whatlevelofblockcheckingwouldbeperformed？（）
A. TheOracledatabasewillnotperformblockcheckingforanyofthedatablocks.
B. TheOracledatabasewillperformblockcheckingforthedefaultpermanenttablespaceonly.
C. TheOracledatabasewillperformblockcheckingforthedatablocksinallusertablespaces.
D. TheOracledatabasewillperformblockcheckingforthedatablocksintheSYSTEMtablespaceonly.
E. TheOracledatabasewillperformblockcheckingforthedatablocksintheSYSTEMandSYSAUXtablespaces.
Inyourtestdatabase，youhavecreatedtheORDERStableasanindex-organizedtable（IOT）.Tofacilitatefasterquerying，youhavecreatedamappingtableandabitmapindexontheORDER_FILLEDcolumn.Youobservethatthequeryperformancedegreeswhenusersperformalargevolumeoftransactions.Whileinvestigatingthereason，youfindthatthemappingtablesegmentisfragmented，leadingtopoorperformance.Whichoptionwouldyouusetodefragmentthemappingtablewithoutaffectingtheoriginaltabledata？（）
A. Exportandimportthemappingtable.
B. Dropandre-createthemappingtable.
C. Truncatethemappingtableandreinsertthevalues.
D. UsetheALTERTABL
E. .REBUILDcommandtodefragmentthemappingtable.
微信支付 
支付宝支付