INTRODUCTION TO SQL QUIZ

NON-EQUIJOIN

NATURAL JOIN

OUTER JOIN

EQUIJOIN

SELECT * FROM weather WHERE temperature NOT IN (71 to 89);

SELECT * FROM weather WHERE temperature NOT BETWEEN 71 to 89;

SELECT * FROM weather WHERE temperature NOT IN (71 and 89);

SELECT * FROM weather WHERE temperature BETWEEN 71 AND 89;

NOT IN only

LIKE only

IN only

IN and NOT IN

None of these

SELECT SYSDATE - (SYSDATE + 2) FROM DUAL;

SELECT SYSDATE - SYSDATE FROM DUAL;

SELECT SYSDATE - (SYSDATE - 2) FROM DUAL;

all records with even partial criteria met are to be returned.

None of these

all columns of the table are to be returned.

all records meeting the full criteria are to be returned.

False

True

specify search condition

specify range for search condition

specify what table we are selecting or deleting data FROM

None of these

Column Alias

All of these

Dates

Strings

XML

HTML

DML

DDL

True

False