PowerPoint 3

Question 1

What is Data Manipulation Language(DML)?

Answer 1

DML is a subset of operations used to INSERT, DELETE and UPDATE data in a database.

Question 2

What does CRUD stand for?

Answer 2

create, read, update and delete.

Question 3

What is the function of the INSERT command?

Answer 3

The INSERT command is used to insert date into a table.

Question 4

What will this do?

INSERT INTO <table_name> (column_name(s))
values (column_value(s)),
(column_values(s));</table_name>

Answer 4

the INSERT statement inserts one or more rows of data into a table (<table_name>) by specifying the column names (column_name(s)) and their corresponding values (column_value(s)).</table_name>

Question 5

What is the function of the UPDATE command?

Answer 5

The UPDATE statement is used to update existing data within a table

Question 6

What will this do?

UPDATE <table_name>
SET <column_number> = <value_number>
WHERE condition;​</value_number></column_number></table_name>

Answer 6

The UPDATE statement updates a specific column (<column_number>) in a table (<table_name>) with a new value (<value_number>), based on the specified condition.</value_number></table_name></column_number>

Question 7

What is the function of the DELETE command?

Answer 7

The DELETE command is used to delete records from a database table

Question 8

What will this do?

Delete from <table_name>
WHERE condition;​</table_name>

Answer 8

the DELETE statement deletes one or more rows from a table (<table_name>) based on the specified condition (WHERE condition).</table_name>

Note:
The WHERE statement can take multiple conditions.