database:

1.

2.

3.

4.

5.

A(n) join returns not only the rows matching the join condition (that is, rows with matching values in the common columns) but also the rows with unmatched values. Select one: a. outer b. cross O C. equi- d. inner Assume you are using the UNION ALL operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the UNION ALL operator? Select one: O a. 17 Ob. 2 O c. 15 O d. 8 Union-compatible means that the Select one: O a. number of attributes in the relations must be the same, but the names and data types can be different O b. number of attributes in the relations must be the same, the names of the relation attributes must be the same, but the data types can be different O c. number of attributes in the relations must be the same, the names of the relation attributes can be different, but the data types must be alike O d. names of the relation attributes must be the same and their data types must be alike The operator combines rows from two or more queries without including duplicate rows. Select one: a. INTERSECT O b. UNION ALL O c. MINUS d. UNION The statement in SQL combines rows from two queries and returns only the rows that appear in the first set but not in the second. Select one: a. INTERSECT b. UNION C. MINUS d. UNION ALL