ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-062 All Questions

View all questions & answers for the 1z0-062 exam
Go to Exam

Exam 1z0-062 topic 1 question 49 discussion

Actual exam question from Oracle's 1z0-062
Question #: 49
Topic #: 1
[All 1z0-062 Questions]

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

  • A. All AWR tables belong to the SYSTEM schema.
  • B. The AWR data is stored in memory and in the database.
  • C. The snapshots collected by AWR are used by the self-tuning components in the database
  • D. AWR 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.
  • E. AWR contains system wide tracing and logging information.
Show Suggested Answer Hide Answer
Suggested Answer: BCD 🗳️
by euler at Aug. 21, 2019, 12:54 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
khalilshahin01
Highly Voted 4 years, 8 months ago
Tricky one! ADR contains system wide tracing and logging information (NOT AWR!). Therefore BCD
upvoted 8 times
...
Angeltje1992
Most Recent 5 years ago
I Think D is right: "Time model statistics based on time usage for activities, displayed in the V$SYS_TIME_MODEL and V$SESS_TIME_MODEL views"
upvoted 1 times
5kong
4 years, 11 months ago
#274 E. An AWR snapshot contains system-wide tracing and logging information. is false
upvoted 1 times
...
...
euler
5 years, 8 months ago
BCE? D is confuse
upvoted 1 times
hggz
5 years, 1 month ago
Yes correct: https://oracle-base.com/articles/10g/automatic-workload-repository-10g "Time model statistics indicating the amount of DB time associated with a process from the V$SESS_TIME_MODEL and V$SYS_TIME_MODEL views."
upvoted 4 times
hggz
5 years, 1 month ago
Link for 12.1: https://docs.oracle.com/database/121/TGDBA/gather_stats.htm#TGDBA169
upvoted 2 times
yosiw96816
4 years, 5 months ago
In your provided link: Time model statistics based on time usage for activities, displayed in the V$SYS_TIME_MODEL and V$SESS_TIME_MODEL views which makes BCD correct
upvoted 2 times
...
...
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago