Explain the commands in SQL Server?

devquora
devquora

Posted On: Feb 22, 2018

 

DML (Data Manipulation Language)
  • Select
  • Insert
  • Update
  • Delete

DDL (Data Definition Language)

  • Create
  • Alter
  • Drop
  • Truncate

DCL (Data Control Language)

  • Grant
  • Revoke

TCL (Transactional Control Language)

  • Commit
  • RollBack
  • Save Transaction

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Mssql Interview Questions

    What is MSSQL?

    MSSQL stands for Microsoft Server SQL that is a Microsoft’s relational database management system. It is a featured d..

    Mssql Interview Questions

    What is SQL server agent and what are the two modes of authentication in SQL Server?

    SQL Server agent The SQL Server agent plays an important part in the day to day tasks of the SQL Server Database Admini..

    Mssql Interview Questions

    What is SQL Profiler?

    It is a tool that allows system’s administrator to monitor the events in SQL Server.It is mainly used to capture and ..