Select the Statement That Is Correct About the Outer Join

question 19

Multiple Choice

Select the statement that is correct about the outer join operator:

• A) The outer join operator generates the join result (the matching rows).
• B) The outer join operator generates the join result (the nonmatching rows).
• C) The outer join operator generates the join result (the matching rows) plus the nonmatching rows.
• D) The outer join operator generates the join result (the nonmatching rows) but excludes the matching rows.

---

Definitions:

Action Query

A type of query in databases, especially in Microsoft Access, that performs actions on data (like inserting, updating, or deleting) rather than just selecting data.

Make-Table Query

A type of database query that creates a new table and populates it with data selected from one or more existing tables.

Select Query

In databases, a select query is used to retrieve specific data from one or more tables based on a set of criteria.

Update Query

In database management, a query that modifies the values of existing records in a table according to specified criteria.