CIS 336 DeVry Week 5 Quiz Latest

Downloading is very simple, you can download this Course here:

http://wiseamerican.us/product/cis-336-devry-week-5-quiz-latest/

 

Or

Contact us at:

SUPPORT@WISEAMERICAN.US

CIS 336 DeVry Week 5 Quiz Latest

CIS336

CIS 336 DeVry Week 5 Quiz Latest

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

Question 2. Question : (TCO 7) To join four tables would require _____ join conditions.

  • 4
  • 3
  • 2
  • Cannot tell without an ERD.

Question 3. Question : (TCO 7) Given the two tables described below, which of the following JOIN queries (if any) is not correct?

customer: with the fields customerid(PK), lastname, firstname

order: with the fields orderid(PK), orderdate, customerid(FK)

  • SELECT lastname, orderdate from customer JOIN order ON customer.customerid = order.customerid;
  • SELECT lastname, orderdate from customer JOIN order USING (customerid);
  • SELECT lastname, orderdate from customer, orders;
  • All of the above

Question 4. Question : (TCO 7) In a join, column names need to be qualified only

  • in inner joins.
  • in outer joins.
  • when the code is confusing.
  • when the same column names exist in both tables.

Question 5. Question : (TCO 7) A left join returns

  • rows in the left table that don’t satisfy the join condition.
  • unmatched rows from both the left and right tables.
  • rows in the right table that don’t satisfy the join condition.
  • the Cartesian product of the two tables.

Question 6. Question : (TCO 7) When you use the USING keyword for a join

  • 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. Question : (TCO 7) Consider the ERD below. How many tables would be required to create a query to display the customer first and last name along with orderdate of each order they placed?

  • One
  • Two
  • Three
  • Four

Question 8. Question : (TCO 7) Consider the ERD below. What tables will be needed to create a report showing the firstname and lastname of customers who have placed an order for any product with keyboard in the description?

  • customer, product only
  • customer, order, product only
  • customer, orderline only
  • customer, order, orderline, product

Question 9. Question : (TCO 7) Consider the ERD below. What tables will be needed to create a report showing customer first and last name along with order date? The report should show all customers even if they have never placed an order.

  • SELECT firstname, lastname, orderdate from customer LEFT JOIN order;
  • SELECT firstname, lastname, orderdate FROM customer RIGHT JOIN order ON customer.customerid = order.customerid;
  • SELECT firstname, lastname, orderdate FROM customer JOIN order USING (customerID);
  • SELECT firstname, lastname, orderdate FROM customer LEFT JOIN order ON customer.customerid = order.customerid;

Question 10. Question : (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 vendors even if they do not currently supply any products?

  • 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;