Q6
In SQL, which of the following is not a data definition language commands?
A.
RENAME
B.
REVOKE
C.
GRANT
D.
UPDATE
AnswerAnswer: Option D
Solution
Answer: Option D
Solution:
RENAME: - With RENAME statement you can rename a table.
REVOKE: - The REVOKE command removes user access rights or privileges to the database objects.
GRANT: - In SQL GRANT is a command used to provide access or privileges on the database objects to the users.
UPDATE: - The UPDATE Statement is used to modify the existing rows in a table.
RENAME, REVOKE and GRANT are DDL(Data Definition Language) commands and UPDATE is DML(Data Manipulation Language) command.