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

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

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

Introduction to SQL
The SQL WHERE clause:

limits the row data are returned.

Neither A nor B are correct.

limits the column data that are returned.

Both A and B are correct.

limits the row data are returned.

Neither A nor B are correct.

limits the column data that are returned.

Both A and B are correct.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
In SQL, which command is used to change a table's storage characteristics?

None of these

CHANGE TABLE

MODIFY TABLE

ALTER TABLE

None of these

CHANGE TABLE

MODIFY TABLE

ALTER TABLE

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following SQL commands can be used to add data to a database table?

APPEND

UPDATE

ADD

INSERT

APPEND

UPDATE

ADD

INSERT

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find all the cities whose humidity is 89

SELECT city FROM weather;

SELECT city FROM weather WHERE humidity = 89;

SELECT city WHERE humidity = 89;

SELECT humidity = 89 FROM weather;

SELECT city FROM weather;

SELECT city FROM weather WHERE humidity = 89;

SELECT city WHERE humidity = 89;

SELECT humidity = 89 FROM weather;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.

True

False

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL

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

Introduction to SQL The SQL WHERE clause:

Introduction to SQL In SQL, which command is used to change a table's storage characteristics?

Introduction to SQL Which of the following SQL commands can be used to add data to a database table?

Introduction to SQL Find all the cities whose humidity is 89

Introduction to SQL Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.

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

Introduction to SQL
The SQL WHERE clause:

Introduction to SQL
In SQL, which command is used to change a table's storage characteristics?

Introduction to SQL
Which of the following SQL commands can be used to add data to a database table?

Introduction to SQL
Find all the cities whose humidity is 89

Introduction to SQL
Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.