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
c The CH... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (2 attachments)
1803_60b8c1212b319_716745.pdf
180 KBs PDF File
1803_60b8c1212b319_716745.docx
120 KBs Word File
