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 1

Multiple Choice

Review LaterAdd Note

Review Later

The system catalog is also called the ____.

A) system database
B) data dictionary
C) master data table
D) transaction database

Correct Answer

verified

Show Answer

Question 2

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

False

Question 3

True/False

Review LaterAdd Note

Views provide data validation.

A view cannot involve statistics.

The defining query can be any transaction.

Which of the following commands lists all the privileges granted to a user?

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

You cannot delete a row from a view.

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

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

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

The types of constraints supported in MySQL are ____.

The command used to delete an index is ____________________.

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

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.

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

____________________ is the prevention of unauthorized access to a database.

When you create a query that involves a view, SQL changes the query to one that selects data from the table(s)in the database that created the view.

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

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