Question $11(1$ point$)$

When the INSERT statement is fetching rows of data to be placed into a table, the SELECT expression is used in place of what?

Question $11$ options:

The column name list

The value expression

The table name

The VALUES clause

Question $12(1$ point$)$

Which statement is used to remove data from the database?

Question $12$ options:

SELECT

INSERT

UPDATE

DELETE

Question $13(1$ point$)$

If which clause is missing in a DELETE statement it will delete all rows in the table?

Question $13$ options:

DELETE

HAVING

FROM

WHERE

Question $14(1$ point$)$

Which clause is used to limit the rows deleted in the DELETE statement?

Question $14$ options:

WHERE

FROM

DELETE

Question $15(1$ point$)$

What restriction is there when using a view in the DELETE statement?

Question $15$ options:

The view is dynamic

The view is updatable

The view is deletable

The view is insertable

Question $16(1$ point$)$

The SQL standard provided which syntax to test data in one column to determine how to handle data in another column?

Question $16$ options:

UPDATE

CORRESPONDING

SET

CASE

Question $17(1$ point$)$

In a CASE statement that uses a simple when clause, what follows CASE?

Question $17$ options:

WHEN

Value expression

ELSE

Search condition

Question $18(1$ point$)$

In a CASE statement that uses a searched when clause, what follows CASE?

Question $18$ options:

WHEN

Value expression

Search condition

ELSE