Oracle Exam 1Z0-908 Topic 11 Question 101 Discussion

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

Question #: 101
Topic #: 11

[All 1Z0-908 Questions]

Examine Joe's account:

CREATE USER 'joe'@'%' IDENTIFIED BY '*secret*'

GRANT ALL PRIVILEGES ON *.* TO 'joe'@'%'

All existing connections for joe are killed.

Which two commands will stop joe establishing access to the MySQL instance? (Choose two.)

AALTER USER 'joe'@'%' ACCOUNT LOCK

BALTER USER 'joe'@'%' SET password='*invalid*'

CREVOKE ALL PRIVILEGES ON *.* FROM 'joe'@'%'

DALTER USER 'joe'@'%' PASSWORD HISTORY 0

EALTER USER 'joe'@'%' IDENTIFIED BY '*invalid*' PASSWORD EXPIRE

FREVOKE USAGE ON *.* FROM 'joe'@'%'

Show Suggested Answer

Suggested Answer: C, E

by Laticia at Apr 03, 2025, 11:16 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

2 days ago

I agree with Margurite. Revoking privileges and locking the account should prevent access.

upvoted 0 times

...

14 days ago

I think options A and C will stop joe from accessing the MySQL instance.

upvoted 0 times

...

18 days ago

Hmm, I think B and E are the way to go here. Setting an invalid password and expiring it should do the trick.

upvoted 0 times

4 days ago

A) ALTER USER 'joe'@'%' ACCOUNT LOCK

upvoted 0 times

...