2 Minutes for types of commands in SQL Server

TSQL, DDL, DML, DCL and TCL in SQL Server

One of the most important question asked in interview, you might know with in 2 minute session only.

Transact-Structured Query Language (T-SQL)

T-SQL is abbreviation of Transact-Structured Query Language (SQL). It is a set of programming extension of SQL- Language by Microsoft, that add several features to the SQL, including transaction control, exception and error handling

Data definition language (DDL)

DDL is used to create, modify and delete the structure of database objects.
Examples: CREATE, ALTER, DROP, TRUNCATE statements.

Data Manipulation Language (DML)

DML is used to retrieve, store, modify, delete, insert and update data in database.
Examples: SELECT, UPDATE, DELETE and INSERT statements.

Data control language (DCL)

DCL is used to control access to database objects (that is Stored Procedures, Functions, Tables, Views etc).
Examples: GRANT, REVOKE statements.
GRANT – allows users to read/write on certain database objects.
REVOKE – keeps users from read/write permission on database objects.

Transactional Control Language (TCL)

TCL It is used to manage different transactions occurring within a database.In other words, to execute dependent queries without any miss-match when certain error occur during execution of SQL Statements or Queries.
Examples: COMMIT, ROLLBACKstatements.
COMMIT – Save all changes made in database with in transaction scope.
REVOKE – Revert(Undo) all changes made in database in case of any error with in scope of transaction.

Moreover, I will suggest, you must little bit aware with commands used by DBA by click on link bellow. Which will add one more answer to you interview question.

What is DBCC commands in SQL server?

For more your queries and questions don't forget to post your comments below by click on Add Comment button.