Examveda
Examveda

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

Join The Discussion

Comments ( 12 )

  1. THARUN .K
    THARUN .K :
    1 year ago

    The question is some what different comparing with options

  2. Yogesh Surjha
    Yogesh Surjha :
    1 year 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.

  3. Pankaj Jagdale
    Pankaj Jagdale :
    1 year ago

    only rename is ddl command, wrong question

  4. Shubham Amrutkar
    Shubham Amrutkar :
    1 year ago

    Grant and Revoke are the database control language(or controler)
    Therefore answer is Rename

  5. ANKITA JHA
    ANKITA JHA :
    3 years ago

    Revoke and grant are DCL commands not DDL

  6. Veera Reddy
    Veera Reddy :
    6 years ago

    Do you mean to say dcl commands also part of DDL? I think it is not..

  7. Ankur Singh
    Ankur Singh :
    6 years ago

    Hello revoke and grant basically use in DCL

  8. Amar Raj
    Amar Raj :
    6 years ago

    RENAME -DDL
    GRANT,REVOKE-DCL
    UPDATE-DML

  9. Manisha Mishra
    Manisha Mishra :
    6 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.

  10. Prashant Mudaliar
    Prashant Mudaliar :
    7 years ago

    The solution is wrong.

    Rename is DDL.
    Revoke and Grant are DCL(Data Control Language) commands
    Update is DML

  11. Subhankar Patra
    Subhankar Patra :
    7 years ago

    Grant is also DCL .....

  12. Prince Yadav
    Prince Yadav :
    8 years ago

    but revoke is the dcl command that is used to removes user access rights or privileges to the database objects.

Related Questions on Sql Miscellaneous