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

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

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

A.
The underlying tables must be in the same schema.

B.
You need SELECT privileges only on the underlying tables.

C.
The underlying tables must have data.

D.
You need SELECT privileges on the view.

Explanation:

To query an existing view you need to have SELECT privileges on the view.



Leave a Reply 0

Your email address will not be published. Required fields are marked *