Why DML operations modify data in MySQL - Quick Recap

Recall & Review

beginner

What does DML stand for in databases?

DML stands for Data Manipulation Language. It includes commands that change data in the database like INSERT, UPDATE, DELETE.

beginner

Which DML commands modify data in a database?

INSERT adds new data, UPDATE changes existing data, and DELETE removes data from tables.

beginner

Why do DML operations modify data?

Because their purpose is to change the contents of database tables by adding, changing, or removing rows.

intermediate

What happens if you run an UPDATE command without a WHERE clause?

All rows in the table will be updated, which means all data in that column(s) will change.

beginner

How does a DELETE command affect the database?

It removes rows from a table, permanently deleting the data unless a transaction rollback is done.

Which DML command is used to add new data to a table?

A SELECT

B UPDATE

C INSERT

D DELETE

INSERT adds new rows to a table, modifying the data.

What does the UPDATE command do?

A Changes existing data

B Adds new rows

C Deletes rows

D Reads data

UPDATE changes the values of existing rows in a table.

Which DML command removes data from a table?

A UPDATE

B DELETE

C INSERT

D CREATE

DELETE removes rows from a table, modifying the data.

Why do DML operations modify data?

A To change the structure of tables

B To read data only

C To create new tables

D To change the data inside tables

DML commands are designed to change the data stored in tables.

What happens if you run DELETE without a WHERE clause?

A Deletes all rows

B Deletes no rows

C Deletes only one row

D Returns an error

Without WHERE, DELETE removes all rows from the table.

Explain why DML operations like INSERT, UPDATE, and DELETE modify data in a database.

Think about what each command does to the table's contents.

Describe what could happen if you run an UPDATE or DELETE command without a WHERE clause.

Consider the scope of the command without filters.