Exam 6: Updating Data

Before beginning the updates for a transaction, commit any previous updates by executing the ____________________ command.

What happens if you run a DELETE command that does not contain a WHERE clause?

When necessary, include a WHERE clause into the UPDATE command to indicate the column on which the change is to take place.

In order to use the ROLLBACK commands in MySQL, you need to change the value for ____ to 0.

In a transaction, if you can complete all updates successfully, execute the ____________________ command after completing the final update.

Which of the following commands executes a rollback?

During your current work session you can save your changes immediately by executing the ____________________ command.

In some cases, when you update the data in a table, you can reverse (cancel)them at any time during your current work session.

The ROLLBACK command reverses changes made to the ____________________ only.

In MySQL, use the ____ data type for variable-length character columns.

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

In some cases, you might need to change a table's structure in ways that are beyond the capabilities of your DBMS. When that happens, use the RESTRUCTURE command to redesign the table.

You must execute the SET AUTOCOMMIT = 0; command once at the beginning of a session and once at the end of the session if you want to use the COMMIT and ROLLBACK commands.

You cannot use the INSERT command to update table data.

One of the nicest features of a relational DBMS, such as MySQL, is the ease with which you can change table structures.

You can change the characteristics of existing columns by using the ____________________ clause of the ALTER TABLE command.

The NULL value should be enclosed in single quotation marks.

To change a column that currently rejects null values so that it accepts null values, use the ____ clause of the ALTER TABLE command

Describe the format for the UPDATE command.

With SQL, you can change a table's structure by using the ____________________ command.