INTRODUCTION TO SQL QUIZ

None of these

BETWEEN operator

EXISTS operator

LIKE operator

True

False

True

False

A virtual table that cannot be accessed via SQL commands

A base table that can be accessed via SQL commands

A base table that cannot be accessed via SQL commands

A virtual table that can be accessed via SQL commands

Feature has more than two 0's

Feature begins with two 0's

Feature ends with two 0's

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

True

False

True

False

MAX

UPPER

TOP

MOST

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

SELECT * FROM weather WHERE temperature BETWEEN 71 AND 89;

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

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

TRUNCATE

COMMIT

DELETE

ROLLBACK