Exam 6: Updating Data

You cannot change the characteristics of existing columns.

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

In Oracle 10g, a null value is displayed as a hyphen.

In Oracle, use the ____________________ command to display the structure of a table.

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

You can create a new table using data in an existing table.

____ is the default transaction mode in Oracle and commits each action query as soon as the user executes the query.

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

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

Which of the following is a valid SQL command?

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

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

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

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

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

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

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

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.

In Access, use the Documenter tool to show the layout of a table.

You cannot use a compound condition with an UPDATE command.