Which object privileges can be granted on a view?

  1. none

  2. DELETE, INSERT,SELECT

  3. ALTER, DELETE, INSERT, SELECT

  4. DELETE, INSERT, SELECT, UPDATE


Correct Option: D

AI Explanation

To answer this question, you need to understand the concept of object privileges and views.

A view is a virtual table that is based on the result of a query. It allows you to retrieve data from one or more tables as if it were a single table. When granting privileges on a view, you can specify which operations can be performed on the view.

Let's go through each option to understand which object privileges can be granted on a view:

Option A) None - This option is incorrect because object privileges can be granted on a view.

Option B) DELETE, INSERT, SELECT - This option is incorrect because it does not include the UPDATE privilege, which can be granted on a view.

Option C) ALTER, DELETE, INSERT, SELECT - This option is incorrect because it does not include the UPDATE privilege, which can be granted on a view.

Option D) DELETE, INSERT, SELECT, UPDATE - This option is correct because it includes all the object privileges that can be granted on a view. With these privileges, you can perform operations such as deleting, inserting, selecting, and updating data on the view.

The correct answer is option D.

Find more quizzes: