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

Short Answer

Review LaterAdd Note

Review Later

To create a view definition, use the ____________________ command.

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

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

A) database analyst
B) developer
C) database administrator
D) programmer

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

Which of the following commands deletes a view?

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

Which of the following commands deletes an index?

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

Views provide a measure of security.

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

Most database management systems support the creation of views.

MySQL version 5.0 provides support for views.

The privilege ____ can be granted to retrieve data.

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

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 index makes certain types of retrieval more efficient.

What are the disadvantages of using an index?

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

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

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

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

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