Which of the following query finds the name of the sailors who have reserved at least two boats?

Introduction to SQL
Which of the following query finds the name of the sailors who have reserved at least two boats?

SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND r1.sid = r2.sid AND r1.bid ≠ r2.bid

All of these

SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND r1.sid = r2.sid AND r1.bid <> r2.bid

SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND COUNT(r1.bid) > r2.bid

SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND r1.sid = r2.sid AND r1.bid ≠ r2.bid

All of these

SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND r1.sid = r2.sid AND r1.bid <> r2.bid

SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND COUNT(r1.bid) > r2.bid

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The SQL statement that queries or reads data from a table is ________ .

SELECT

QUERY

READ

None of these

SELECT

QUERY

READ

None of these

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE);prints

0

10

9

5

0

10

9

5

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Let the statementSELECT column1 FROM myTable;return 10 rows. The statementSELECT ALL column1 FROM myTable;will return

exactly 10 rows

less than 10 rows

None of these

more than 10 rows

exactly 10 rows

less than 10 rows

None of these

more than 10 rows

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value.

True

False

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.

False

True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL

Introduction to SQL Which of the following query finds the name of the sailors who have reserved at least two boats?

Introduction to SQL The SQL statement that queries or reads data from a table is ________ .

Introduction to SQL Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE);prints

Introduction to SQL Let the statementSELECT column1 FROM myTable;return 10 rows. The statementSELECT ALL column1 FROM myTable;will return

Introduction to SQL Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value.

Introduction to SQL The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.

Introduction to SQL
Which of the following query finds the name of the sailors who have reserved at least two boats?

Introduction to SQL
The SQL statement that queries or reads data from a table is ________ .

Introduction to SQL
Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE);prints

Introduction to SQL
Let the statementSELECT column1 FROM myTable;return 10 rows. The statementSELECT ALL column1 FROM myTable;will return

Introduction to SQL
Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value.

Introduction to SQL
The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.