This question is based on successful execution of the following command: CREATE VIEW changename AS SELECT customer#,

Question:

This question is based on successful execution of the following command:

CREATE VIEW changename

AS SELECT customer#, lastname, firstname

FROM customers

WITH CHECK OPTION;

Assume that the only constraint on the CUSTOMERS table is a PRIMARY KEY constraint.


Which of the following is a correct statement?

a. No DML operations can be performed on the CHANGENAME view.

b. The CHANGENAME view is a simple view.

c. The CHANGENAME view is a complex view.

d. The CHANGENAME view is an inline view.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Oracle 12c SQL

ISBN: 978-1305251038

3rd edition

Authors: Joan Casteel

Question Posted: