- Home
- Database
- Oracle 12 C
- OCA Oracle 12C Administration(1Z0-062)
66.
Which SGA component cannot be dynamically changed after instance startup?
- A.SHARED_POOL
- B.JAVA_POOL_SIZE
- C.LOG_BUFFER
- D.None of the above
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| The log buffer cannot be dynamically resized once the instance is started. There is rarely a need to dynamically adjust the redo log buffer. All other components in the SGA can be dynamically modified. |
67.
Which procedure is used to tell Oracle that the statistics gathered should not be
published?
- A.DBMS_STATS.PUBLISH_STATS
- B.DBMS_STATS.SET_TABLE_PREFS
- C.DBMS_STATS.PENDING_STATS
- D.DBMS_STATS.GATHER_TABLE_STATS
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| The DBMS_STATS.SET_TABLE_PREFS procedure is used to set the PUBLISH preference to FALSE . To be able to use the pending statistics, the OPTIMIZER_USE_PENDING_STATISTICS parameter must be set to TRUE in the session. |
68.
Which data dictionary view contains information explaining why ADDM made its
recommendations?
- A.DBA_ADVISOR_FINDINGS
- B.DBA_ADVISOR_OBJECTS
- C.DBA_ADVISOR_RECOMMENDATIONS
- D.DBA_ADVISOR_RATIONALE
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| DBA_ADVISOR_RATIONALE provides the rationale for each ADDM recommendation. The ADDM findings are stored in DBA_ADVISOR_FINDINGS . The objects related to the findings are shown in DBA_ADVISOR_OBJECTS . The actual ADDM recommendations are found in DBA_ADVISOR_RECOMMENDATIONS . |
69.
Which of the following advisors determines if the space allocated to the shared pool,
large pool, or buffer cache is adequate?
- A.SQL Tuning Advisor
- B.SGA Tuning Advisor
- C.Memory Advisor
- D.Pool Advisor
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| The Memory Advisor can help determine whether or not the overall size of the SGA is appropriate and whether or not memory is properly allocated to the SGA components. |
70.
Which initialization parameter can disable memory advisors and Automatic Shared
Memory Management? (Choose the best answer.)
- A.CONTROL_MANAGEMENT_PACK_ACCESS
- B.STATISTICS_LEVEL
- C.MEMORY_TARGET
- D.Memory advisors cannot be disabled.
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| Setting STATISTICS_LEVEL to BASIC disables Automatic Memory and Shared Mem- ory Management as well as the memory advisors. CONTROL_MANAGEMENT_PACK_ACCESS specifies which of the Server Manageability Packs is active in the Enterprise Edition of Oracle Database 12c. MEMORY_TARGET enables Automatic Memory Management, but it does not disable Shared Memory Management or the memory advisors |
|
|
||||||||||||||||||||||||||||
