Oracle Exam 1Z0-083 Topic 2 Question 80 Discussion

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

Question #: 80
Topic #: 2

[All 1Z0-083 Questions]

Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)

AAll metrics are instance related.

BCleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.

CA space usage management alert is automatically cleared after the underlying problem is resolved

DThey are generated by SMON when a tablespace is 97% full.

EMetrics are statistical counts for a specific unit.

FSTATISTICS_LEVEL must be set to ALL to generate alerts.

Show Suggested Answer

Suggested Answer: B, C, D

by Merlyn at Oct 05, 2023, 01:49 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Alverta

29 days ago

I wonder if the developers were feeling a little mischievous when they came up with these answer choices. Some of these options seem a bit too good to be true.

upvoted 0 times

...

Alline

30 days ago

Woah, if SMON is generating these alerts, I bet the DBA is just sitting back and relaxing. Talk about an easy job!

upvoted 0 times

Eleni

7 days ago

A) All metrics are instance related.

upvoted 0 times

...

Ahmed

1 months ago

STATISTICS_LEVEL set to ALL to generate alerts? That sounds like a lot of work. I hope option F isn't the only way to do it.

upvoted 0 times

...

Mona

1 months ago

Metrics as statistical counts? That makes sense, but I wonder if option E is the whole story.

upvoted 0 times

Alpha

5 days ago

Yes, that's correct. They provide data on performance and usage.

upvoted 0 times

...

Twila

7 days ago

I think metrics are indeed statistical counts for a specific unit.

upvoted 0 times

...

Rickie

1 months ago

SMON generating alerts when a tablespace is 97% full? That's news to me. I'm skeptical about option D.

upvoted 0 times

Justa

6 days ago

I think option C makes sense, as space usage management alerts are usually cleared once the underlying issue is resolved.

upvoted 0 times

...

Gary

23 days ago

I agree, I also find option D about SMON generating alerts when a tablespace is 97% full to be questionable.

upvoted 0 times

...

Antonio

2 months ago

Wait, so a space usage management alert just magically clears itself? That's too good to be true. I bet option C is wrong.

upvoted 0 times

Rory

13 days ago

E) Metrics are statistical counts for a specific unit.

upvoted 0 times

...

Cordelia

20 days ago

B) Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.

upvoted 0 times

...

Lauran

1 months ago

A) All metrics are instance related.

upvoted 0 times

...

Diego

2 months ago

Cleared stateful alerts in the DBA_ALERT_HISTORY? That sounds like a useful feature, but I'm not sure if option B is correct.

upvoted 0 times

Sharan

9 days ago

That's correct, it helps in keeping the system running smoothly.

upvoted 0 times

...

Felix

13 days ago

I believe option C is also true, space usage management alerts are automatically cleared once the issue is resolved.

upvoted 0 times

...

Sherita

1 months ago

Yes, that's right. It's a helpful feature to track cleared alerts.

upvoted 0 times

...

Elza

1 months ago

I think option B is correct, cleared stateful alerts are indeed displayed in DBA_ALERT_HISTORY.

upvoted 0 times

...

Cordie

2 months ago

Hmm, I'm pretty sure that not all metrics are instance related. Isn't that what option A is saying? I better double-check that one.

upvoted 0 times

Lashandra

1 months ago

User 2: Yeah, I agree. We should double-check that option.

upvoted 0 times

...

Jolene

2 months ago

User 1: I think you're right, not all metrics are instance related.

upvoted 0 times

...

Kanisha

2 months ago

I'm not sure about D and F. I think they might be false.

upvoted 0 times

...

Jarod

3 months ago

I agree with Justa. Metrics are definitely statistical counts.

upvoted 0 times

...

Justa

3 months ago

I think A, C, and E are true.

upvoted 0 times

...