In Order for Two Queries to Be UNION-Compatible, They Must

question 9

Multiple Choice

In order for two queries to be UNION-compatible, they must:

• A) both have the same number of lines in their SQL statements.
• B) both output compatible data types for each column and return the same number of rows.
• C) both return at least one row.
• D) both return exactly one row.

---

Definitions:

Inventory Value

The total cost or market value of all the goods and materials held by a company as part of its inventory at a specific point in time.

Service Level

A measure of the quality of a service provided, often defined by the percentage of customer demand met without delay.

Standard Deviation

A numerical indicator that calculates the degree of spread or deviation of a data set values from their average.

Salvage Value

The estimated residual value of an asset at the end of its useful life, reflecting what it can be sold for or its value for parts.