Exam 6: Updating Data

Which of the following is a valid SQL command?

You can use REMOVE ROW to remove a row from a table.

To add a new column, use the ____________________ clause of the ALTER TABLE command.

You cannot use a compound condition to update a row.

You can cancel updates at any time during your current work session.

By placing a(n)____________________ command in an INSERT command, you can add the query results to a table.

In a transaction, it is acceptable if some steps fail.

You cannot change the characteristics of existing columns.

The data stored in tables is subject to constant change.

To sort rows in a specific order, use the ____________________ clause with the desired sort key(s).

The UPDATE command contains the word ____________________, followed by the name of the column to be updated, an equals sign, and the new value.

When you use the CREATE TABLE command with the word LIKE to create a new table from an existing table, the new table has the same data as the original table.

If you specify NOT NULL for a column when you create a table, you are prohibited from changing a value in the column to null.

When you update the data in a table, your updates are always permanent.

To permanently remove both a table and its data, you must issue both a DROP TABLE command and a DELETE command.