Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 46 of 79

Table Creation and Data Manipulation Commands — Question 1

Back to all questions
1
Question

Question 1

What are different divisions of SQL and commands ? Give examples of commands in each division.

Answer

SQL commands can be divided into following categories :

  1. Data Definition Language (DDL) commands — CREATE, ALTER, DROP, TRUNCATE etc.
  2. Data Manipulation Language (DML) commands — INSERT, UPDATE, DELETE etc.
  3. Transaction Control Language (TCL) commands — COMMIT, ROLLBACK, SAVEPOINT etc.
  4. Session Control Commands
  5. System Control Commands