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
what are the different stages of Report Processing?
How to write character string constants or literals in ms sql server?
plss anybody specify tha constrian management system in dbms
What is bcp? When does it use?
What you can do to delete a table without the delete trigger firing?
Can you use order by when defining a view?
How can delete duplicate records in cte in sql server?
How you provide security to cube? : sql server analysis services, ssas
What is shared lock?
What do you mean by SQL injection attack?
What is the difference between Stored Procedures and triggers?
What is the usage of sign function?
Where are stored procedures in sql server?
How would you use user_constraints table in DB?
What do you need to connect php to sql server?
