Exam 7: Database Administration

Within relational model systems on both mainframes and personal computers, the main mechanism for increasing the efficiency with which data is retrieved from the database is the ____________________.

With a view, the display of data can be customized to meet each user's needs.

The general form for assigning a foreign key is ADD FOREIGN KEY, the column name(s) of the foreign key, the ____ clause, and then the table name that the foreign key must match.

An auxiliary key is a column in one table whose values match the primary key in another table.

When you create a view, you cannot assign column names that are different from those in the base table.

A view cannot involve statistics.

The CREATE VIEW command includes the words CREATE VIEW, followed by the name of the view, the word ____, and then a query.

What are the benefits of using views?

In a business organization, a person or an entire group known as the ____ is charged with managing the database.

The main mechanism for providing access to a database is the ____________________ command.

The types of constraints supported in SQL are ____.

The main mechanism for providing access to a database is the ____ command.

You use the LEGAL clause of the ALTER TABLE command to ensure that only legal values satisfying a particular condition are allowed in a given column.

The defining query can be any transaction.

When renaming columns, you include the new column names in ____ following the name of the view.

The command used to delete an index is ____________________.

When a view is no longer needed, you can remove it using the ____________________ command.

When you specify a foreign key, the table referenced by the foreign key is the ____.

In Oracle, the ____ table contains information about the tables known to SQL.

Views furnish a certain amount of security; if users are accessing the database through a view, they cannot access any data that is not included in the view.