In SQL, which of the following is not a data definition language commands?
A. REVOKE
B. RENAME
C. UPDATE
D. GRANT
Answer: Option C
Solution(By Examveda Team)
In SQL, the Data Definition Language (DDL) is used to define, manage, and modify the structure of a database. DDL commands are primarily responsible for creating, altering, or deleting tables, schemas, and other database objects. Among the options provided:Option C: UPDATE is not a data definition language command. UPDATE is a Data Manipulation Language (DML) command used to modify data within existing tables, not to define or manage the structure of the database.
The other options, REVOKE, RENAME, and GRANT, are DDL commands used for managing user privileges, renaming database objects, and controlling access, respectively.
So, the correct answer is Option C: UPDATE.
Join The Discussion
Comments ( 1 )
Related Questions on Sql Miscellaneous
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 it self is wrong, none of them belongs to DDL.