156. You need to size the KEEP pool. Which calculation would you use to determine the initial size of the KEEP pool?
A.50% of the DEFAULT pool
B.50% of the RECYCLE pool
C.the total number of blocks of all the candidate objects that you need in the KEEP pool / the number of objects that you need in the KEEP pool
D.total number of blocks of all the candidate objects that you need in the KEEP pool + additional space to allow for object growth
ANSWER: D
157. You are working in an online transaction processing (OLTP) environment. The NORTH_SALES table contains one million rows. In which case would you issue the following command:
A.The keep pool is not configured.
B.The automatic PGA is not configured.
C.The NORTH_SALES table is accessed once a week.
D.The CURSOR_SPACE_FOR_TIME initialization parameter is set to FALSE.
E.All the queries on the NORTH_SALES table are rewritten using a materialized view.
ANSWER: C
158. Users in ABC Corp. complain about performance degradation during the last week of each month. Further investigation reveals that monthly consolidation reports are generated during the last week of each month. There is a poor hit ratio in the default pool. What would you recommend to resolve the issue?
A.configure KEEP pool
B.enable automatic PGA
C.configure RECYCLE pool
D.set the CURSOR_SPACE_FOR_TIME initialization parameter to TRUE
ANSWER: C
159. While querying the V$WAITSTAT data dictionary view, you find that the COUNT and TIME is very large for the class SEGMENT HEADER. How would you describe this problem?
A.Some segments are very large in size.
B.There is a contention in the least recently used (LRU) list.
C.The tablespace where the segments reside is very small.
D.The segment headers for some segments are very small.
E.There are not enough free list groups for certain segments. discuss performance
ANSWER: E
160. You find that there is a contention in the free list of the ORDERS table. Which two tasks would you accomplish to resolve the free list contention for the table? (Choose two.)
A.reset the high water mark of the table
B.increase the number of free lists of the table
C.move the table to a locally managed tablespace
D.export and import the table by using the Oracle Export and Import utility
E.move the table to a tablespace that is using Automatic Segment Space Management
ANSWER: BE
Tags:
Post comment:
◎welcome to give out your point。