To Create an Index for the Customer Table Named RepBal

question 12

Multiple Choice

To create an index for the Customer table 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:

Pennsylvania Provincial Council

A governing body in colonial Pennsylvania, responsible for advising the governor and implementing policy.

Spanish Missions

Religious and military outposts established by Spanish Catholics during the colonial period, primarily in the Americas, aimed at converting Indigenous peoples to Christianity and extending Spanish territory.

Father Junipero Serra

A Roman Catholic priest and missionary who founded several missions in what is now California during the late 18th century.

Native Populations

Indigenous peoples who were the original inhabitants of a territory before colonization or annexation by foreign powers.