Match the Following Terms to Their Definition

question 9

Short Answer

Match the following terms to their definition:
I.INNER JOIN
II.OUTER JOIN
III.FULL JOIN
IV.Union query
V.SQL subquery
A.Returns only the rows that actually match
B.Returns all rows from both tables
C.Usually added in the WHERE clause
D.Returns all rows from at least one of the tables
E.Combines two SQL SELECT statements

---

Definitions:

Basic Unit

Refers to the most fundamental, indivisible component or measurement used as a standard in a system, process, or mechanism.

National Currency

The official money issued by a country's government, which is used within its economic and financial systems.

Consumer Ethnocentrism

The belief among consumers that purchasing domestic products is morally right and superior to buying foreign-made items.

Cultural Semiotics

The study of signs and symbols within cultural contexts, exploring how meanings are constructed and communicated in societies.