What is the need for our query to execute successfully on an existing view?

2024

Answer: B. We must have a SELECT privilege on the view. — Answer: B Explanation: It is required to have a SELECT privilege to query on the existing view. Hence option B is the right choice.

1. A.

   The specified table must contain data.

2. B.

   We must have a SELECT privilege on the view.

3. C.

   We should have a SELECT privilege only on the specified table.

4. D.

   The specified table must be in the same database or schema.

Attempted by 367 students.