Exam 7: Database Administration

Views provide a measure of security.

The process of managing a database is called database ____________________.

Access does not support the DROP VIEW command.

The database administrator uses the ____ command to revoke privileges from users.

A(n) ____________________ subset view consists of a subset of the rows and columns in some base table.

The database administrator uses the ____________________ command to revoke privileges from users.

The DBMS provides integrity administration, the process of specifying integrity constraints for a database that the DBMS will enforce.

To create a view in Access, create a query to define the view and then save the query object in the database.

If two base tables have the same primary key and the primary key is used as the join column, updating the database is a problem.

Which of the following commands deletes an index?

Information about tables in the database is kept in the system ____________________.

In general, views that involve joins of ____________________ tables can cause problems at update.

The privilege ____ can be granted to retrieve data.

If the user needs to be able to pass the privilege to other users, the GRANT command must include the ____________________ clause.

The DROP VIEW command removes the tables and data on which the view is based.

The command used to create an index is ____________________.

The command to delete a view is ____.

A(n) ____________________ is an application program's or an individual user's picture of the database.

In Oracle, the ____ table contains information about the columns within tables.

Normally, when the database administrator grants a particular privilege to a user, the user cannot pass that privilege along to other users.