Qtr No. 213, New Town Yehlanka Indore 454775
In a MySQL Server, you are required to provide UPDATE privilege on Status and Result columns of Process table in Testing database to user Tester. Which of the following SQL query is executed to accomplish this task?
mysql> GRANT UPDATE ON Testing.Process TO 'Tester'@'localhost';
mysql> GRANT UPDATE ON Process.Status TO 'Tester'@'localhost'; mysql> GRANT UPDATE ON Process.Result TO 'Tester'@'localhost'
mysql> GRANT UPDATE (Status, Result) ON Testing.Process TO 'Tester'@'localhost';
none of the above
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
