Exam 6: Updating Data

In MySQL, use the ____ command to show the layout of a table.

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

MySQL allows you to reduce the size of a column.

Describe the format of the ALTER TABLE command to add a new column.

The ADD clause consists of the word ADD followed by the name of the ____________________ to be added, followed by the characteristics.

You can delete a table that is no longer needed by using the ____________________ TABLE command.

To make the same update for all rows in a table, omit the ____ clause.

The command CREATE TABLE LEVEL1_CUSTOMER ____________________ CUSTOMER; creates a new table from an existing table.

The command for changing a value to null is the same for changing any other value.

In MySQL, use the ____ command to show the revised structure of a table.

There are table structure changes that are beyond the capabilities of MySQL.

In order to use the COMMIT command in MySQL, you need to change the value for AUTOCOMMIT to ____.

To delete data from the database, use the ____ command.

The ____ command is permanent.

It is possible to use calculations to update a value in a column.

If you have not run the COMMIT command, executing the ____ command will reverse all updates made during the current work session.

You can increase the length of a column but you cannot decrease the length of a column.

MySQL does not support the COMMIT or ROLLBACK commands.

In a transaction, if any update cannot be completed, execute the ____________________ command and discontinue the updates for the current transaction.

How can you use the COMMIT and ROLLBACK commands to support transactions?