1Z0-417 Free Practice Test

SQL Access Advisor takes database workload as input and recommends adding various access structures. Which three does it consider the impact of adding when it generates recommendations?

1. A. Materialized views
2. B. Indexes
3. C. Partitions
4. D. Tablespaces
5. E. V$ performance views
6. F. Hints

Correct Answer: BDE

Which is a capability that Active Session History (ASH) reports enable you to perform?

1. A. Compare database performance between two periods of time, and resolve performance degradation thatmay happen from one time period to another.
2. B. Analyze transient performance problems with the database that are short-lived and do not appear in theADDM analysis.
3. C. Optimize the performance of data access paths by creating the proper set of materialized views,materialized view logs, and indexes for a given workload.
4. D. Analyze transient performance problems that have happened in the database since it has been started.

Correct Answer: A

Which background process performs Automatic Workload Repository (AWR) tasks such as writing when a metric violates its threshold value, taking snapshots, and capturing statistics for recently modified SQL objects?

1. A. LGWR
2. B. DBWR
3. C. CKPT
4. D. MMON
5. E. MMNL

Correct Answer: D
Themanageability monitor process (MMON)performs many tasks related to theAutomatic Workload Repository (AWR). For example, MMON writes when ametricviolates its threshold value, taking snapshots, and capturing statistics value for recently modified SQL objects.
Reference:
https://docs.oracle.com/cd/E11882_01/server.112/e40540/process.htm#CNCPT008

In an Active Session History report, which response is correct?

1. A. 60 minutes of ASH data can be held in memory, so only 1 hour can be reported.
2. B. 60 minutes of ASH data can be held in memory, but more than 1 hour can be reported.
3. C. ASH data is available 24 hoursbecause AWR snapshots refresh every night.
4. D. As ASH data is flushed every 60 seconds, you need to set up a snapshot withDBA_JOBSfor what you want to keep.

Correct Answer: A

A customer asked you about Database Time (DB Time). Which are two correct statements you would include in your description of it?

1. A. It is the total time spent in database calls by all sessions in the database.
2. B. It is the total time spent in database calls by foreground sessions in the database.
3. C. It is the total time spent in database calls by background sessions in the database.
4. D. It includes non-idle wait time.
5. E. It is the overall response time.
6. F. It includes login, idle, background, and Zombie session wait time.

Correct Answer: BC