CIS336 Week 5 Quiz – Study Guide – Instant Delivery

Lab Price = $10
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

1. (TCO 7) The explicit join syntax is defined as _____. (Points : 3)
NATURAL JOIN
JOIN ON
JOIN USING
WHERE clause
Question 2. 2. (TCO 7) If Table A, which contains five rows is joined to Table B, which has eight rows without a valid join condition, the resulting cartesian product would have _____ rows. (Points : 3)
five
eight
13
40

Question 3. 3. (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) (Points : 3)
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, order WHERE customer.customerid = order.customerid;
All of the above
(All of the above are correct)

Question 4. 4. (TCO 7) If you assign an alias to one table in a join, you have to (Points : 3)
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. 5. (TCO 7) A right join returns (Points : 3)
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. 6. (TCO 7) When you use the USING keyword for a join (Points : 3)
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. 7. (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?

question7




(Points : 3)
One
Two
Three
Four

Question 8. 8. (TCO 7) Consider the ERD below. Which query will return the first and last name of each customer whose order was placed after January 1, 2014?
question8






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

Question 9. 9. (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?

question9





(Points : 3)
order only
order, orderline, product
order, product only
product only

Question 10. 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 products even if they do not currently have a vendor?

question10




(Points : 3)
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;

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 = $10
Please feel free to send us your queries at: support@iqrajavaid.com

Payment methods

Add to Cart

Buy Now

View Cart