Which of the Following Statements Selects the Title and ProductionCo

question 57

Multiple Choice

Which of the following statements selects the Title and ProductionCo fields from records whose title begins with the word "The" followed by a space and zero or more characters,and then sorts the records in descending order by the ProductionCo field?

• A)SELECT Title, ProductionCo FROM tblMovies WHERE Title LIKE 'The %' ORDER BY ProductionCo
• B)SELECT Title, ProductionCo FROM tblMovies WHERE Title LIKE 'The %' ORDER BY ProductionCo DESC
• C)SELECT Title, ProductionCo FROM tblMovies WHERE Title LIKE 'The *' ORDER BY ProductionCo DESC
• D)SELECT Title, ProductionCo FROM tblMovies ORDER BY ProductionCo DESC

---

Definitions:

Edict Of Nantes

A 1598 decree issued by King Henry IV of France, granting substantial religious freedoms to French Protestants (Huguenots) and bringing an end to the Wars of Religion.

Huguenots

Members of the French Protestant group that faced severe persecution in the 16th and 17th centuries, leading many to flee France for other countries.

New France

The area colonized by France in North America from the 16th to the 18th century, including parts of contemporary Canada, the United States, and several Caribbean islands.

Catastrophic Decline

A severe and rapid decrease in the population, quality, or condition of something, often leading to its dire depletion or degradation.