What statement is used to change the data in a database?

Question $1$ options:

HAVING

SELECT

UPDATE

WHERE

Question $2(1$ point$)$

What clause is used to specify the column to change and the new value of the column?

Question $2$ options:

SET

HAVING

UPDATE

WHERE

Question $3(1$ point$)$

Which clause is used to specify the table to be changed in an UPDATE statement?

Question $3$ options:

WHERE

SET

HAVING

UPDATE

Question $4(1$ point$)$

What SQL feature enables you to undo a series of changes to the data?

Question $4$ options:

System Updates

UPDATE Undo

Transactions

UPDATE statements

Question $5(1$ point$)$

What keyword is used to permanently change the data in a transaction?

Question $5$ options:

ROLLBACK

COMMIT

START TRANSACTION

Question $6(1$ point$)$

What keyword is used to undo the changes that were made during a transaction?

Question $6$ options:

START TRANSACTION

ROLLBACK

COMMIT

Question $7(1$ point$)$

What statement is used to add new rows of data into a database?

Question $7$ options:

INSERT

UPDATE

SELECT

ALTER

Question $8(1$ point$)$

The version of the INSERT statement that adds one row of data into the target table uses what keyword?

Question $8$ options:

WHERE

HAVING

IN

VALUES

Question $9(1$ point$)$

What does the INSERT statement use to fetch data from one table to insert it into the target table?

Question $9$ options:

UPDATE statement

ALTER statement

SELECT statement

Question $10(1$ point$)$

In an INSERT statement, what follows the INSERT INTO keywords?

Question $10$ options:

Value expression

VALUES keyword

Table name

Column list