(TCO 7) The explicit join syntax is defined as _____.

Group of answer choices

NATURAL JOIN

JOIN ON

JOIN USING

WHERE clause

Question 2 3 pts

(TCO 7) The number of conditions required to join X tables would be _____.

Group of answer choices

X

X + 1

X - 1

X * X

Question 3 3 pts

(TCO 7) Given the two tables described below, which of the following JOIN queries (if any) is not correct? customer: customerid(PK), lastname, firstname order: orderid(PK), orderdate, customerid(FK)

Group of answer choices

SELECT lastname, orderdate from customer JOIN order ON customer.customerid = order.orderid;

SELECT lastname, orderdate from customer JOIN order USING (customerid);

SELECT lastname, orderdate from customer NATURAL JOIN order;

All of the above

Question 4 3 pts

(TCO 7) If you assign an alias to one table in a join, you have to

Group of answer choices

assign them to all of the tables.

use that alias to refer to the table throughout your query.

qualify every column name in the query.

All of the above

Question 5 3 pts

(TCO 7) A left join returns

Group of answer choices

rows in the left table that dont satisfy the join condition.

unmatched rows from both the left and right tables.

rows in the right table that dont satisfy the join condition.

the Cartesian product of the two tables.

Question 6 3 pts

(TCO 7) When you use the USING keyword for a join

Group of answer choices

the join cannot be an outer join.

the join cannot be based on more than one column.

the join must be based on a column or columns that have the same name in both tables.

the join must be an inner join.

Question 7 3 pts

(TCO 7) Consider the ERD below. Which query would return the customer first and last name along with orderdate of each order they placed?

Group of answer choices

SELECT firstname, lastname, orderdate FROM customer, order;

SELECT firstname, lastname, orderdate FROM customer JOIN order WHERE customer.customerid = order.customerid;

SELECT firstname, lastname, orderdate FROM customer JOIN order ON customer.customerid = order.orderid;

SELECT firstname, lastname, orderdate FROM customer JOIN order ON customer.customerid = order.customerid;

Question 8 3 pts

(TCO 7) Consider the ERD below. Which query will return the firstname and lastname of customers who have placed an order for any product with keyboard in the description?

Group of answer choices

SELECT firstname, lastname from customer, product WHERE description LIKE %keyboard%;

SELECT firstname, lastname from customer, order, product WHERE description LIKE %keyboard%;

SELECT firstname, lastname from customer JOIN order ON customer.customerID = order.customerID JOIN OrderLine ON order.orderID = OrderLine.orderID JOIN Product ON OrderLine.productID = Product.productID WHERE description LIKE %keyboard%;

SELECT firstname, lastname from customer JOIN order ON customer.customerID = order.customerID JOIN OrderLine ON order.orderID = OrderLine.orderID WHERE description LIKE %keyboard%;

Question 9 3 pts

(TCO 7) Consider the ERD below. What tables will be needed to create a report showing the orderid and date of any orders with products having a price more than $50?

Group of answer choices

order only

order, orderline, product

order, product only

product only

Question 10 3 pts

(TCO 7) Consider the ERD below. Note that there are some products produced in-house that do not require a vendor, thus their vendorID is NULL. Also note that not all vendors currently supply products. Which query would be used to generate a report showing vendorname and productname, and will include ALL products even if they do not currently have a vendor?

Group of answer choices

SELECT vendorname, productname FROM vendor LEFT JOIN product;

SELECT vendorname, productname FROM vendor RIGHT JOIN product;

SELECT vendorname, productname FROM vendor LEFT JOIN product ON vendor.vendorID = product.vendorID;

SELECT vendorname, productname FROM vendor RIGHT JOIN product ON vendor.vendorID = product.vendorID;