Exam 7: Database Administration

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

The system catalog is also called the ____.

(Multiple Choice)
4.9/5
(41)

A view can join two or more tables.

(True/False)
5.0/5
(36)

You cannot delete a row from a view.

(True/False)
4.7/5
(36)

Views provide data validation.

(True/False)
4.8/5
(33)

The clause WITH GRANT OPTION is meaningful as part of a REVOKE command.

(True/False)
4.9/5
(46)

Explain what happens when you create a query that involves a view.

(Essay)
4.8/5
(34)

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

(Short Answer)
4.7/5
(30)

To create a view definition, use the DEFINE VIEW command.

(True/False)
4.8/5
(31)

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

(True/False)
4.9/5
(38)

The existing, permanent tables in a relational database are called stable tables.

(True/False)
4.8/5
(35)

When the primary key contains more than one column, use commas to separate the column names.

(True/False)
4.9/5
(37)

Most database management systems support the creation of views.

(True/False)
4.8/5
(27)

What are the disadvantages of using an index?

(Essay)
5.0/5
(24)

If the database structure changes, the user cannot access and use the view.

(True/False)
4.8/5
(43)

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

(Short Answer)
4.8/5
(33)

An integrity ____________________ is a rule for the data in the database.

(Short Answer)
4.9/5
(37)

A view is updatable when it is derived from joining two base tables on the ____ of each table.

(Multiple Choice)
4.9/5
(36)

The correct command to allow user Thompson to delete rows in the CUSTOMER table would be: GRANT ____ ON CUSTOMER TO THOMPSON.

(Multiple Choice)
4.8/5
(42)

To ensure the uniqueness of values in a nonprimary key column, use the ____ command to create an index.

(Multiple Choice)
4.9/5
(34)

The privilege ____ can be granted to change the table structure.

(Multiple Choice)
4.8/5
(30)
Showing 41 - 60 of 75
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)