OCA-14-Maintaining the Database and Managing Performance

1

1. Which of the following components of the Oracle architecture stores the statistics
gathered by the MMON process?

1

2. Which of the following options for the pfile/spfile’s STATISTICS_LEVEL parameter turns
off AWR statistics gathering and ADDM advisory services?

1

3. Which parameter is used to enable Automatic Memory Management?

1

4. Which two parameters configure automatic PGA memory management?

1

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?

1

6. Which SGA component cannot be dynamically changed after instance startup?

1

7. Which procedure is used to tell Oracle that the statistics gathered should not be
published?

1

8. Which data dictionary view contains information explaining why ADDM made its
recommendations?

1

9. Which of the following advisors determines if the space allocated to the shared pool,
large pool, or buffer cache is adequate?

1

10. Which initialization parameter can disable memory advisors and Automatic Shared
Memory Management? (Choose the best answer.)

1

11. Which statement regarding SGA_MAX_SIZE is true?

1

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?

1

13. Multiple baseline metrics can be gathered and stored in the AWR. Why might you
want more than one metrics baseline?

1

14. When does ADDM run? (Choose two.)

1

15. Which statement about the MEMORY_TARGET parameter is not true?

1

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”?

1

17. Which parameter determines the location of the alert log?

1

18. By default, how long will database statistics be retained in the AWR?

1

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?

1

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?

OCA OCA Quiz sobre OCA-14-Maintaining the Database and Managing Performance, criado por Jamonero Blanco em 30-01-2017.

OCA-14-Maintaining the Database and Managing Performance

1. Which of the following components of the Oracle architecture stores the statistics gathered by the MMON process?

2. Which of the following options for the pfile/spfile’s STATISTICS_LEVEL parameter turns off AWR statistics gathering and ADDM advisory services?

3. Which parameter is used to enable Automatic Memory Management?

4. Which two parameters configure automatic PGA memory management?

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?

6. Which SGA component cannot be dynamically changed after instance startup?

7. Which procedure is used to tell Oracle that the statistics gathered should not be published?

8. Which data dictionary view contains information explaining why ADDM made its recommendations?

9. Which of the following advisors determines if the space allocated to the shared pool, large pool, or buffer cache is adequate?

10. Which initialization parameter can disable memory advisors and Automatic Shared Memory Management? (Choose the best answer.)

11. Which statement regarding SGA_MAX_SIZE is true?

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?

13. Multiple baseline metrics can be gathered and stored in the AWR. Why might you want more than one metrics baseline?

14. When does ADDM run? (Choose two.)

15. Which statement about the MEMORY_TARGET parameter is not true?

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”?

17. Which parameter determines the location of the alert log?

18. By default, how long will database statistics be retained in the AWR?

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?

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?

1. Which of the following components of the Oracle architecture stores the statistics
gathered by the MMON process?

2. Which of the following options for the pfile/spfile’s STATISTICS_LEVEL parameter turns
off AWR statistics gathering and ADDM advisory services?

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?

7. Which procedure is used to tell Oracle that the statistics gathered should not be
published?

8. Which data dictionary view contains information explaining why ADDM made its
recommendations?

9. Which of the following advisors determines if the space allocated to the shared pool,
large pool, or buffer cache is adequate?

10. Which initialization parameter can disable memory advisors and Automatic Shared
Memory Management? (Choose the best answer.)

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?

13. Multiple baseline metrics can be gathered and stored in the AWR. Why might you
want more than one metrics baseline?

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”?

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?

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?