Introduction to SQL
The SQL -92 wildcards are ____ and ____ .

asterisk (*); percent sign (%)
underscore(_); question mark (?)
question mark (?); asterisk (*)
percent sign (%); underscore (_)

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
NULL is

not a value
the same as 0 for integer and blank for character
the same as 0 for integer
the same as blank for character

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following query finds the total rating of the sailors who have reserved boat "103"?

SELECT s.rating FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103
c) SELECT COUNT(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 WHERE s.sid = r.sid AND r.bid = 103
SELECT SUM(s.rating) FROM sailors s, reserves r AND r.bid = 103;

ANSWER DOWNLOAD EXAMIANS APP