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:

Extraordinary Items

Unusual and infrequent gains or losses that are reported separately on a company's income statement.

Uncollectible Accounts

Accounts receivable that a company is unable to collect, often leading to a write-off as a bad debt expense.

Expropriation

The governmental seizure of private property without the owner's consent, often with compensation.

Extraordinary Item

Extraordinary items were once classified on income statements to denote unusual or infrequent transactions that were distinct from regular business operations, but accounting standards have evolved to limit or exclude these classifications.