To Create an Index Named RepBal with the Keys RepNum

question 36

Multiple Choice

To create an index named RepBal with the keys RepNum and Balance and with the balances listed in descending order, which command should you use?

• 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:

Pragmatic Socialist

A pragmatic socialist is an individual or ideology focused on socialist principles but flexible in methods and strategies to achieve social and economic goals, embracing practical approaches over purely ideological ones.

Industrialist

An individual who owns, operates, or has significant financial interest in industrial enterprises.

Karl Marx

A 19th-century philosopher, economist, and political theorist, best known for his critical analysis of capitalism and his influence on the development of socialism and communism.

Scientific Socialist

An individual who advocates for socialism using scientific analysis of society and economy, typically associated with the approaches of Karl Marx and Friedrich Engels.