Explain the basic Database Commands (DDL, DML, and DCL).

Question

Accepted Answer

DDL, DML, and DCL are SQL commands used to manipulate databases.

DDL (Data Definition Language) commands are used to create, modify, and delete database objects such as tables, indexes, and views.
DML (Data Manipulation Language) commands are used to insert, update, and delete data in a database.
DCL (Data Control Language) commands are used to control access to the database, such as granting or revoking permissions.
Examples of DDL commands include CREATE TABLE, ALTER TABLE, and DROP TABLE.
Examples of DML commands include INSERT, UPDATE, and DELETE.
Examples of DCL commands include GRANT and REVOKE.

Accepted Answer

Data defination Language (DDL) is a subset of SQL Data manipulation language Data Control Language in Structured Query Language (SQL).

Accepted Answer

DDL stands for data defination language.DML stands for Data manipulation language .DCL stands for data control language.

Interview Questions from Popular Companies