单项选择题
In your database, the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command:
SQL>SELECT /*+ RESULT_CACHE */ sale_category, sum(sale_amt) FROM sales
GROUP BY sale_category;
Where would the result of this query be stored()?
A. database buffer cache
B. shared pool
C. PGA
D. large pool
相关考题
-
多项选择题
WhichtwoaretheprerequisitestoenableFlashbackDataArchive?()
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). -
多项选择题
InwhichsituationswilltheASMmetadatabackuphelpyourecovertheASMdiskinadiskgroup?()
A. when one or more file directory paths are accidentally deleted from an ASM disk group
B. when one of the disks in a disk group is accidentaly unplugged
C. when the data file on an ASM disk group gets corrupted
D. when one or more disks in an ASM disk group are lost -
多项选择题
WhichtwostatementsaretrueregardingHealthMonitorchecksinOracleDatabase11g?()
A. Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption.
B. Health Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible,corrupt or inconsistent.
C. Health Monitor checks can be used to verify the contents of dictionary entries for each dictionary object and fix it automatically.
D. Health Monitor checks are always initiated manually when there is some critical error.
