Which object privileges can be granted on a view?
-
none
-
DELETE, INSERT,SELECT
-
ALTER, DELETE, INSERT, SELECT
-
DELETE, INSERT, SELECT, UPDATE
Object privileges that can be granted on a view in Oracle are SELECT, INSERT, UPDATE, and DELETE. These are the standard DML privileges applicable to views. ALTER is a structure modification privilege that cannot be granted on views - only the view owner or someone with ALTER ANY VIEW privilege can modify the view definition.
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.