Question 20Asked in DSSSB TGT Computer Science (Technical), 12 Sep 2025, Shift 3 (5:00 PM)

In order to grant a user named 'Deepak' the ability to read data from a table called

In order to grant a user named 'Deepak' the ability to read data from a table called 'Customers', which SQL statement should be used?

AGRANT SELECT ON Customers TO Deepak;
BGRANT READ ON Customers TO Deepak;
CGRANT ACCESS ON Customers TO Deepak;
DGIVE SELECT ON Customers TO Deepak;

Show answerHide answer

Correct answer: (A) GRANT SELECT ON Customers TO Deepak;

Explanation

SELECT is the privilege that allows reading rows from a table, so GRANT SELECT ON Customers TO Deepak; is correct. READ and ACCESS are not SQL privileges, and GIVE is not an SQL command.

In order to grant a user named 'Deepak' the ability to read data from a table called

From DSSSB TGT Computer Science PYQ (Technical), 12 Sep 2025, Shift 3 (5:00 PM)