InwhichofthescenarioswilltheDBAperformrecovery()
A. Thealertlogfileiscorrupted.
B. Atablespaceisaccidentallydropped.
C. Oneoftheredologmembersiscorrupted.
D. Adatabaseuserterminatesthesessionabnormally.
E. Theharddiskonwhichthedatafileisstorediscorrupted.
查看答案
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.