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

True/False

Review LaterAdd Note

Review Later

You cannot delete a row from a view.

Correct Answer

verified

False

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

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

A) DROP
B) REMOVE
C) UPDATE
D) DELETE

Correct Answer

verified

Show Answer

Question 3

True/False

Review LaterAdd Note

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.

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

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.

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

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

____________________ is the prevention of unauthorized access to a database.

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

Views provide data validation.

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

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

A view cannot involve statistics.

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

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

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

The system catalog is also called the ____.

The command used to delete an index is ____________________.

The defining query can be any transaction.

The types of constraints supported in MySQL are ____.