SQL SERVER

SQL SERVER Interview Q&A

    SQL SERVER


INTRODUCTION
1 .SQL is divided into the following

  •   Data Definition Language (DDL)
  •   Data Manipulation Language (DML)
  •   Data Retrieval Language (DRL)
  •   Transaction Control Language (TCL)
  •   Data Control Language (DCL)

DDL -- create, alter, drop, truncate, rename
DML -- insert, update, delete 
DRL -- select
TCL -- commit, rollback, savepoint
DCL --  grant, revoke




No comments:

Post a Comment