Critical Thinking questions (Multiple Choice) Based on the following query: SELECT AlbumTitle FROM Albums WHERE ArtistName = 'Jefferson Airplane' AND DiscountPrice
A) if the ArtistName field contains Jefferson Airplane
B) if the value in the DiscountPrice field is less than $10.00
C) if the ArtistName field contains Jefferson Airplane and the value in the DiscountPrice field is less than $10.00
D) if the ArtistTitle field contains Jefferson Airplane and the value in the DiscountPrice field is less than $10.00

Question

Quizplus · Accepted Answer

The query specifies both "ArtistName = 'Jefferson Airplane'" and "DiscountPrice", so the query will only select albums where both of those conditions are true. Therefore, choice C is correct. Choice A only specifies the artist name but does not include the discount price condition, so it is not sufficient. Choice B only specifies the discount price condition but does not include the artist name, so it is also not sufficient. Choice D refers to "ArtistTitle" instead of "ArtistName", so it is incorrect.

Critical Thinking Questions (Multiple Choice) Based on the Following Query