Computer Science - Database Systems - Discussion
Discussion Forum : Database Systems - Section 4 (Q.No. 12)
12.
In SQL, which of the following is not a data definition language commands?
Discussion:
6 comments Page 1 of 1.
Santosh Pratap said:
1 decade ago
Revoke and Grant command comes under DCL.
Update comes under DML. So answer should be 2, 3, 4.
How can any one say that answer would be 4 only? Can you explain this answer?
Update comes under DML. So answer should be 2, 3, 4.
How can any one say that answer would be 4 only? Can you explain this answer?
(1)
Harry said:
1 decade ago
Revoke and Grant comes under Data Control Language (DCL) not under Data Definition Language (DDL).
Shivakumara T said:
1 decade ago
DML - Data Manipulation language commands works on the data or values exists in tables. These are update, delete, insert.
DDL - Data Definition language commands works on the structure of the table such as rename columns, resize, adding or dropping new columns, add or dropping constraints on tables etc.
DDL - Data Definition language commands works on the structure of the table such as rename columns, resize, adding or dropping new columns, add or dropping constraints on tables etc.
Sudhir said:
1 decade ago
DDL commands are Create, alter, drop only.
Anoj said:
1 decade ago
Answer should be E, because non of them are DDL.
Sumanshu said:
9 years ago
IndiaBix, please update the answer. It should be Multiple Answer.
RENAME - DDL
REVOKE - DCL
GRANT - DCL
UPDATE - DML
RENAME - DDL
REVOKE - DCL
GRANT - DCL
UPDATE - DML
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers