One of the most important question asked in interview, you might know with in 2 minute session only.
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
DDL is used to create, modify and delete the structure of database objects.
Examples: CREATE, ALTER, DROP, TRUNCATE statements.
DML is used to retrieve, store, modify, delete, insert and update data in database.
Examples: SELECT, UPDATE, DELETE and INSERT statements.
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.
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.
If you have any query or question or topic on which, we might have to write an article for your interest or any kind of suggestion regarding this post, Just feel free to write us, by hit add comment button below or contact via Contact Us form.
Your feedback and suggestions will be highly appreciated. Also try to leave comments from your valid verified email account, so that we can respond you quickly.