Multiple choice

What is the SQL statement to grant select, update privileges to the user RAKESH for the DEPT relation?

  1. GRANT DML on DEPT to USER1;

  2. GRANT select, update to USER1 on DEPT;

  3. GRANT select, update on DEPT to USER1;

  4. GRANT on DEPT to USER1 for select, update;
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The SQL statement to grant select, update privileges to the user RAKESH for the DEPT relation is GRANT select, update on DEPT to USER1;

Keep practicing — related questions