Ch 4

Question 1

Which of the following is used to restrict rows is SQL?

Answer 1

Where

Question 2

Which of the following are non-commercial open-source database management systems? I. MS SQL Server II. MongoDB III. Oracle

Answer 2

II only

Question 3

Suppose there are two tables: A and B. What would the following code output? SELECT * from A RIGHT JOIN B on A.orderid = B.orderid

Answer 3

the complete set of records from table B, along with the matching records (depending on the availability) from table A where tables A and B have the same orderid

Question 4

Suppose there are two tables: A and B. What would the following code output? SELECT * from A LEFT JOIN B on A.orderid = B.orderid;

Answer 4

the complete set of records from table A, along with the matching records (depending on the availability) from table B where tables A and B have the same orderid

Question 5

Suppose there are two tables: A and B. What would the following code output? SELECT * from A INNER JOIN B on A.orderid = B.orderid;

Answer 5

only the records from both tables A and B where tables A and B have the same orderid

Question 6

What is the function COUNT() used for?

Answer 6

to return the number of rows that match a specified criteria

Question 7

Which of the following is not a type of join?

Answer 7

FULLER INNER JOIN

Question 8

Which of the following does a relational database not contain?

Answer 8

ID Graphs

Question 9

Which of the following includes matched records from the right table and all records from the left table?

Answer 9

LEFT JOIN

Question 10

Which join uses records that have matching values in both tables?

Answer 10

INNER JOIN