MySQL Database Questions

A. A(n) with unmatched values. returns not only the rows matching the join condition but also the rows C. ROUND(value, p) is an example of a a. outer join b. inner join c. natural join d. cross join a. numeric function b. string function c. conversion function d. date and time function B. Which of the following is the syntax for a left outer join? The most common type of subquery uses an inner SELECT subquery on the right side of a(n)expression. a. SELECT column-list a. WHERE comparison b. IN comparison c. UNION comparison d. EXCEPT comparison FROM table1 OUTER JOIN table2 LEFT WHERE join-condition b. SELECT column-list FROM table1 LEFT [OUTER] JOIN table2 ON join-condition C. SELECT column-list WHERE LEFT table1 table 2 d. SELECT column-list FROM table1 LEFT table2 [JOIN] WHERE join-condition