SQL MCQ Questions and answers

A. 10

B. 9

C. 5

D. 0

A. gh

B. 23

C. bc

D. ab

A. is illegal

B. prints garbage

C. prints 045.926

D. prints 50

A. Dates

B. Column Alias

C. Strings

D. All of the above

A. ROLLBACK

B. COMMIT

C. TRUNCATE

D. DELETE

A. ROLLBACK

B. COMMIT

C. TRUNCATE

D. DELETE

A. SELECT city WHERE humidity = 89;

B. SELECT city FROM weather WHERE humidity = 89;

C. SELECT humidity = 89 FROM weather;

D. SELECT city FROM weather;

A. SELECT city FROM weather ORDER BY temperature;

B. SELECT city, temperature FROM weather;

C. SELECT city, temperature FROM weather ORDER BY temperature;

D. SELECT city, temperature FROM weather ORDER BY city;

A. Feature begins with two 0's

B. Feature ends with two 0's

C. Feature has more than two 0's

D. Feature has two 0's in it, at any position

A. SELECT city, temperature, condition FROM weather WHERE condition NOT IN ('sunny', 'cloudy');

B. SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN ('sunny', 'cloudy');

C. SELECT city, temperature, condition FROM weather WHERE condition IN ('sunny', 'cloudy');

D. SELECT city, temperature, condition FROM weather WHERE condition BETWEEN ('sunny', 'cloudy');