ExamVeda
Login
Home
This question belongs to SQL Sql Miscellaneous
Sql Miscellaneous
?

In SQL, which of the following is not a data definition language commands?

Answer & Solution
Correct Answer: Option D

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.

Examveda
Question posted by Examveda
Community

Join the Discussion

15 Comments
Kartik Thakur
Kartik Thakur 9 months ago
GRANT AND REVOKE ARE DCL COMMANDS
Jeelan Fakruddin
Jeelan Fakruddin 1 year ago
revoke and grant is DCL (Data control language)

correct the question
Bhawna Wadhwa
Bhawna Wadhwa 2 years ago
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
THARUN .K
THARUN .K 4 years ago
The question is some what different comparing with options
Yogesh Surjha
Yogesh Surjha 4 years ago
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.
Pankaj Jagdale
Pankaj Jagdale 4 years ago
only rename is ddl command, wrong question
Shubham Amrutkar
Shubham Amrutkar 4 years ago
Grant and Revoke are the database control language(or controler)
Therefore answer is Rename
ANKITA JHA
ANKITA JHA 5 years ago
Revoke and grant are DCL commands not DDL
Veera Reddy
Veera Reddy 8 years ago
Do you mean to say dcl commands also part of DDL? I think it is not..
Ankur Singh
Ankur Singh 9 years ago
Hello revoke and grant basically use in DCL
Amar Raj
Amar Raj 9 years ago
RENAME -DDL
GRANT,REVOKE-DCL
UPDATE-DML
Manisha Mishra
Manisha Mishra 9 years ago
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.
Prashant Mudaliar
Prashant Mudaliar 10 years ago
The solution is wrong.

Rename is DDL.
Revoke and Grant are DCL(Data Control Language) commands
Update is DML
Subhankar Patra
Subhankar Patra 10 years ago
Grant is also DCL .....
Prince Yadav
Prince Yadav 10 years ago
but revoke is the dcl command that is used to removes user access rights or privileges to the database objects.