Question: This question is based on successful execution of the following statement: CREATE VIEW changeaddress AS SELECT customer#, lastname, firstname, order#, shipstreet, shipcity, shipstate, shipzip FROM

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

CREATE VIEW changeaddress

AS SELECT customer#, lastname, firstname, order#,

shipstreet, shipcity, shipstate, shipzip

FROM customers JOIN orders USING (customer#)

WHERE shipdate IS NULL

WITH CHECK OPTION;


Which of the following statements is correct?

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

b. The CHANGEADDRESS view is a simple view.

c. The CHANGEADDRESS view is a complex view.

d. The CHANGEADDRESS view is an inline view.

Step by Step Solution

3.48 Rating (174 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

c 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_60b8c1212b319_716745.pdf

180 KBs PDF File

Word file Icon

1803_60b8c1212b319_716745.docx

120 KBs Word File

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