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:

Single-Room Occupancy

A form of housing in which one tenant occupies a single room and shared amenities such as bathrooms and kitchens are common.

Filthy Bathroom

An unclean and possibly contaminated bathroom that requires cleaning for health reasons.

Home Healthcare

Medical and non-medical services provided in a patient's home to promote, maintain, or restore health or minimize the effects of illness and disability.

Home Hospice Care

Supportive care provided at home for terminally ill patients, focusing on comfort and quality of life.