In a MYSQL Server to revoke all privileges assigned to user Tester, which of the following SQL queries is executed?

REVOKE ALL FROM Tester@localhost;

REVOKE ALL, GRANT OPTION FROM Tester@localhost;

REVOKE ALL PRIVILEGES FROM Tester@localhost;

REVOKE * FROM Tester@localhost;

Verified Answer
Correct Option - b

To get all Infosys Certified MySQL Administrator Exam questions Join Telegram Group https://rebrand.ly/lex-group-70b557

Telegram

We're passionate about offering best placement materials and courses!! A one stop place for Placement Materials. We daily post Offcampus updates and Placement Materials.

Qtr No. 213, New Town Yehlanka Indore 454775

admin@prepflix.in

Updated on Fri, 22 Aug 2025