Introduction to SQL
Which of the following is illegal?

SELECT SYSDATE - (SYSDATE + 2) FROM DUAL;
None of these
SELECT SYSDATE - SYSDATE FROM DUAL;
SELECT SYSDATE - (SYSDATE - 2) FROM DUAL;

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

ANSWER DOWNLOAD EXAMIANS APP