INTRODUCTION TO SQL QUIZ

DELETE

TRUNCATE

COMMIT

ROLLBACK

SELECT city FROM weather ORDER BY temperature;

SELECT city, temperature FROM weather ORDER BY temperature;

SELECT city, temperature FROM weather;

SELECT city, temperature FROM weather ORDER BY city;

False

True

True

False

FROM, WHERE, SELECT

WHERE, FROM,SELECT

SELECT, FROM, WHERE

SELECT,WHERE,FROM

the same as 0 for integer

the same as blank for character

not a value

the same as 0 for integer and blank for character

0

9

10

5

LEN

LEFT

AVG

JOIN

SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');

SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');

SELECT NAME IN CUSTOMER WHERE STATE = 'V';

SELECT NAME IN CUSTOMER WHERE STATE = 'VA';

report

table

form

file