1z0-043 lesson 8 Monitoring and Managing Memory

1z0-043 lesson 8

完成!!!

是否显示我的答案
是否显示书上的答案和我的注释


1.
1、You observe that a database performance has degraded over a period of time. While investigating the reason, you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to, in order to determine that required size of the database buffer cache?
A. Memory Advisor
B. Segment Advisor
C. SQL Tuning Advisor
D. SQL Access Advisor
E. Automatic Database Diagnostic Monitor (ADDM)

E

是不是没有Memory Advisor这个东西

A

教材8-13
就叫Memory Advisor

2.
4、 You have set some of the initialization parameters as:
DB_BLOCK_SIZE = 8KB
SGA_MAX_SIZE = 2GB
SGA_TARGET = 0
SHARED_POOL_SIZE = 120MB
DB_CACHE_SIZE = 896MB
STREAM_POOL_SIZE = 0
LARGE_POOL_SIZE = 110 MB
Which two statements are correct? (Choose two.)
A. You cannot set a value for the DB_8K_CACHE_SIZE parameter.
B. If you increase the size of the large pool to 120 MB, then the memory allocated to the shared poll will be reduced to 110 MB.
C. If the value for SGA_TARGET is changed to 1 GB and SHARED_POOL_SIZE is set to 120 MB, then memory cannot be taken from the shared pool, even if the shared pool has free space available.
D. If an application attempts to allocate more than 120 MB from the shared pool and freespace is available in the buffer pool, then the free space from the buffer pool is allocatedto the shared pool.

AC

AC

A 教材8-7

3.
28. You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below:
SGA_TARGET= 10GB
SGA_MAX_SIZE = 14GB
STREAMS_POOL_SIZE = 1GB
SHARED_POOL_SIZE = 3GB
Which two statements are correct in this scenario? (Choose two.)
A. A maximum of 3 GB can be allocated to shared pool.
B. The value for SGA_TARGET can be increased up to a maximum of 14 GB.
C. A total of 14 GB memory will be allocated to the automatically tuned memory components.
D. Increasing the value for SGA_TARGET will automatically increase the memory allocated for STREAMS_POOL_SIZE.
E. Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parameters.
F. Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB.

BE

BE

4.
44. Your database is running on the automatic Program Global Area (PGA) memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do?
A. modify the HASH_AREA_SIZE initialization parameter
B. modify the PGA_AGGREGATE_TARGET initialization parameter
C. modify the WORK_AREASIZE_POLICY initialization parameter
D. increase the value of the SGA_TARGET initialization parameter
E. increase the value of the SGA_MAX_SIZE initialization parameter
F. increase the value of the SORT_AREA_SIZE initialization parameter

B

B

5.
117. You are working in a dedicated server environment. Your database is running in the automatic Program Global Area (PGA) memory management mode. Which two statements are correct in this scenario? (Choose two)
A. The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.
B. The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.
C. Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.
D. The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.

BD

BD

教材8-29

6.
140. You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned? (Choose four)
A. log buffer
B. Java pool
C. Large pool
D. Fixed SGA
E. Shared pool
F. Streams pool
G. Keep buffer cache
H. Database buffer cache

BCEFH
这题不对

BCEH

教材8-15
应该有5个是对的

7.
151. 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?
A. recycle buffer cache
B. large pool
C. streams pool
D. keep buffer cache
E. redo log buffer

B
不知道

B

不懂为什么选B

8.
161. The database has the data block size set to 8 KB. You need to import a tablespace with a 4 KB block size into the database. Which additional memory parameter(s) should be configured to perform a transportable tablespace import?
A. DB_4K_CACHE_SIZE only
B. DB_8K_CACHE_SIZE only
C. DB_BLOCK_SIZE and DB_4K_CACHE_SIZE
D. DB_BLOCK_SIZE and DB_8K_CACHE_SIZE
E. SGA_TARGET and DB_4K_CACHE_SIZE
F. DB_CACHE_SIZE only

A
什么意思, 选C?

A
对了

9.
164. You configured the large pool for Oracle backup and restore operations. As a result, which component would require less memory?
A. streams pool
B. shared pool
C. log buffer
D. keep buffer cache
E. recycle buffer cache

B
不懂

B

这题也不对, 应该是AB

10.
172. You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below:
SGA_TARGET = 10GB
SGA_MAX_SIZE = 14GB
STREAMS_POOL_SIZE = 1GB
SHARED_POOL_SIZE = 3GB
Which two statements are correct in this scenario? (Choose two.)
A. A total of 14 GB memory will be allocated to the automatically tuned memory components.
B. Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB.
C. The value for SGA_TARGET can be increased up to a maximum of 14 GB.
D. A maximum of 3 GB can be allocated to shared pool.
E. Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parameters.
F. Increasing the value for SGA_TARGET will automatically increase the memory allocated for STREAMS_POOL_SIZE.

CE
跟第3题差不多

CE

=====

没了




-fin-