INDUCTORS QUIZ

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 country FROM location WHERE city IN (SELECT city FROM weather WHERE condition = sunny');

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

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

SELECT country FROM location WHERE condition = 'sunny';

asterisk (*); percent sign (%)

underscore(_); question mark (?)

percent sign (%); underscore (_)

question mark (?); asterisk (*)

True

False

False

True

Selection operation.

Rename operation.

Projection operation.

Join operation.

SELECT city WHERE humidity = 89;

SELECT humidity = 89 FROM weather;

SELECT city FROM weather;

SELECT city FROM weather WHERE humidity = 89;

specify range for search condition

specify what table we are selecting or deleting data FROM

specify search condition

None of these

Applications are not needed

All of these

Increased dependence on a single vendor

Reduced training costs

SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79

SELECT * FROM weather WHERE humidity IN (63 to 79)

SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79

SELECT * FROM weather WHERE humidity NOT IN (63 AND 79)