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

Exam 1z0-083 All Questions

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

Exam 1z0-083 topic 1 question 129 discussion

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

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

  • A. They are generated if STATISTICS_LEVEL is set to TYPICAL.
  • B. They are generated if STATISTICS_LEVEL is set to ALL.
  • C. They are always created automatically.
  • D. They are always created manually.
  • E. They can be retained forever.
  • F. They are generated if STATISTICS_LEVEL is set to BASIC.
Show Suggested Answer Hide Answer
Suggested Answer: ABE 🗳️
by dunhill at May 9, 2021, 9:02 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
xRodge
Highly Voted 2 years, 10 months ago
A - TRUE. Only STATISTICS_LEVEL=BASIC stops them being generated B - TRUE. Only STATISTICS_LEVEL=BASIC stops them being generated C - FALSE. You can create them manually. D - FALSE. The DB will, by default, create them automatically every hour E - TRUE. You can setup AWR Warehouse, allowing these reports to be kept, and queried, forever. F - FALSE. STATISTICS_LEVEL=BASIC stops them being generated So, ABE is correct. Ref: https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/STATISTICS_LEVEL.html
upvoted 9 times
...
_gio_
Most Recent 10 months, 3 weeks ago
Selected Answer: ABE
I agree with xRodge
upvoted 1 times
...
ScottL
1 year ago
Selected Answer: ABE
ABE - see xrodge
upvoted 1 times
...
G_C
1 year, 7 months ago
Selected Answer: ABE
No doubts no comments. See xRodge's explanation.
upvoted 1 times
...
smartvan
2 years, 7 months ago
ABE is correct
upvoted 3 times
...
Neil107
2 years, 9 months ago
It's ABE.
upvoted 3 times
...
navingupta52
2 years, 11 months ago
ABE are correction options. Snapshots can be retained forever in warehouse environment so E is correct.
upvoted 1 times
...
Aldrid
3 years ago
A, B, E E: https://docs.oracle.com/database/121/TDPPT/tdppt_auto.htm#TDPPT025 C,D - not always.. based on statistic_level F- only manual possible
upvoted 4 times
...
mporislav
3 years ago
A, B, E Not always manual , not always automatic. to retain forever (E): exec DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS( retention=>0);
upvoted 4 times
...
Rogazan
3 years ago
ABD (DBMS_WORKLOAD_REPOSITORY.create_snapshot)
upvoted 1 times
Rogazan
3 years ago
sorry I was wrong. The correct answer is ABE
upvoted 1 times
...
...
RinD
3 years ago
ABE correct
upvoted 1 times
...
dunhill
3 years ago
I think ABC
upvoted 1 times
dunhill
3 years ago
I correct myself. It's ABE.
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