SQL MCQ Questions and answers Page-14 section-1

66.
When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):

A. NOT IN only.

B. LIKE only.

C. IN only.

D. Both IN and NOT IN.

A. create database structures only.

B. query database data only.

C. modify database data only.

D. All of the above can be done by SQL.

A. to limit the columns displayed.

B. for ranges.

C. as a wildcard.

D. None of these is correct.

A. SELECT name, course_name FROM student WHERE age>50 and <80;

B. SELECT name, course_name FROM student WHERE age>50 and age <80;

C. SELECT name, course_name FROM student WHERE age>50 and WHERE age<80;

D. None of these

A. SELECT * FROM student WHERE name LIKE 'r%';

B. SELECT * FROM student WHERE name LIKE '%r%';

C. SELECT * FROM student WHERE name LIKE '%r';

D. SELECT * FROM student WHERE name LIKE '_r%';

1 2 3 4 5 6 7 8 9 10 11 12 13 14