It will fail because there is no column list in the INSERT statement.
It will fail because there is no PRIMARY KEY in the table.
It will execute and create a new row in the table.
It will fail because the last name and first name values are reversed.
Questão 7
Questão
Which of the following reserved words is not required in order to form a syntactically correct UPDATE statement?
Responda
UPDATE
SET
WHERE
None of these
Questão 8
Questão
Assume a table LAMPS that has no constraints. Which of the following is true about the UPDATE statement and the LAMPS table? (Choose all that apply.)This
Responda
UPDATE can be used to add rows to LAMPS by setting values to all the columns.
UPDATE can be used to remove a row from LAMPS by setting all of the row’s columns to a value of NULL.
For existing rows in LAMPS, UPDATE can add values to any column with a NULL value.
For existing rows in LAMPS, UPDATE can remove values from any column by changing its value to NULL.
The UPDATE will fail because there is no WHERE clause.
None of these.
Questão 11
Questão
Which of the following reserved words is/are optional in a complete DELETE statement? (Choose all that apply)
Responda
FROM
WHERE
DELETE
REMOVE
Questão 12
Questão
Which of the following SQL statements will remove the word VALID from row 1, resulting in one row with a status of NULL and two rows with a status of PENDING?