In a MySQL Server you are required grant SELECT, INSERT & DELETE as a database privilege to user Tester on Engineering database. Which of the following SQL queries is to be executed to accomplish this task?

GRANT SELECT, INSERT, DELETE ON *.* TO Tester@localhost;

GRANT SELECT, INSERT, DELETE TO Tester@localhost;

GRANT SELECT, INSERT, DELETE ON Engineering.* TO Tester@localhost;

GRANT SELECT, INSERT, DELETE ON Engineering TO Tester@localhost;

Verified Answer
Correct Option - c

To get all Infosys Certified MySQL Administrator Exam questions Join Group https://bit.ly/infy_premium_group

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