MCQs
Total Questions : 15
| Page 1 of 2 pages
Answer: Option B. -> update more than one row at a time
Answer: Option A. -> SELECT city, temperature, condition FROM weather WHERE condition NOT IN (‘sunny’, ‘cloudy’)
Answer: Option D. -> SELECT city, temperature FROM weather ORDER BY city
Answer: Option C. -> SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ AND temperature > 70
Answer: Option A. -> Insert Into
Answer: Option B. -> SELECT, FROM, WHERE, ORDER BY
Answer: Option C. -> Trim
Answer: Option B. -> Involves the use of an inner and outer query.
Answer: Option B. -> Boolean operators