explain DDL and DML commands in SQL.

Question

Accepted Answer

DDL and DML are SQL commands used to manipulate databases. DDL is used to create, modify, and delete database objects, while DML is used to manipulate data within those objects.

DDL stands for Data Definition Language and includes commands like CREATE, ALTER, and DROP.
DDL commands are used to create, modify, and delete database objects like tables, indexes, and views.
DML stands for Data Manipulation Language and includes commands like SELECT, INSERT, UPDATE, and DELETE.
DML commands are used to manipulate data within those objects, like adding or updating records in a table.
DDL commands are used less frequently than DML commands, as they are typically used during initial database setup or when making major changes to the database structure.

explain DDL and DML commands in SQL.

Top Legasis Services Operation Support Executive interview questions & answers

Popular interview questions of Operation Support Executive

Top HR questions asked in Legasis Services Operation Support Executive