Introduction to SQL Which of the following do you need to consider when you make a table in SQL? Primary keys Data types Default values All of these Primary keys Data types Default values All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following query finds colors of boats reserved by "Dustin"? SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND r.bid = b.bid SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid AND r.bid = b.bid; SELECT DISTINCT b.color FROM boats b, sailors s WHERE s.sname = 'Dustin' AND s.sid = b.sid SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND r.bid = b.bid SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid AND r.bid = b.bid; SELECT DISTINCT b.color FROM boats b, sailors s WHERE s.sname = 'Dustin' AND s.sid = b.sid ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword(s) ________ is used with wildcards. IN and NOT IN NOT IN only IN only LIKE only IN and NOT IN NOT IN only IN only LIKE only ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 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) 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) SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL is a programming language. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following query is correct for using comparison operators in SQL? 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; 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; SELECT name, course_name FROM student WHERE age>50 and <80; None of these ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS