Exam 6: Updating Data

If you specified ____ for a column when you created a table, then changing a value in a column to null is prohibited.

MySQL does not allow you to change the size of DECIMAL columns.

You use the ____________________ command to remove rows from a table.

A(n)____________________ is a logical unit of work.

If you decrease the size of a column, it is possible to lose some data currently in the column.

You can use the ROLLBACK command to return the column length to its original state.

A(n)____ can be viewed as a sequence of steps that accomplishes a single task.

You can use the ____ command to delete an entire table and its data.

You can use the ____ clause of the ALTER TABLE command to change a column that currently rejects null values so that it will accept null values.

The DROP TABLE command creates an empty table.

You can use the ____ command to create a new table using data in an existing table.

To verify that the correct change was made to data in a table, use the DISPLAY command.

Updates become permanent automatically when you exit from MySQL.

The command, CREATE TABLE AS LEVEL1_CUSTOMER FROM CUSTOMER; creates a table called LEVEL1_CUSTOMER that has the same structure as CUSTOMER.

The ROLLBACK command reverses changes made to a table's structure.

If you have verified that the update you made is correct, you can use the ____ command to make the update permanent.

If you specified ____________________ for the column when you created the table, then changing a value in a column to null is prohibited.

If you decide that you do not want to save the changes you have made during your current work session, you can reverse the changes by executing the ____________________ command.

Which of the following is a valid SQL command?

The format for the ALTER TABLE command is the words ALTER TABLE followed by the name of the ____________________ to be altered, followed by an appropriate clause.