Computer Science
What are different divisions of SQL and commands ? Give examples of commands in each division.
DDL & DML
11 Likes
Answer
SQL commands can be divided into following categories :
- Data Definition Language (DDL) commands — CREATE, ALTER, DROP, TRUNCATE etc.
- Data Manipulation Language (DML) commands — INSERT, UPDATE, DELETE etc.
- Transaction Control Language (TCL) commands — COMMIT, ROLLBACK, SAVEPOINT etc.
- Session Control Commands
- System Control Commands
Answered By
8 Likes
Related Questions
Assertion. Both DELETE and DROP TABLE carry out the same thing — deletion in tables.
Reason. The DELETE command deletes the rows and DROP TABLE deletes the whole table.
Assertion. Both UPDATE and ALTER TABLE commands are similar.
Reason. The UPDATE command as well ALTER TABLE command make changes in the table.
What is foreign key ? How do you define a foreign key in your table ?
How is FOREIGN KEY commands different from PRIMARY KEY command ?