Exam 7: Database Administration

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

Views provide a measure of security.

(True/False)
4.8/5
(33)

The process of managing a database is called database ____________________.

(Short Answer)
4.7/5
(36)

Access does not support the DROP VIEW command.

(True/False)
4.9/5
(49)

The database administrator uses the ____ command to revoke privileges from users.

(Multiple Choice)
4.7/5
(35)

A(n) ____________________ subset view consists of a subset of the rows and columns in some base table.

(Short Answer)
4.9/5
(43)

The database administrator uses the ____________________ command to revoke privileges from users.

(Short Answer)
4.8/5
(34)

The DBMS provides integrity administration, the process of specifying integrity constraints for a database that the DBMS will enforce.

(True/False)
4.9/5
(37)

To create a view in Access, create a query to define the view and then save the query object in the database.

(True/False)
4.8/5
(34)

If two base tables have the same primary key and the primary key is used as the join column, updating the database is a problem.

(True/False)
4.9/5
(32)

Which of the following commands deletes an index?

(Multiple Choice)
4.8/5
(24)

Information about tables in the database is kept in the system ____________________.

(Short Answer)
4.8/5
(31)

In general, views that involve joins of ____________________ tables can cause problems at update.

(Short Answer)
4.8/5
(35)

The privilege ____ can be granted to retrieve data.

(Multiple Choice)
4.9/5
(39)

If the user needs to be able to pass the privilege to other users, the GRANT command must include the ____________________ clause.

(Short Answer)
4.9/5
(34)

The DROP VIEW command removes the tables and data on which the view is based.

(True/False)
4.8/5
(34)

The command used to create an index is ____________________.

(Short Answer)
4.8/5
(30)

The command to delete a view is ____.

(Multiple Choice)
4.8/5
(36)

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

(Short Answer)
4.9/5
(36)

In Oracle, the ____ table contains information about the columns within tables.

(Multiple Choice)
4.9/5
(36)

Normally, when the database administrator grants a particular privilege to a user, the user cannot pass that privilege along to other users.

(True/False)
4.9/5
(40)
Showing 21 - 40 of 75
close modal

Filters

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