INTRODUCTION TO SQL QUIZ

Strings

Dates

All of these

Column Alias

the same as 0 for integer

the same as 0 for integer and blank for character

not a value

the same as blank for character

SELECT name, course_name FROM student WHERE age>50 and <80;

None of these

SELECT name, course_name FROM student WHERE age>50 and WHERE age<80;

SELECT name, course_name FROM student WHERE age>50 and age <80;

True

False

True

False

DISTINCT

UNIQUE

DIFFERENT

DISTINCTIVE

SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND COUNT(r1.bid) > r2.bid

SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND r1.sid = r2.sid AND r1.bid ≠ r2.bid

All of these

SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND r1.sid = r2.sid AND r1.bid <> r2.bid

underscore(_); question mark (?)

percent sign (%); underscore (_)

question mark (?); asterisk (*)

asterisk (*); percent sign (%)

SELECT SYSDATE - (SYSDATE + 2) FROM DUAL;

None of these

SELECT SYSDATE - SYSDATE FROM DUAL;

SELECT SYSDATE - (SYSDATE - 2) FROM DUAL;

False

True