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.


The INSERT command can’t be used with the CHANGENAME view because:

a. A key-preserved table isn’t included in the view.

b. The view was created with the WITH CHECK OPTION constraint.

c. The inserted record couldn’t be accessed by the view.

d. None of the above—an INSERT command can be used on the table as long as the PRIMARY KEY constraint isn’t violated.

Step by Step Solution

3.54 Rating (157 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

d None of the above x a... 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_60b8c1212bae4_716786.pdf

180 KBs PDF File

Word file Icon

1803_60b8c1212bae4_716786.docx

120 KBs Word File

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