In SQL, which of the following is not a data definition language commands?
A. RENAME
B. REVOKE
C. GRANT
D. UPDATE
Answer: Option D
Solution (By Examveda Team)
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.
This Question Belongs to SQL >> Sql Miscellaneous
revoke and grant is DCL (Data control language)
correct the question
R/Sir
Plz Check the answers.
Revoke & Grant are DCl Command.
Update DML
So the questions should be
Which is the DDL Command
Ans RENAME
Sir you are requested to correct the questions
The question is some what different comparing with options
your question framing is misleading, asking for which command is not the part of DDL? and all options are not from DDL, it makes my selection wrong.
only rename is ddl command, wrong question
Grant and Revoke are the database control language(or controler)
Therefore answer is Rename
Revoke and grant are DCL commands not DDL
Do you mean to say dcl commands also part of DDL? I think it is not..
Hello revoke and grant basically use in DCL
RENAME -DDL
GRANT,REVOKE-DCL
UPDATE-DML
the answer is wrong since GRANT and REVOKE are DCL command not DDL command. and UPDATE is DML command. so the answer has to be GRANT,REVOKE,UPDATE.
The solution is wrong.
Rename is DDL.
Revoke and Grant are DCL(Data Control Language) commands
Update is DML
Grant is also DCL .....
but revoke is the dcl command that is used to removes user access rights or privileges to the database objects.