exam questions

Exam 1z0-083 All Questions

View all questions & answers for the 1z0-083 exam

Exam 1z0-083 topic 1 question 72 discussion

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

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

  • A. By default, AWR snapshots are taken every 60 minutes.
  • B. Its collection level is determined by the value of the STATISTICS_LEVEL database parameter.
  • C. By default, AWR snapshots are retained for 7 days.
  • D. The taking of AWR snapshots can be disabled.
  • E. AWR data is stored in the SYSTEM tablespace.
Show Suggested Answer Hide Answer
Suggested Answer: ABD 🗳️

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
RinD
Highly Voted 2 years, 10 months ago
ABD. retain 8 days stored in SYSAUX
upvoted 14 times
...
flaviogcmelo
Highly Voted 1 year, 9 months ago
Selected Answer: ABD
I agree.
upvoted 5 times
...
Guhborges
Most Recent 6 months, 3 weeks ago
Selected Answer: ABD
A,B,D 100%
upvoted 1 times
...
_gio_
7 months, 3 weeks ago
Selected Answer: ABD
I'm sure ABD, agree with RinD
upvoted 1 times
...
ScottL
9 months, 1 week ago
Selected Answer: ABD
ABD correct
upvoted 1 times
...
ErikJanssen
1 year, 1 month ago
About B: with dbms_workload_repository.create_snapshot, you can specify a parameter flush_level with a possible value of 'TYPICAL' (default), and 'ALL').
upvoted 1 times
...
nobody347
2 years, 3 months ago
ABD -100%
upvoted 1 times
...
Neil107
2 years, 5 months ago
It's ABD.
upvoted 3 times
...
pgtips
3 years, 5 months ago
It is ABC
upvoted 1 times
pgtips
3 years, 5 months ago
Sorry, I meant ABD.
upvoted 6 times
...
...
marcinb32
3 years, 7 months ago
I think ACD
upvoted 1 times
ald85
3 years, 7 months ago
C is incorrect -> By default, the Automatic Workload Repository (AWR) generates snapshots of performance data once every hour, and retains the statistics in the workload repository for 8 days. https://docs.oracle.com/en/database/oracle/oracle-database/19/tdppt/automatic-database-performance-monitoring.html#GUID-8FFE01C9-57C9-4A5B-A410-108E99319DA0 The question is good corrected. -> ABD
upvoted 6 times
janw
3 years, 5 months ago
agree with abd
upvoted 6 times
...
...
...
klever35
3 years, 7 months ago
I have no observations.
upvoted 1 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago