.l T-Mobile 11:07 PM a instructure-uploads.s3.amazonaws.com points free Multiple Choice 5 pts each, Total: 45 pts ) #1. Which of the following statements are true about about a subquery? A. It can appear in a WHERE clause when it returns a single value B.It can appear in a WHERE clause returning a list if it is used with the operator "IN" C.It can be used to copy all of the rows from one table to another D. All of the above E. Both A and B; but not C #2. Given this code: DELETE FROM MEMBERSHIP WHERE MEM NUM NOT IN (SELECT MEM NUM FROM RENTAL) The subquery would be returning A. a single value B. a list of values C. a whole table D. None of the above #3. If this SELECT was a subquery SELECT FROM MIN (MOVIE_YEAR) MOVIE It would be returning: A. a single value B. a list of values C. a whole table D. None of the above #4. This is a valid statement: { Assume you have the table with those attributes SELECT FROM WHERE PRICEAVG (PRICE) FROM PRODUCT; PRODUCT NAME PRODUCT A. True B. False #5. A trigger is procedural SQL code that is automatically invoked by the DBMS upon the occurrence of a given data manipulation event. A. True B. False