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
Explain trigger and its types?
When does a workload on SQL Azure get throttled?
Tell me what is fill factor?
How can I check if a view exists in a sql server database?
Can we use where clause in union?
What are .mdf files?
Does the order of columns in update statements matter?
What is the difference between substr and charindex in the sql server?
How to delete existing rows in a table?
How many triggers you can have on a table?
Why use stored procedures in sql server?
what stored procedure can you use to display the current processes? : Sql server administration
Where sql server usernames and passwords are stored in a sql server?
What is a system database and what is a user database?
What is change tracking in sql server?
