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

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

Contribute your Thoughts:

Submit Cancel

Elli

1 months ago

This is a real 'joe-ker' of a question, but I think C and E are the winning combo. Revoke all privileges and set an invalid password with a password expiration. That'll make sure Joe can't access the MySQL instance anymore!

upvoted 0 times

Yuette

5 days ago

Yeah, revoking all privileges and setting an invalid password with expiration should definitely do the trick.

upvoted 0 times

...

Shayne

7 days ago

I think you're right, C and E seem like the best choices to stop Joe from accessing the MySQL instance.

upvoted 0 times

...

Glory

1 months ago

I'm feeling a bit 'joe-king' around here, but I'd say B and E are the way to go. Set an invalid password and make it expire - that'll show Joe who's the boss!

upvoted 0 times

Heike

5 days ago

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

upvoted 0 times

...

Nadine

1 months ago

This is a tricky one, but I reckon A and E are the best options. Lock the account and make the password invalid with a password expiration. Can't get much more secure than that!

upvoted 0 times

...

Floyd

1 months ago

I'm going with C and E. Revoking all privileges and setting an invalid password with a password expiration sounds like a good combo.

upvoted 0 times

Ranee

16 days ago

User3: Agreed, those two commands will definitely stop Joe from accessing the MySQL instance.

upvoted 0 times

...

Sena

1 months ago

User2: Yeah, revoking all privileges and setting an invalid password with expiration should do the trick.

upvoted 0 times

...

Sharmaine

1 months ago

User1: I think C and E are the way to go.

upvoted 0 times

...

Basilia

2 months ago

I'm not sure about option C. I think option E might also work by expiring the password.

upvoted 0 times

...

Mammie

2 months ago

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

upvoted 0 times

...

Margurite

2 months ago

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

upvoted 0 times

...

Layla

2 months 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

Grover

5 days ago

Good call, those two commands should do the trick in stopping Joe from establishing access.

upvoted 0 times

...

Gilma

6 days ago

Definitely, setting an invalid password and expiring it should block his access.

upvoted 0 times

...

Jerrod

7 days ago

I agree, B and E seem like the best options to prevent Joe from accessing the MySQL instance.

upvoted 0 times

...

Tamala

8 days ago

F) REVOKE USAGE ON *.* FROM 'joe'@'%'

upvoted 0 times

...

Jesusita

9 days ago

E) ALTER USER 'joe'@'%' IDENTIFIED BY '*invalid*' PASSWORD EXPIRE

upvoted 0 times

...

Laticia

10 days ago

D) ALTER USER 'joe'@'%' PASSWORD HISTORY 0

upvoted 0 times

...

Thea

11 days ago

C) REVOKE ALL PRIVILEGES ON *.* FROM 'joe'@'%'

upvoted 0 times

...

Page

12 days ago

B) ALTER USER 'joe'@'%' SET password='*invalid*'

upvoted 0 times

...

Novella

13 days ago

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

upvoted 0 times

...

Tamekia

14 days ago

B and E should definitely stop Joe from establishing access. Good choices!

upvoted 0 times

...

Lea

16 days ago

I agree, B and E seem like the best options to prevent Joe from accessing the MySQL instance.

upvoted 0 times

...

Vi

19 days ago

F) REVOKE USAGE ON *.* FROM 'joe'@'%'

upvoted 0 times

...

Diane

1 months ago

E) ALTER USER 'joe'@'%' IDENTIFIED BY '*invalid*' PASSWORD EXPIRE

upvoted 0 times

...

Precious

1 months ago

D) ALTER USER 'joe'@'%' PASSWORD HISTORY 0

upvoted 0 times

...

Rosendo

1 months ago

C) REVOKE ALL PRIVILEGES ON *.* FROM 'joe'@'%'

upvoted 0 times

...

Daron

2 months ago

B) ALTER USER 'joe'@'%' SET password='*invalid*'

upvoted 0 times

...

Sherrell

2 months ago

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

upvoted 0 times

...