ChoosethecorrectordertopackageanduploaddataforanincidenttoOracleSupport.()
A. Schedule,createnewpackage,viewmanifest,viewcontents
B. Createnewpackage,viewmanifest,viewcontents,schedule
C. Schedule,createnewpackage,viewcontents,viewmanifest
D. Createnewpackage,viewcontents,viewmanifest,schedule
E. Noneoftheabove.
查看答案
YouareusingResourceManagertomanagesystemresources.Whilecreatinganewdatabaseuser,youobservethattheuserisamemberofDEFAULT_CONSUMER_GROUPbydefault.Whatwouldbetheimplicationsofthis?()
A. TheResourceManagerplandoesnotaffecttheuser.
B. Theremustbeaplandirectiveinanyoftheplansofthegrouptocontroltheresources.
C. ThemembersofthegroupDEFAULT_CONSUMER_GROUPalwayshaveresourcerestrictions.
D. ThemembersofDEFAULT_CONSUMER_GROUParerestrainedfromaccessingthesystemtables.
E. Themembersofthisgroupcanchangetheirgroupwithoutthedatabaseadministrator’sintervention.
FlashbackDatabasereliesonwhichtechnologiestorecovertoapointintime?()
A. FlashbackDataArchive
B. Flashbacklogsintheflashrecoveryarea
C. FlashbUndotablespace
D. RMANcommandline
E. Noneoftheabove
YouhavesetTablespaceFullMetricsThresholdvaluesfortheUSERStablespaceasfollows:Warning(%):90Critical(%):95Whichbackgroundprocessisresponsibleforissuingalertswhenthethresholdiscrossed()
A. Systemmonitor(SMON)
B. Processmonitor(PMON)
C. Memorymanagerprocess(MMAN)
D. ManageabilityMonitorprocess(MMON)
Youobservethatdatabaseperformancehasdegradedoveraperiodoftime.Whileinvestigatingthereason,youfindthatthesizeofthedatabasebuffercacheisnotlargeenoughtocachealltheneededdatablocks.Whichadvisorycomponentwouldyoureferto,inordertodeterminetherequiredsizeofthedatabasebuffercache?()
A. MemoryAdvisor
B. SegmentAdvisor
C. SQLTuningAdvisor
D. SQLAccessAdvisor
E. AutomaticDatabaseDiagnosticMonitor(ADDM)