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

Question

Quizplus · Accepted Answer

Option A selects the Title and ProductionCo fields from records whose title starts with "The " (with a space after "The") but does not sort them in descending order by ProductionCo.
Option C uses an incorrect wildcard character (* instead of %) and does not explicitly limit the title to start with "The ".
Option D selects the Title and ProductionCo for all records in the table and sorts them in descending order by ProductionCo, without limiting the titles to start with "The ".
Option B selects the Title and ProductionCo fields from records whose title starts with "The " (with a space after "The") and sorts them in descending order by ProductionCo, which is what the question asks for. Therefore, option B is the correct answer.

Which of the Following Statements Selects the Title and ProductionCo