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.
Join The Discussion
Comments ( 12 )
A. Structured Query Language
B. Structured Query List
C. Simple Query Language
D. None of these
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
A. Data Definition Language(DDL)
B. Data Manipulation Language(DML)
C. Both of above
D. None
Which operator performs pattern matching?
A. BETWEEN operator
B. LIKE operator
C. EXISTS operator
D. None of these
What operator tests column for the absence of data?
A. EXISTS operator
B. NOT operator
C. IS NULL operator
D. None of these
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.