Interested to Buy Any Domain ? << Click Here >> for more details...
Define the term DML, DDL and DTL?
- 1 Answers
- 31868 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 |
what is index seek and index scan?
Do you know what are the properties of the relational tables?
How to get number of days in a given year?
How do you Implement SSIS Packages in your Project?
what's the maximum size of a row? : Sql server database administration
What is a print index?
What are page splits? : SQL Server Architecture
what is unique and xaml nonclustered index
What is merge replication?
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
How do you test your database? : sql server database administration
What is the cpu pressure?
-
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)
