What is the need for our query to execute successfully on an existing view?
2024
What is the need for our query to execute successfully on an existing view?
- A.
The specified table must contain data.
- B.
We must have a SELECT privilege on the view.
- C.
We should have a SELECT privilege only on the specified table.
- D.
The specified table must be in the same database or schema.
Attempted by 169 students.
Show answer & explanation
Correct answer: B
Answer: B
Explanation: It is required to have a SELECT privilege to query on the existing view. Hence option B is the right choice.