Which two statements are true regarding views?

Which two statements are true regarding views? (Choose two.)

Which two statements are true regarding views? (Choose two.)

A.
A sub query that defines a view cannot include the GROUP BY clause

B.
A view is created with the sub query having the DISTINCT keyword can be updated

C.
A Data Manipulation Language (DML) operation can be performed on a view that is created
with the sub query having all the NOT NULL columns of a table

D.
A view that is created with the sub query having the pseudo column ROWNUM keyword cannot
be updated

Explanation:
Rules for Performing DML Operations on a View
You cannot add data through a view if the view includes:
Group functions
A GROUP BY clause
The DISTINCT keyword
The pseudocolumn ROWNUM keyword
Columns defined by expressions
NOT NULL columns in the base tables that are not selected by the view



Leave a Reply 1

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


Ammozg

Ammozg

I think A is also correct. You literally can diefine a view with a query containing subcqiuery