题目内容

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.

WhichtwostatementsaretrueaboutSharedSQLAreaandPrivateSQLAreas()

A. SharedSQLAreawillbeallocatedinthesharedpool.
B. SharedSQLAreawillbeallocatedwhenasessionstarts.
C. SharedSQLAreawillbeallocatedinthelargepoolalways.
D. ThewholeofPrivateSQLAreawillbeallocatedintheProgramGlobalArea(PGA)always.
E. SharedSQLAreaandPrivateSQLAreawillbeallocatedinthePGAorlargepool.
F. ThenumberofPrivateSQLAreaallocationsisdependentontheOPEN_CURSORSparameter.

Whenperformingadatabaseduplication,whichduplicatedatabaseparameterwouldyousettoensurethattheonlineredologsarecreatedinthecorrectlocation?()

A. log_file_name_convert
B. convert_log_file_name
C. file_name_convert_log
D. redo_log_file_name_convert
E. logfile_convert_directory

答案查题题库