wt r d DDL statements n their types,DML statements n their types, meanings f ROLLBACK n COMMIT frm unix

Question

Accepted Answer

DDL statements are used to define or modify the structure of a database. DML statements are used to manipulate data within a database.

DDL (Data Definition Language) statements are used to create, alter, or drop database objects like tables, views, indexes, etc.
Examples of DDL statements include CREATE TABLE, ALTER TABLE, DROP TABLE, CREATE INDEX, etc.
DML (Data Manipulation Language) statements are used to manipulate data within database objects.
Examples of DML statements include SELECT, INSERT, UPDATE, DELETE, etc.
ROLLBACK is a command used to undo or cancel the changes made in a transaction.
COMMIT is a command used to save the changes made in a transaction and make them permanent.

Top TCS interview questions & answers