Exam 6: Updating Data

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

Updates become permanent automatically when you exit from the DBMS.

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

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

You cannot commit and roll back data in SQL Server.

The data stored in tables changes only infrequently.

You can use the existing value in a column and a calculation to update a value.

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

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

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

To add data from an existing table to a new table, use a SELECT command in a(n) ____ command.

You use the APPEND command to add additional rows to tables.

The ____ command is permanent.

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

Access does not support the COMMIT or ROLLBACK commands.

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

By default, Oracle commits each action query as soon as the user executes the query.

Describe the format for the UPDATE 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.

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