Oracle Exam 1Z0-083 Topic 5 Question 107 Discussion

Actual exam question for Oracle's 1Z0-083 exam

Question #: 107
Topic #: 5

Which three statements are true about Automatic Workload Repository (AWR)?

AAll AWR tables belong to the SYSTEM schema.

BThe AWR data is stored in memory and in t he database.

CThe snapshots collected by AWR are used by the self-tuning components in the database

DAWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.

EAWR contains system wide tracing and logging information.

Show Suggested Answer

Suggested Answer: A, C, F

by Andra at Oct 25, 2024, 12:43 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-083 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Jina

7 days ago

Haha, I bet the guy who wrote option E is the same one who thinks AWR can do the dishes and walk the dog! But seriously, I agree with A, C, and D as the right answers.

upvoted 0 times

...

Hmm, I'm not sure about B. I thought the AWR data was only stored in the database, not in memory. And E seems a bit too broad - I don't think AWR contains all system-wide tracing and logging information.

upvoted 0 times

...

Marva

16 days ago

I think A, C, and D are the correct statements. The SYSTEM schema hosts the AWR tables, and the snapshots are used by the self-tuning components. The time model statistics are definitely a key feature of AWR.

upvoted 0 times

...

Kattie

19 days ago

I believe statement D is also true as AWR computes time model statistics for activities.

upvoted 0 times

...

Laila

20 days ago

I agree with Myra. Statement C makes sense for AWR functionality.

upvoted 0 times

...

Myra

26 days ago

I think statement C is true because AWR snapshots help in database self-tuning.

upvoted 0 times

...

Oracle Exam 1Z0-083 Topic 5 Question 107 Discussion

Contribute your Thoughts:

Jina

Erick

Marva

Kattie

Laila

Myra