FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 7: Database Administration

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Multiple Choice

Review LaterAdd Note

Review Later

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.

A) WHERE
B) REFERENCES
C) FROM
D) IN

Correct Answer

verified

Show Answer

Question 32

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 33

Short Answer

Review LaterAdd Note

To create a view definition, use the ____________________ command.

The privilege ____ can be granted to retrieve data.

What are the disadvantages of using an index?

Which of the following commands deletes a view?

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

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

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

MySQL version 5.0 provides support for views.

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 ____________________.

Views provide a measure of security.

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

The defining query for a view can be any valid SQL query.

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

Most database management systems support the creation of views.

An index makes certain types of retrieval more efficient.

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

Which of the following commands deletes an index?

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