Please answer the following mcq

irantuto.com questions, refer to the tables in the JustLee Books database. Ouestions sstul execution of the following statement CREATE VIEW changeaddress AS SELECT cuatomers, 1astname, firstname, ordert ahspatreet, shipeity, ahipatate, shipzip naH euatoners Jong orders U8ING (customer#) WHERE shipdate IS NUL CHECK OPTION Which of the following statements is conmect? 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. Assuming there's only a primary key, and FOREIGN KEY constraints exist on the underlying tables, which of the following commands returms an emor message? a. UPDATE changeaddress 2. WHERE customer# 1020; b. INSERT INTO changeaddress VALUES (9999 LAST'FIRST9999 123 HERE AVENYTOM AA 99999) c. DELETE FROg change addre s KHERE eustoner8-1020 d. all of the above e. only a and b f. only a and c g none of the above Which of the following is the key-preserved table for the b ORDERS table C. B0 tables together serve as a composne key-preserved table d none of the above Which of the tollowing columns serves as the primary key for the CHANGEADDRESS a. Customere b.Lastname c Firstname d. Order e. Shipstreet view based on the Customere colue 5 IH a record is deleted from the the customer information is then deleted trom which underlying table? b. C. d. ORDERS CUSTOMERS and 0DERS Neither the DELETE command can't be used on the CHANGEADDRESS view Which of the tolowing is correct