MySQL Database Questions A. To join tables, it is enough to list the tables in t

Question

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 - -

Explanation / Answer

Question 1:

Answer: d

Syntax:

select * from table1 table1

INNER JOIN table2 ON table1.columName=table2.columName;

Question 2:

Answer: C

Syntax:

Join Table to self table.

Question 3:

Answer: D

Syntax:

SELECT table112

FROM tabl1 CROSS JOIN tabl2;

Question 4:

Answer: a

Syntax:

UNION operator selects only distinct values by defaul

select * from table1

UNION

select * from table2;

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.