View the Exhibit to examine the description for the SALES table. Which views can have all DML operations performed on it? (Choose all that apply.)

Question

Exhibit

Options

• ACREATE VIEW v3
• BCREATE VIEW v1
• CCREATE VIEW v2
• DCREATE VIEW v4

• A
  83% (20)
• C
  8% (2)
• D
  8% (2)

Explanation

You can create a view by embedding a subquery in the CREATE VIEW statement. CREATE [OR REPLACE] [FORCE|NOFORCE] VIEW view [(alias[, alias]...)] [WITH CHECK OPTION [CONSTRAINT constraint]] [WITH READ ONLY [CONSTRAINT constraint]]; OR REPLACE Re-creates the view if it already exists FORCE Creates the view regardless of whether or not the base tables exist NOFORCE Creates the view only if the base tables exist (This is the default.) View Is the name of the view alias Specifies names for the expressions selected by the view's query (The number of aliases must match the number of expressions selected by the view.) subquery Is a complete SELECT statement (You can use aliases for the columns in the SELECT list.) WITH CHECK OPTION Specifies that only those rows that are accessible to the view can be inserted or updated ANSWER D constraint Is the name assigned to the CHECK OPTION constraint WITH READ ONLY Ensures that no DML operations can be performed on this view 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 ?ANSWER C

No community discussion yet for this question.