INTRODUCTION TO SQL QUIZ

ADD

MAKE

CREATE

INSERT

True

False

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

None of These

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

asterisk (*); percent sign (%)

question mark (?); asterisk (*)

underscore(_); question mark (?)

percent sign (%); underscore (_)

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' AND temperature > 70;

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

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');

prints 045.926

prints 50

prints garbage

is illegal

True

False

False

True

None of these

A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are.

A view is a special stored procedure executed when certain event occurs.

A view is a database diagram.