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

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.

Step by Step Solution

3.33 Rating (150 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

b The CH... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (2 attachments)

PDF file Icon

1803_60b8c1212b9b7_716778.pdf

180 KBs PDF File

Word file Icon

1803_60b8c1212b9b7_716778.docx

120 KBs Word File

Students Have Also Explored These Related Oracle 12c SQL Questions!