INTRODUCTION TO SQL QUIZ

SELECT NAME IN CUSTOMER WHERE STATE = 'VA';

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

SELECT NAME IN CUSTOMER WHERE STATE = 'V';

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

None of these

SELECT Username, Password WHERE Username = 'user1'

SELECT Username, Password FROM Users

SELECT Username AND Password FROM Users

True

False

False

True

DELETE

COMMIT

TRUNCATE

ROLLBACK

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' AND temperature > 70;

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' OR temperature > 70;

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' AND temperature > 70;

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' OR temperature > 70;

Find the sailor IDs of all sailors who have reserved red boats but not green boats

Find the sailor Ids of atmost one sailor who have reserved red boats but not green boats

None of These

Find the sailor IDs of at least one sailor who have reserved red boats but not green boats

Microsoft Access

DBase

SQL

Oracle

True

False

SELECT SUM(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103

SELECT SUM(s.rating) FROM sailors s, reserves r AND r.bid = 103;

c) SELECT COUNT(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103

SELECT s.rating FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103