When a Subquery Involves a Table Listed in the Outer

question 26

Multiple Choice

When a subquery involves a table listed in the outer query, the subquery is called a(n) _____.

• A) inner outer subquery
• B) correlated subquery
• C) reverse subquery
• D) parameter subquery

---

Definitions:

Social Exchange Theory

A theory suggesting that human relationships are formed by the use of a subjective cost-benefit analysis and the comparison of alternatives.

Altruistic Behavior

Action taken to benefit others without expecting personal gains, driven by selfless concern for the well-being of others.

Reciprocity Norms

Social norms that dictate that we should treat others as they treat us, leading to mutual benefit or support.

Reciprocity Norm

A social expectation that people will respond to each other in kind, returning benefits for benefits and responding to harms with either retaliation or forgiveness.