Introduction to SQL
Select the right statement to insert values to the student table.

INSERT VALUES INTO student (
INSERT student VALUES (
INSERT INTO student VALUES (
INSERT VALUES (

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following query is correct for using comparison operators in SQL?

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;

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 s.sid = r.sid AND r.bid = b.bid;
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, 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 s.sid = r.sid

ANSWER DOWNLOAD EXAMIANS APP