What is a DDL, DML and DCL concept in RDBMS world?

 Posted by ArticlesMaint on 10/3/2009 | Category: Sql Server Interview questions | Views: 20235

DDL (Data definition language) defines your database structure. CREATE and ALTER are DDL statements as they affect the way your database structure is organized.
DML (Data Manipulation Language) lets you do basic functionalities like INSERT, UPDATE, DELETE and MODIFY data in database.
DCL (Data Control Language) controls you DML and DDL statements so that your data is protected and has consistency. COMITT and ROLLBACK are DCL control statements. DCL guarantees ACID fundamentals of a transaction.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response