单项选择题
Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter?()
A. Automatic PGA Memory Management
B. Automatic SGA Memory Management
C. Automatic Shared Memory Management
D. Automatic Memory Management
E. Manual SGA Memory Management
F. None of the above
相关考题
-
单项选择题
PerformancedivergenceindicatedintheWorkloadReplayreportismostlikelyduetowhat?()
A. DML and SQL statement results that do not match between the capture and replay systems
B. When errors that occur in the capture system dont occur in the replay system
C. Top SQL statements
D. Infrastructure or system-configuration differences
E. Time-of-day differences between capture and replay systems -
多项选择题
Which two are the prerequisites to enable Flashback Data Archive?() (Choose two.)
A. Database must be running in archivelog mode.
B. Automatic undo management must be enabled.
C. Undo retention guarantee must be enabled.
D. The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM). -
单项选择题
You issue the following RMAN command to set a retention policy on a database: RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of issuing this command?()
A. After two days, a backup will be marked obsolete
B. After two days, a backup will be deleted from the media
C. If the RMAN repository has records of two or more recent backups of a file, then older backups will be deleted from the media.
D. If the RMAN repository has records of two or more recent backups of a file, then older backups will be marked obsolete.
