Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Define the term DML, DDL and DTL?

Question Posted / saranya.t


Define the term DML, DDL and DTL?..

Answer / mohammad ali

DML

DML is abbreviation of Data Manipulation Language. It is
used to retrieve, store, modify, delete, insert and update
data in database.

Examples: SELECT, UPDATE, INSERT statements

DDL

DDL is abbreviation of Data Definition Language. It is used
to create and modify the structure of database objects in
database.

Examples: CREATE, ALTER, DROP statements

DCL

DCL is abbreviation of Data Control Language. It is used to
create roles, permissions, and referential integrity as well
it is used to control access to database by securing it.

Examples: GRANT, REVOKE statements

TCL

TCL is abbreviation of Transactional Control Language. It is
used to manage different transactions occurring within a
database.

Examples: COMMIT, ROLLBACK statements

Is This Answer Correct ?    30 Yes 6 No

Post New Answer

More SQL Server Interview Questions

What is the purpose of using COLLATE in a query?

1 Answers  

What is b tree index?

0 Answers  

What happens if we shrink log file in sql server?

0 Answers  

What are views in ms sql server?

0 Answers  

What are the differences between stored procedure and functions in SQL Server 2000?

25 Answers   College School Exams Tests, HCL, Infosys, TCS,

What is dirty page?

0 Answers  

What is difference between view and materialized view?

0 Answers  

1 01 101 01010

0 Answers  

Explain the various types of concurrency problem?

0 Answers  

Some queries related to SQL

0 Answers   Motorola,

Can we drop user if user mapped to any logins

1 Answers  

What is 2nf example?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories