INTRODUCTION TO SQL QUIZ

True

False

SELECT weather.city, temperature, humidity FROM weather SELECT country FROM location WHERE weather.city = location.city;

SELECT weather.city, temperature, humidity, country FROM weather, location WHERE weather.city = location.city;

SELECT city, temperature, humidity, country FROM location;

SELECT weather.city, temperature, humidity, country FROM weather, location;

TRUNCATE

COMMIT

DELETE

ROLLBACK

5

9

0

10

False

True

True

False

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

SELECT NAME IN CUSTOMER WHERE STATE = 'VA';

SELECT NAME IN CUSTOMER WHERE STATE = 'V';

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

SELECT country FROM location WHERE city NOT IN (SELECT city FROM weather WHERE condition = 'sunny');

SELECT country FROM location WHERE city IN (SELECT city FROM weather WHERE condition = sunny');

SELECT country FROM location WHERE condition = 'sunny';

SELECT country FROM location WHERE city UNION (SELECT city FROM weather WHERE condition = 'sunny');

DELETE FROM CUSTOMER WHERE ...

DROP FROM CUSTOMER ...

UPDATE FROM CUSTOMER ...

REMOVE FROM CUSTOMER ...

DBase

Oracle

Microsoft Access

SQL