Interested to Buy Any Domain ? << Click Here >> for more details...
Define the term DML, DDL and DTL?
- 1 Answers
- 31866 Views
- I also Faced
- E-Mail Answers
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 |
How to receive output values from stored procedures?
How can windows applications connect to sql servers via odbc?
How to write an inner join with the where clause in ms sql server?
What are the different ways of moving data/databases between servers and databases in SQL Server?
How to find the login name linked to a given user name?
What is a DBMS, query, SQL?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
What is a print index?
what is a correlated sub-query? : Sql server database administration
How do I start sql server?
How does a profiler work?
What is transaction server isolation?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
