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
Answer: B
You might also like to view...
______________________________ is a central point in Windows 10 for managing the configuration of the network you are currently connected to.
Fill in the blank(s) with the appropriate word(s).
The data that you entered into a ____ is collected by a program that runs on the Web site's server.
A. form B. table C. database D. row
The ____ method in the Math class returns the x number raised to the power of the y number.
A. Power(x,y) B. Pow(x,y) C. Exp(x,y) D. Exponent(x,y)
A dependent key is a field or combination of fields on which all fields in the table are functionally dependent.
Answer the following statement true (T) or false (F)