To Create an Index Named RepBal with the Keys RepNum

question 9

Multiple Choice

To create an index named RepBal with the keys RepNum and Balance and with the balances listed in descending order,the command is ____.​

• A) ​CREATE INDEX RepBal ON Customer (RepNum, Balance) ;
• B) ​CREATE INDEX RepBal Customer (RepNum DESC) ;
• C) ​CREATE INDEX ON Customer (RepNum, Balance ASC) ;
• D) ​CREATE INDEX RepBal ON Customer (RepNum, Balance DESC) ;

---

Definitions:

Network Design Decisions

Strategic choices made regarding the layout and functioning of a supply chain network, including locations of facilities and distribution routes.

Supply Chain Configuration

The arrangement and integration of the supply chain's various components, including suppliers, production facilities, distribution centers, and customers, to maximize efficiency and effectiveness.

Responsiveness

The ability of a company or system to quickly react to changes in demand, technology, or market conditions.

Network Design Decision

Involves determining the most efficient arrangement of infrastructure, resources, and processes to effectively deliver goods or services to customers.