Oracle Exam 1Z0-909 Topic 6 Question 15 Discussion

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

Question #: 15
Topic #: 6

[All 1Z0-909 Questions]

Examine this event's metadata:

Now examine this command:

DROP USER 'userl'e'localhost';

Which effect will the command have on the event?

AThe event is scheduled and executed but fails. The system will log an error.

BThe event is scheduled but will no longer execute. The system will log an error.

CThe event will be dropped without an error or warning.

DThe event is not scheduled and will no longer execute. The system will log an error.

Show Suggested Answer

Suggested Answer: A, B

by Alecia at Feb 05, 2023, 08:13 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Sue

2 months ago

Wait, wait, wait... you mean I can't just drop the user and expect the event to vanish into thin air? Option B it is, my friends. Looks like the database gods have a sense of humor today.

upvoted 0 times

Harley

2 days ago

C) The event will be dropped without an error or warning.

upvoted 0 times

...

Nettie

3 days ago

B) The event is scheduled but will no longer execute. The system will log an error.

upvoted 0 times

...

Alex

6 days ago

A) The event is scheduled and executed but fails. The system will log an error.

upvoted 0 times

...

Odette

2 months ago

Ah, the classic 'drop the user and see what happens' approach. I'm going to have to go with option B on this one. Gotta love it when the database gets a little bit of an attitude adjustment.

upvoted 0 times

...

Marcos

2 months ago

Option C seems a bit too convenient, don't you think? I doubt the system would just drop the event without any notification. I'm leaning towards option B.

upvoted 0 times

Ruby

1 months ago

Yeah, I wouldn't want the event to just disappear without any warning. Option B seems like the safer choice.

upvoted 0 times

...

Fredric

1 months ago

I think option B makes more sense. It's better to be safe than sorry.

upvoted 0 times

...

Rolande

1 months ago

I agree, option C does seem a bit too convenient. It's always better to be cautious.

upvoted 0 times

...

Shaunna

2 months ago

Well, this is an interesting scenario. I'm gonna go with option D. If the user is dropped, the event won't be scheduled in the first place, so it won't execute.

upvoted 0 times

...

Gilberto

2 months ago

Hmm, this is a tricky one. I think option B is the correct answer. Dropping the user will prevent the event from executing, but the system should log an error.

upvoted 0 times