Which Statement About Table Joins in SQL Is True

question 16

Multiple Choice

Which statement about table joins in SQL is true?

• A) Self-joins usually do not include WHERE or ORDER BY clauses.
• B) You cannot perform a self-join on a table's primary key column.
• C) Joins must be performed between at least two different tables.
• D) SQL has no problem treating one table with two aliases as two tables.

---

Definitions:

Rent Controls

Government-imposed limits on the amount landlords can charge for renting out their property to ensure affordable housing for tenants.

Rental Units

Housing units, such as apartments or houses, that are available for rent to tenants.

Surplus

A situation where the quantity supplied of a good exceeds the quantity demanded at a given price.

Price Ceiling

A legal maximum price that can be charged for a good or service, typically set by government regulation.