PGA
SHARED POOL
DATABASE BUFFER CACHE
REDO LOG BUFFER CACHE
LARGE POOL
第1题:
A.PGA
B.SHARED POOL
C.DATABASE BUFFER CACHE
D.REDO LOG BUFFER CACHE
E.LARGE POOL
第2题:
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()?
第3题:
A senior DBA asked you to execute the following command to improve performance:SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle);You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows.What could be a reason for this recommendation?()
A. The keep pool is not configured.
B. Automatic Workarea Management is not configured.
C. Automatic Shared Memory Management is not enabled.
D. The data blocks in the SUBSCRIBE_LOG table are rarely accessed.
E. All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view
第4题:
The Log Writer (LGWR) process reads information from the ()and writes it to the online logs.
第5题:
在SQL语句执行前的解析阶段,要判断其中涉及的表名和列名是否合法,判断所依据的信息存放在()
第6题:
()用于存放SQL语句最近使用的数据块。
第7题:
You noticed that large memory allocations for the Oracle backup and restore operations are causing a performance overhead on the shared pool. Which memory structure would you configure to avoid this performance overhead?()
第8题:
A.Database Buffer Cache
B.Redo Log Buff
C.Shared Pool
D.Large Pool
E.Java Pool
第9题:
You configured the large pool for Oracle backup and restore operations. As a result, which component would require less memory?()
第10题:
Identify the memory component from which memory may be allocated for: () 1: Session memory for the shared server 2: Buffers for I/O slaves 3: Oracle Database Recovery Manager (RMAN) backup and restore operations