PGA
SHARED POOL
DATABASE BUFFER CACHE
REDO LOG BUFFER CACHE
LARGE POOL
第1题:
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()?
第2题:
在SQL语句执行前的解析阶段,要判断其中涉及的表名和列名是否合法,判断所依据的信息存放在()
第3题:
The Log Writer (LGWR) process reads information from the ()and writes it to the online logs.
第4题:
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?()
第5题:
You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned? ()
第6题:
Your database is using shared server configuration. Which optional memory structure would you configure to store the User Global Area (UGA) information and improve the shared pool performance?()
第7题:
Which component of the SGA stores parsed SQL statements is used for process sharing?()
第8题:
Configure Java Pool to cache the java objects.
Configure Streams Pool to enable parallel processing.
Increase Shared Pool size to cache more PL/SQL objects.
Increase Database Buffer Cache size to increase cache hits.
Configure Large Pool to be used by RMAN and shared server.
Increase the total System Global Area (SGA) size to increase memory hits.
第9题:
The keep pool is not configured.
Automatic Workarea Management is not configured.
Automatic Shared Memory Management is not enabled.
The data blocks in the SUBSCRIBE_LOG table are rarely accessed.
All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view
第10题:
Configure Java Pool to cache the java objects.
Configure Streams Pool to enable parallel processing.
Increase Shared Pool size to cache more PL/SQL objects.
Increase Database Buffer Cache size to increase cache hits.
Configure Large Pool to be used by RMAN and shared server.
Increase the total System Global Area (SGA) size to increase memory hits.
第11题:
PGA
SHARED POOL
DATABASE BUFFER CACHE
REDO LOG BUFFER CACHE
LARGE POOL
第12题:
Database Buffer Cache
Redo Log Buffer
Shared Pool
Large Pool
Java Pool
第13题:
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?()
第14题:
You configured the large pool for Oracle backup and restore operations. As a result, which component would require less memory?()
第15题:
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
第16题:
You find that the database performance degrades while you backup the PROD database using Recovery Manager (RMAN). The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation?()
第17题:
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
第18题:
SQL语句的编译和执行是在SGA的哪一部分中进行的()
第19题:
You work as a database administrator for Certkiller .com. You find that the database performance degrades while you backup the Certkiller database using Recovery Manager (RMAN). The Certkiller database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation?()
第20题:
large pool
streams pool
keep buffer cache
recycle buffer cache
第21题:
streams pool
shared pool
log buffer
keep buffer cache
recycle buffer cache
第22题:
database buffer cache
shared pool
PGA
large pool
第23题:
recycle buffer cache
large pool
streams pool
keep buffer cache
redo log buffer
第24题:
Configure the KEEP buffer pool and alter the table with the corresponding storage clause.
Increase the database buffer cache size.
Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.
Configure Automata Shared Memory Management.
Configure Automatic Memory Management