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.
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.
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)
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
Harry said:
1 decade ago
Revoke and Grant comes under Data Control Language (DCL) not under Data Definition Language (DDL).
Anoj said:
1 decade ago
Answer should be E, because non of them are DDL.
Sudhir said:
1 decade ago
DDL commands are Create, alter, drop only.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers