Exam 7: Database Administration

The system catalog is also called the ____.

A view can join two or more tables.

You cannot delete a row from a view.

Views provide data validation.

The clause WITH GRANT OPTION is meaningful as part of a REVOKE command.

Explain what happens when you create a query that involves a view.

A view is defined by creating a defining ____________________, which indicates the rows and columns to include in the view.

To create a view definition, use the DEFINE VIEW command.

When you specify a foreign key, the table containing the foreign key is the parent.

The existing, permanent tables in a relational database are called stable tables.

When the primary key contains more than one column, use commas to separate the column names.

Most database management systems support the creation of views.

What are the disadvantages of using an index?

If the database structure changes, the user cannot access and use the view.

To ensure the uniqueness of values in a non-primary key column, you can create a unique index by using the ____________________ command.

An integrity ____________________ is a rule for the data in the database.

A view is updatable when it is derived from joining two base tables on the ____ of each table.

The correct command to allow user Thompson to delete rows in the CUSTOMER table would be: GRANT ____ ON CUSTOMER TO THOMPSON.

To ensure the uniqueness of values in a nonprimary key column, use the ____ command to create an index.

The privilege ____ can be granted to change the table structure.