A Join Returns Rows with Matching Values and Includes All

question 94

Multiple Choice

A join returns rows with matching values and includes all rows from both tables (T1 and T2) with unmatched values.

• A) natural
• B) cross
• C) full outer
• D) left outer

---

Definitions:

Short Text

A concise piece of information, usually limited in length and scope.

Characters

Symbols, letters, or numerals used in writing or printing to represent sounds, words, or concepts.

Field Names

Field names are identifiers used in databases and spreadsheets to label columns of data, representing the type of information stored in each column.

Digits

Numerals from 0 to 9 that are the building blocks of numbers in the decimal system.