Introduction to SQL
Which of the following query finds the total rating of the sailors who have reserved boat "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
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

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The wildcard in a WHERE clause is useful when?

An exact match is not possible in a SELECT statement.
An exact match is necessary in a SELECT statement.
An exact match is not possible in a CREATE statement.
An exact match is necessary in a CREATE statement.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
A view is which of the following?

A base table that cannot be accessed via SQL commands
A virtual table that cannot be accessed via SQL commands
A base table that can be accessed via SQL commands
A virtual table that can be accessed via SQL commands

ANSWER DOWNLOAD EXAMIANS APP