Jamonero Blanco
Quiz by , created more than 1 year ago

OCA OCA Quiz on OCA-14-Maintaining the Database and Managing Performance, created by Jamonero Blanco on 01/30/2017.

19
2
0
Jamonero Blanco
Created by Jamonero Blanco almost 4 years ago
Close
  • OCA-14-Maintaining the Database and Managing Performance

    Question 1 of 20

    1

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

    Select one or more of the following:

    • A. ADDM

    • B. AWR

    • C. ASMM

    • D. ADR

    Explanation

    Question 2 of 20

    1

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

    Select one or more of the following:

    • A. OFF

    • B. TYPICAL

    • C. ALL

    • D. BASIC

    Explanation

    Question 3 of 20

    1

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

    Select one or more of the following:

    • A. AMM_TARGET

    • B. MEMORY_TARGET

    • C. SGA_TARGET

    • D. AUTOMATIC_MEMORY

    Explanation

    Question 4 of 20

    1

    4. Which two parameters configure automatic PGA memory management?

    Select one or more of the following:

    • A. SGA_TARGET

    • B. PGA_AGGREGATE_TARGET

    • C. WORKAREA_SIZE_POLICY

    • D. PGA_AGGREGATE_LIMIT

    Explanation

    Question 5 of 20

    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?

    Select one or more of the following:

    • A. SQL Tuning Advisor

    • B. SQL Access Advisor

    • C. Both A and B

    • D. Neither A nor B

    Explanation

    Question 6 of 20

    1

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

    Select one or more of the following:

    • A. SHARED_POOL

    • B. JAVA_POOL_SIZE

    • C. LOG_BUFFER

    • D. None of the above

    Explanation

    Question 7 of 20

    1

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

    Select one or more of the following:

    • A. DBMS_STATS.PUBLISH_STATS

    • B. DBMS_STATS.SET_TABLE_PREFS

    • C. DBMS_STATS.PENDING_STATS

    • D. DBMS_STATS.GATHER_TABLE_STATS

    Explanation

    Question 8 of 20

    1

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

    Select one or more of the following:

    • A. DBA_ADVISOR_FINDINGS

    • B. DBA_ADVISOR_OBJECTS

    • C. DBA_ADVISOR_RECOMMENDATIONS

    • D. DBA_ADVISOR_RATIONALE

    Explanation

    Question 9 of 20

    1

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

    Select one or more of the following:

    • A. SQL Tuning Advisor

    • B. SGA Tuning Advisor

    • C. Memory Advisor

    • D. Pool Advisor

    Explanation

    Question 10 of 20

    1

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

    Select one or more of the following:

    • A. CONTROL_MANAGEMENT_PACK_ACCESS

    • B. STATISTICS_LEVEL

    • C. MEMORY_TARGET

    • D. Memory advisors cannot be disabled.

    Explanation

    Question 11 of 20

    1

    11. Which statement regarding SGA_MAX_SIZE is true?

    Select one or more of the following:

    • 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 .

    Explanation

    Question 12 of 20

    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?

    Select one or more of the following:

    • A. Warning threshold

    • B. Critical threshold

    • C. Both A and B

    • D. Neither A nor B

    Explanation

    Question 13 of 20

    1

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

    Select one or more of the following:

    • 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.

    Explanation

    Question 14 of 20

    1

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

    Select one or more of the following:

    • 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

    Explanation

    Question 15 of 20

    1

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

    Select one or more of the following:

    • 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.

    Explanation

    Question 16 of 20

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

    Select one or more of the following:

    • A. Response time

    • B. Uptime

    • C. Throughput

    • D. Runtime

    Explanation

    Question 17 of 20

    1

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

    Select one or more of the following:

    • A. CORE_DUMP_DEST

    • B. BACKGROUND_DUMP_DEST

    • C. ALERT_LOG_DEST

    • D. DIAGNOSTIC_DEST

    Explanation

    Question 18 of 20

    1

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

    Select one or more of the following:

    • A. 8 days

    • B. 30 days

    • C. 7 hours

    • D. Indefinitely

    Explanation

    Question 19 of 20

    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?

    Select one or more of the following:

    • A. The Main screen

    • B. The Performance tab

    • C. The Administration tab

    • D. The Maintenance tab

    Explanation

    Question 20 of 20

    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?

    Select one or more of the following:

    • 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.

    Explanation