Oneoftheredologmembersinyourdatabaseislost.YouqueriedV$logfileforfurtherdetails.Whatwouldbethemember’sstatus?()
A. LOST
B. INVALID
C. EXPIRED
DELETED
E. CORRUPT
F. UNKNOWNG.OBSOLETE
查看答案
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.