The Statement in SQL Combines Rows from Two Queries and Returns

question 25

Multiple Choice

The statement in SQL combines rows from two queries and returns only the rows that appear in the first set but not in the second.

• A)UNION
• B)UNION ALL
• C)INTERSECT
• D)MINUS

---

Definitions:

Depreciation Expense

The allocated portion of the cost of a fixed asset that is written off each year over the asset's useful life.

Straight-line Method

A method of allocating the cost of a tangible asset over its useful life in equal annual amounts.

Salvage Value

The projected remaining worth of an asset upon reaching the end of its serviceable duration.

Depreciation Expense

The allocation of the cost of a tangible asset over its useful life, reflecting its decrease in value over time.