MySQL Database Questions

A. To join tables, it is enough to list the tables in theclause of the SELECT statement. C. a. FROMM b. WHERE C. TABLES d. JOIN is a relational set operator a. FROM b. HAVING c. EXCEPT d. CROSS The _combines rows from two or more queries without including duplicate a. UNION statement b. INSERT statement c. INTERSECstatement d. EXCEPT statement Which of the following is an example of a recursive query? a. SELECTCUS LNAME, INV NUMBER, INV_DATE, P DESCRIPT FROM CUSTOMER, INVOICE, LINE, PRODUCT WHERE INVOICE.INV NUMBER LINE.INV NUMBER AND LINE.P CODE PRODUCT.P CODE AND CUSTOMER.CUSCODE= 100 14 ORDER BY INV NUMBER; CUSTOMER.CUSCODE INVOICE.CUSCODE AND - - - b. P CODE, VENDOR.V CODE, V NAME SELECT FROM VENDOR LEFT JOIN PRODUCT ON VENDOR.V-CODE = PRODUCT,V-CODE; C. SELECT E.EMP_MGR, M.EMP LNAME, E.EMP NUM, E.EMP_LNAME FROM EMP E, EMP M WHERE ORDER BY E.EMP MGR; E.EMP MGR-M.EMP NUM d. SELECT PDESCRIPT, P_PRICE, V NAME, V CONTACT, V AREACODE, V PHONE FROM PRODUCT P. VENDOR V WHERE ORDER BY P PRICE; P.VCODE = V.VCODE