INTRODUCTION TO SQL QUIZ

COLLAPSE

DELETE

ALTER

REMOVE

All of these

Normalization

Materialized Views

Data Integrity

ALIGN BY

SORT BY

ORDER BY

GROUP BY

Data Manipulation Language(DML)

None

Data Definition Language(DDL)

Both of above

False

True

SELECT city WHERE humidity = 89;

SELECT city FROM weather;

SELECT humidity = 89 FROM weather;

SELECT city FROM weather WHERE humidity = 89;

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

The order of occurrence determines the order of evaluation.

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

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

None of these

SELECT SYSDATE - (SYSDATE + 2) FROM DUAL;

SELECT SYSDATE - SYSDATE FROM DUAL;

SELECT SYSDATE - (SYSDATE - 2) FROM DUAL;

False

True

True

False