Introduction to SQL
Find all the tuples having temperature greater than 'Paris'.

SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = 'Paris')
SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = 'Paris')
SELECT * FROM weather WHERE temperature > 'Paris' temperature
SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = 'Paris')

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
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

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
What is a view?

A view is a special stored procedure executed when certain event occurs.
A view is a database diagram.
A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are.
None of these

ANSWER DOWNLOAD EXAMIANS APP
MORE MCQ ON Introduction to SQL