CIS336 Week 5 Quiz New (2019) – 100% Score – Study Guide – Perfect Solution

Lab Price = $5
Please feel free to send us your queries at: support@iqrajavaid.com
P.S: This is just a study guide. The questions may not appear exactly like this.
Payment methods

Add to Cart

Buy Now

View Cart


Problem Statement
Question 1

(TCO 7) The _____ condition is generally composed of an equality comparison between the primary key and foreign key of related tables.
1. select
2. view
3. join
4. from

Question 2

(TCO 7) The number of conditions required to join X tables would be _____.
1. X
2. X + 1
3. X – 1
4. X * X

Question 3

(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)
1. SELECT lastname, orderdate from customer JOIN order ON customer.customerid = order.customerid;
2. SELECT lastname, orderdate from customer JOIN order USING (customerid);
3. SELECT lastname, orderdate from customer, orders;
4. All of the above

Question 4

(TCO 7) In a join, column names need to be qualified only
1. in inner joins.
2. in outer joins.
3. when the code is confusing.
4. when the same column names exist in both tables.

Question 5

(TCO 7) A full outer join returns
1. rows in the left table that don’t satisfy the join condition.
2. unmatched rows from both the left and right tables.
3. rows in the right table that don’t satisfy the join condition.
4. the Cartesian product of the two tables.

Question 6

(TCO 7) Which of the following can be used to join two tables that do not have a commonly named column?
1. NATURAL JOIN
2. JOIN … USING
3. JOIN … ON
4. OUTER JOIN

Question 7

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

1. SELECT firstname, lastname, orderdate FROM customer, order;
2. SELECT firstname, lastname, orderdate FROM customer JOIN order WHERE customer.customerid = order.customerid;
3. SELECT firstname, lastname, orderdate FROM customer JOIN order ON customer.customerid = order.orderid;
4. SELECT firstname, lastname, orderdate FROM customer JOIN order ON customer.customerid = order.customerid;

Question 8

(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?
CIS336_QUIZ5_Q7_Q8_Q9

1. customer, product only
2. customer, order, product only
3. customer, orderline only
4. customer, order, orderline, product

Question 9

(TCO 7) Consider the ERD below. What query will return the orderid and date of any orders with products having a price more than $50?
CIS336_QUIZ5_Q7_Q8_Q9

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

Question 10

(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?

CIS336_QUIZ5_Q10

1. SELECT vendorname, productname FROM vendor LEFT JOIN product;
2. SELECT vendorname, productname FROM vendor RIGHT JOIN product;
3. SELECT vendorname, productname FROM vendor LEFT JOIN product ON vendor.vendorID = product.vendorID;
4. SELECT vendorname, productname FROM vendor RIGHT JOIN product ON vendor.vendorID = product.vendorID;

Relevant Material
Instructions
* If you want to purchase multiple products then click on “Buy Now” button which will give you ADD TO CART option.Please note that the payment is done through PayPal.
* You can also use 2CO option if you want to purchase through Credit Cards/Paypal but make sure you put the correct billing information otherwise you wont be able to receive any download link.
* Your paypal has to be pre-loaded in order to complete the purchase or otherwise please discuss it with us at support@iqrajavaid.com.
* As soon as the payment is received, download link of the solution will automatically be sent to the address used in selected payment method.
* Please check your junk mails as the download link email might go there and please be patient for the download link email. Sometimes, due to server congestion, you may receive download link with a delay.
* All the contents are compressed in one zip folder.
* In case if you get stuck at any point during the payment process, please immediately contact us at support@iqrajavaid.com and we will fix it with you.
* We try our best to reach back to you on immediate basis. However, please wait for atleast 8 hours for a response from our side. Afterall, we are humans.
* Comments/Feedbacks are truely welcomed and there might be some incentives for you for the next lab/quiz/assignment.
* In case of any query, please donot hesitate to contact us at support@iqrajavaid.com.
* MOST IMPORTANT Please use the tutorials as a guide and they need NOT to be used for any submission. Just take help from the material.
******************************************** Good Luck ***************************************************
Privacy Policy
We take your privacy seriously and will take all measures to protect your personal information.
Any personal information received will only be used to fill your order. We will not sell or redistribute your information to anyone.
Refund Policy
Incase you face any issues with the tutorial, please free to contact us on support@iqrajavaid.com
We will try our best to resolve the issue and if still persists we can discuss for a refund in case its required.
Lab Price = $5
Please feel free to send us your queries at: support@iqrajavaid.com

Payment methods

Add to Cart

Buy Now

View Cart

Leave a Reply