Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 View All Answers
Why people hate cursor?
What is a with(nolock)?
What is data compression? : sql server database administration
How to copy data from one table to another table?
How to create a testing table with test data in ms sql server?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
Can You Use Data Mining Models In Ssrs?
What does the not null constraint do?
Explain the different types of joins?
Can primary key be null?
What are Spatial data types in SQL Server 2008
What do mean by xml datatype?
 Explain what is sql override for a source taLle in a mapping?
What happens when unicode strings concatenate with non-unicode strings?
What is a trigger and its types?
