Introduction to SQL
Which of the following query finds the total rating of the sailors who have reserved boat "103"?

c) SELECT COUNT(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103
SELECT SUM(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103
SELECT SUM(s.rating) FROM sailors s, reserves r AND r.bid = 103;
SELECT s.rating FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
What is a view?

A view is a database diagram.
None of these
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.
A view is a special stored procedure executed when certain event occurs.

ANSWER DOWNLOAD EXAMIANS APP