OCA-14-Maintaining the Database and Managing Performance

Description

OCA OCA Quiz on OCA-14-Maintaining the Database and Managing Performance, created by Jamonero Blanco on 30/01/2017.
Jamonero Blanco
Quiz by Jamonero Blanco, updated more than 1 year ago
Jamonero Blanco
Created by Jamonero Blanco about 7 years ago
37
2

Resource summary

Question 1

Question
1. Which of the following components of the Oracle architecture stores the statistics gathered by the MMON process?
Answer
  • A. ADDM
  • B. AWR
  • C. ASMM
  • D. ADR

Question 2

Question
2. Which of the following options for the pfile/spfile’s STATISTICS_LEVEL parameter turns off AWR statistics gathering and ADDM advisory services?
Answer
  • A. OFF
  • B. TYPICAL
  • C. ALL
  • D. BASIC

Question 3

Question
3. Which parameter is used to enable Automatic Memory Management?
Answer
  • A. AMM_TARGET
  • B. MEMORY_TARGET
  • C. SGA_TARGET
  • D. AUTOMATIC_MEMORY

Question 4

Question
4. Which two parameters configure automatic PGA memory management?
Answer
  • A. SGA_TARGET
  • B. PGA_AGGREGATE_TARGET
  • C. WORKAREA_SIZE_POLICY
  • D. PGA_AGGREGATE_LIMIT

Question 5

Question
5. Suppose you have used EM Database Control to drill down into ADDM findings and have found that a single SQL statement is causing the majority of the I/O on your system. Which of the following advisors is best suited to troubleshoot this SQL statement?
Answer
  • A. SQL Tuning Advisor
  • B. SQL Access Advisor
  • C. Both A and B
  • D. Neither A nor B

Question 6

Question
6. Which SGA component cannot be dynamically changed after instance startup?
Answer
  • A. SHARED_POOL
  • B. JAVA_POOL_SIZE
  • C. LOG_BUFFER
  • D. None of the above

Question 7

Question
7. Which procedure is used to tell Oracle that the statistics gathered should not be published?
Answer
  • A. DBMS_STATS.PUBLISH_STATS
  • B. DBMS_STATS.SET_TABLE_PREFS
  • C. DBMS_STATS.PENDING_STATS
  • D. DBMS_STATS.GATHER_TABLE_STATS

Question 8

Question
8. Which data dictionary view contains information explaining why ADDM made its recommendations?
Answer
  • A. DBA_ADVISOR_FINDINGS
  • B. DBA_ADVISOR_OBJECTS
  • C. DBA_ADVISOR_RECOMMENDATIONS
  • D. DBA_ADVISOR_RATIONALE

Question 9

Question
9. Which of the following advisors determines if the space allocated to the shared pool, large pool, or buffer cache is adequate?
Answer
  • A. SQL Tuning Advisor
  • B. SGA Tuning Advisor
  • C. Memory Advisor
  • D. Pool Advisor

Question 10

Question
10. Which initialization parameter can disable memory advisors and Automatic Shared Memory Management? (Choose the best answer.)
Answer
  • A. CONTROL_MANAGEMENT_PACK_ACCESS
  • B. STATISTICS_LEVEL
  • C. MEMORY_TARGET
  • D. Memory advisors cannot be disabled.

Question 11

Question
11. Which statement regarding SGA_MAX_SIZE is true?
Answer
  • A. SGA_MAX_SIZE is modifiable after an instance is started, only when Automatic Mem- ory Management is used.
  • B. SGA_MAX_SIZE is not dynamically modifiable.
  • C. SGA_MAX_SIZE is ignored when MEMORY_TARGET > 0 .
  • D. SGA_MAX_SIZE must be specified when SGA_TARGET > 0 .

Question 12

Question
12. When you configure an alert, which of the following types of alert thresholds can you use to monitor a tablespace for diminishing free space?
Answer
  • A. Warning threshold
  • B. Critical threshold
  • C. Both A and B
  • D. Neither A nor B

Question 13

Question
13. Multiple baseline metrics can be gathered and stored in the AWR. Why might you want more than one metrics baseline?
Answer
  • A. You might want a separate baseline metric for each user.
  • B. You might want a separate baseline metric for daytime usage versus off-hours usage.
  • C. You might want a separate baseline metric for each schema.
  • D. You would never want more than one baseline metric, even though it is possible to gather and store them.

Question 14

Question
14. When does ADDM run? (Choose two.)
Answer
  • A. When an AWR snapshot is taken automatically by the MMON process
  • B. When an AWR snapshot is taken automatically by the MMNL process
  • C. When an AWR snapshot is taken manually by DBA
  • D. When the AutoTask process runs hourly to take workload snapshots

Question 15

Question
15. Which statement about the MEMORY_TARGET parameter is not true?
Answer
  • A. It is a dynamic initialization parameter.
  • B. It represents the total maximum memory that can be allocated to the instance memory (PGA and SGA combined).
  • C. Its default value is zero.
  • D. You will not get an error when SGA_TARGET and PGA_AGGREGATE_TARGET param- eters are set to nonzero values.

Question 16

Question
16. Which of the following is a performance metric that could be defined as “the amount of work that a system can perform in a given amount of time”?
Answer
  • A. Response time
  • B. Uptime
  • C. Throughput
  • D. Runtime

Question 17

Question
17. Which parameter determines the location of the alert log?
Answer
  • A. CORE_DUMP_DEST
  • B. BACKGROUND_DUMP_DEST
  • C. ALERT_LOG_DEST
  • D. DIAGNOSTIC_DEST

Question 18

Question
18. By default, how long will database statistics be retained in the AWR?
Answer
  • A. 8 days
  • B. 30 days
  • C. 7 hours
  • D. Indefinitely

Question 19

Question
19. Your users have called to complain that system performance has suddenly decreased markedly. Which is the most likely place to look for the cause of the problem in EM Database Control?
Answer
  • A. The Main screen
  • B. The Performance tab
  • C. The Administration tab
  • D. The Maintenance tab

Question 20

Question
20. Using EM Database Control, you’ve identified the following SQL statement as the source of a lot of disk I/O: SELECT NAME, LOCATION, CREDIT_LIMIT FROM CUSTOMERS What should you do first to try to improve performance?
Answer
  • A. Run the SQL Tuning Advisor.
  • B. Run the SQL Access Advisor.
  • C. Check the EM Database Control main screen for alerts.
  • D. Click the Alert Log Content link in the EM Database Control main screen.
Show full summary Hide full summary

Similar

Ciencia Abierta en la UNC
Mario Pizzi
ROUND & TRUNC [DATES]
Adrian Mora
Cell Structure
daniel.praecox
Meriya Pinales & Malika Hurt
hurtmalika
Gothic vocabulary
lizzie.lambrou
IB Economics: International Trade
Han Zhang
HRCI Glossary of Terms A-N
Sandra Reed
Business Studies Unit 1
emily.mckechnie
Meiosis vs. Mitosis
nvart00
maths notes
grace tassell
1PR101 2.test - Část 6.
Nikola Truong