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

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

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
A view is which of the following?

A virtual table that cannot be accessed via SQL commands
A base 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

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

ANSWER DOWNLOAD EXAMIANS APP