Exam 7: Database Administration

A view is a derived table.

An index makes certain types of retrieval more efficient.

You can only specify a primary key when you first create a table.

The GRANT command to indicate that a user has all privileges includes the FULL privilege.

To add a primary key after creating a table, you can use the ____________________ clause of the ALTER TABLE command.

You can create and use a(n) ____________________ to speed up the searching process significantly.

To add a row to your view, simply add a row to each underlying derived table.

When you create a query that involves a view, SQL changes the query to one that selects data from the table(s) in the database that created the view.

You can create and maintain an index for any row in any table.

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

____________________ is the prevention of unauthorized access to a database.

You can add rows to a view that includes calculations.

The privilege ____ can be granted to change data.

To create a view definition, use the ____________________ command.

The GRANT command to indicate that all users can retrieve data using a SELECT command includes the word ____________________ rather than the specific name of a user.