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

Currently there are no comments in this discussion, be the first to comment!