1. Which dynamic performance view would you use to see what objects are present in the cache buffer?

a. V$BUFFER_STATISTICS
b. V$BUFFER_POOL
c. V$BH
d. V$BUFFER_OBJECTS

2. Which Dynamic view would you query to get the buffer cache hit ratio?

a. V$SYSSTAT
b. V$SGASTAT
c. V$SYSTEM_STATISTICS
d. V$CACHE_STATISTICS

3. What happens after issuing ALTER TABLE EMPLOYEE CACHE?

a. If the buffer pool storage parameter is set to KEEP, it has high priority for being kept in the Default buffers.
b. Data of the employee table is cached in the buffer cache and is retained in the Keep buffers.
c. If the buffer pool storage parameter is set to KEEP, it us cached in the Keep buffers
d. Data of the employee table is kept in the buffer and is retained in the Keep buffers as long it is being used.
e. If data is too big it resides in the Default buffer, and if it is too small it is retained in the Keep buffers

4. After performing a database health check, you find that the buffer cache hit ratio is 46%. What is the buffer cache hit ratio threshold?

a. 100%
b. 90%
c. 10%
d. 0%
e. 80%
f. 5%

5. What would you do if the Keep buffer hit ratio is not high enough?

a. Decrease the number of buffer
b. Increase the Keep cache size
c. Decrease the Keep cache size
d. Increase the number of Keep buffers
e. No action required

6. The Recycle buffer pool used to keep data of:

a. Small tables that are accessed frequently
b. Large tables that are accessed infrequently with full tables scans
c. Large tables that are accessed infrequently
d. Small tables that are accessed infrequently

7. What dynamic performance view would you use to determine if the buffer cache is properly allocated?

a. V$DB_CACHE_ADVICE
b. V$CACHE_ADVICE
c. V$BUFFER_ADVICE
d. DB_CACHE_ADVICE
e. DBA_CAHCE_ADVICE

8. Which statement is true about the buffer cache?

a. The Cache Advice feature determines what size the buffer cache should be.
b. The buffer cache size can be dynamically changed only if the Cache Advice feature is turned on.
c. The buffer cache size can be dynamically changed but this change is limited by the maximum SGA size value.
d. The cache size for 8K block size must be a multiple of 8K.

9. Select the columns you use to compute the buffer pool hit ratio. (Choose three.)

a. DB_BLOCK_GETS
b. BUFFER_BUSY_WAIT
c. CONSISTENT_GETS
d. PHYSICAL_READS
e. PHYSICAL_WRITES
f. DB_BLOCK_CHANGE

10. Which parameter does not impact the size of the buffer cache?

a. DB_BLOCK_BUFFERS
b. DB_BLOCK_SIZE
c. DB_CACHE_SIZE
d. DB_2K_CACHE_SIZE

11. Which value would you set for the cache advice parameter to turn it on and collect data?

a. TRUE
b. ON
c. READY
d. GO
e. RUN

12. If the SGA size is 256M, what would be the memory granule?

a. 4M
b. 8M
c. 16M
d. 32M

13. What two statements are used to cache data in the buffers?

a. ALTER TABLE … CACHE
b. SELECT /*+CACHE*/ …
c. CACHE TABLE …
d. ANALYZE TABLE … CACHE
e. SELECT … CACHE

14. When reading the output of the Cache Advice, what are you looking for?

a. The impact on physical reads if you reduce or increase the buffer cache
b. The impact on physical reads if you reduce or increase the SGA
c. The buffer cache hitratio for each block size
d. The hit ratio for each type of the buffer pool

15. Why would you want to look in the buffer cache?

a. To examine the number of blocks consumed by each data object
b. To predict the number of buffers needed for optimal performance
c. To see if you can cache more data objects in the buffer cache
d. To examine the type of data in each buffer pool

16. Which statement is true?

a. All DB_nK_CACHE_SIZE (where n is 2, 4, 8, 16, or 32) parameters must be configured at creation of the database.
b. If DB_BLOCK_SIZE is set to 8K, DB_8K_CACHE_SIZE cannot be set.
c. All DB_nK_CACHE_SIZE (where n is 2, 4, 8, 16, or 32) parameters must be configured before starting up the database.
d. You may set DB_8K_CACHE_SIZE if DB_BLOCK_SIZE is set to 8K.