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.
IdentifythethreeprocessesthatcustomerscanchooseforpatchingWebLogicServer.()
A. DownloadpatchesfromMyOracleSupportandmanagethemusingSmartUpdate.
B. UseEnterpriseManagertodownloadpatchesfromMyOracleSupportandapplypatchestoWebLogic.
C. DownloadpatchesfromMyOracleSupportandmanuallymodifytheclasspathoftheapplicationserver(thoughitisnotrecommended).
DownloadpatchesfromMyOracleSupportandapplythemusingtheWebLogicAdminConsole.
E. UsetheAdminConsoletoconnecttoMyOracleSupportanddownloadpatchesandthentargetthemtothedomain.