Multiple choice technology databases

What is necessary for your query on an existing view to execute successfully

  1. The underlying tables must have data

  2. You need SELECT privileges on the view

  3. The underlying tables must be in the same schema

  4. You need SELECT privileges only on the underlying tables
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

To query a view, a user must have the SELECT privilege on the view itself. They do not necessarily need direct privileges on the underlying base tables, as the view owner's privileges grant access.

Keep practicing — related questions