Four Records Have the Record Structure: EQUIPMENT (EQUIP#,LOCATION)

question 85

Multiple Choice

Four records have the record structure: EQUIPMENT (EQUIP#,LOCATION) . EQUIPMENT (204,1)
EQUIPMENT (204,2)
EQUIPMENT (208,1)
EQUIPMENT (209,1)
When sorting these records,which field is the primary sort key and which field is the secondary sort key?

• A) EQUIPMENT is primary; no secondary sort key is required.
• B) EQUIP# is primary; no secondary sort key is required.
• C) EQUIP# is primary; LOCATION is the secondary key.
• D) LOCATION is primary; EQUIP# is the secondary key.

---

Definitions:

Gas Pipeline

A specialized conduit designed to transport natural gas from its source to its point of use.

Petition the Government

The act of formally requesting or appealing to governmental authorities for a specific cause or action.

First Amendment

A provision of the United States Constitution that guarantees freedoms concerning religion, expression, assembly, and the right to petition.

Federal Regulation

Rules or laws set by the federal government of a country to regulate activities, industries, and environments.