题目内容

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)

WhyshouldyoubackupaduplicatedtablespaceafteraTSPITRiscomplete?()

A. Thetablespacecannotbeduplicatedorrestoredtoanypointintimeaftertheduplication.
B. Thetablespacecannotbeduplicatedorrestoredtothepointintimebeforetheduplication.
C. TheentiredatabasecannotberestoredafteraTSPITR,soabackupisrequired.
D. Youcannotbringthetablespaceonlineuntilitsbeenbackedup.
E. Thereisnorequirementtodoso,asRMANwillbackupthetablespaceaftertheTSPITR.

答案查题题库