Interested to Buy Any Domain ? << Click Here >> for more details...
Define the term DML, DDL and DTL?
- 1 Answers
- 31778 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 make a column nullable?
What is nested transaction?
How to connect a database with sql express.?
What is difference between primary key and foreign key?
Can a rule be bound to any column of any data type?
How to create an identity column?
What is cursors? And what are the different types of cursor?
What are the differences between char and varchar in ms sql server?
How to delete existing rows in a table?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
How to set database to be single_user in ms sql server?
How do I view a procedure in sql server?
-
Oracle (3259) - 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)
