1. (TCO 7) The implicit inner join syntax is defined as _____. (Points : 3) NATU

Question

1. (TCO 7) The implicit inner join syntax is defined as _____. (Points : 3)        NATURAL JOIN
       JOIN ON
       JOIN USING
       WHERE clause

       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;

Question 2. 2. (TCO 7) To join four tables would require _____ join conditions. (Points : 3)        4
       3
       2
       Cannot tell without an ERD.

Explanation / Answer

Question 2.2

2

Question 3.3

SELECT lastname, orderdate from customer, orders;

Quetion 4.4

   when the same column names exist in both tables.

Question 5,5

   rows in the right table that don’t satisfy the join condition.

Question 6.6

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

Question 7.7

Two

Question 8,8

   SELECT firstname, lastname from customer JOIN order USING (customerID) WHERE orderdate > ‘2014-01-01’;

Question 9.9

    SELECT orderID, orderdate from order JOIN OrderLine ON order.orderID = OrderLine.orderID JOIN Product ON OrderLine.productID = Product.productID WHERE price > 50;

Question 10.10

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

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.