A FULL OUTER JOIN with the matching rows removed is known as a ______________.

a. FULL LEFT OUTER JOIN
b. FULL RIGHT OUTER JOIN
c. UNION JOIN
d. EXCEPT JOIN


c. UNION JOIN

Computer Science & Information Technology

You might also like to view...

A(n) ________ is a visual depiction of numeric data

Fill in the blank(s) with correct word

Computer Science & Information Technology

The ________ gallery displays a set of predefined characteristics that change the overall visual look of a chart in terms of its colors, backgrounds, and graphic effects

Fill in the blank(s) with correct word

Computer Science & Information Technology

Match each table-related term with its description

A) Labels above each table column B) Up arrow or down arrow indicating sort direction of a column C) Small arrow that appears to the right of the label at the top of a table column D) Excel table column that uses a single formula and adjusts its cell references for the rest of the rows in the table 100) Header row 101) Sort arrow 102) Filter button 103) Calculated column

Computer Science & Information Technology

Click the Formula button in the ____ group on the Table Tools Layout tab to open the Formula dialog box.

A. Table B. Rows & Columns C. Formulas D. Data

Computer Science & Information Technology