Devry CIS 336 Week 5 Quiz Latest

Description

Devry CIS 336 Week 5 Quiz Latest 

Devry CIS336 Week 5 Quiz Latest

1. 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;

DeVry Courses helps in providing the best essay writing service. If you need 100% original papers for Devry CIS 336 Week 5 Quiz Latest , then contact us through call or live chat.

Devry CIS 336 Week 5 Quiz Latest