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

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 customers JOIN orders USING (customer#)

WHERE shipdate IS NULL

WITH CHECK OPTION;


Which of the following is the key-preserved table for the CHANGEADDRESS view?

a. CUSTOMERS table

b. ORDERS table

c. Both tables together serve as a composite key-preserved table.

d. None of the above

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: