INTRODUCTION TO SQL QUIZ

Selection operation.

Join operation.

Rename operation.

Projection operation.

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

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

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

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

values.

columns.

groups.

distinct values.

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

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

None of these

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

COLLAPSE

REMOVE

ALTER

DELETE

Acts EXACTLY like a WHERE clause.

Acts like a WHERE clause but is used for columns rather than groups.

Acts like a WHERE clause but is used for groups rather than rows.

Acts like a WHERE clause but is used for rows rather than columns.

ONLY

DISTINCT

UNIQUE

SINGLE

NOT IN only.

IN only.

Both IN and NOT IN.

LIKE only.

DISTINCT

DISTINCTIVE

DIFFERENT

UNIQUE

NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last.

The order of occurrence determines the order of evaluation.

AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last.

NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last.