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

The correct answer is C. A Data Manipulation Language (DML) operation can be performed on a view that is created with D. A view that is created with the sub query having the pseudo column ROWNUM keyword cannot be. Rules for Performing DML Operations on a View You cannot add data through a view if the view includes: 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

Creating Other Schema Objects

Question

Options

AA sub query that defines a view cannot include the GROUP BY clause
BA view is created with the sub query having the DISTINCT keyword can be updated
CA Data Manipulation Language (DML) operation can be performed on a view that is created with
DA view that is created with the sub query having the pseudo column ROWNUM keyword cannot be

How the community answered

(21 responses)

A
5% (1)
B
10% (2)
C
86% (18)

Explanation

Rules for Performing DML Operations on a View You cannot add data through a view if the view includes: 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

Topics

#views#DISTINCT keyword#ROWNUM pseudo-column#DML restrictions

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice