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

Lab Price = \$5
P.S: This is just a study guide. The questions may not appear exactly like this.
Payment methods

Problem Statement

Question 1

(TCO 7) Which is NOT an aggregate function?
1. SUM
2. COUNT
3. ROUND
4. MAX

Question 2
(TCO 7) If your SELECT clause contains both aggregate and nonaggregate functions, _____.
1. all nonaggregate columns must be included in a WHERE clause
2. all nonaggregate columns must be included in a GROUP BY clause
3. all aggregate and non-aggregate columns must be included in a GROUP BY clause
4. all aggregate columns must be included in a WHERE clause

Question 3
(TCO 7) Given the books table described below, which of the following will display the number of different categories contained in the books table?
books: bookid(PK), ISBN, title, pubdate, cost, retail, category, pubid(FK)

1. SELECT DISTINCT category COUNT(*) FROM books;
2. SELECT COUNT(category) FROM books GROUP BY category;
3. SELECT DISTINCT (COUNT(category)) FROM books;
4. SELECT COUNT(DISTINCT category) FROM books;

Question 4
(TCO 7) Given the books table described below, which of the following will list retail price of the most expensive book in the COMPUTER category?
books: bookid(PK), ISBN, title, pubdate, cost, retail, category, pubid(FK)
1. SELECT MAX(retail) FROM books GROUP BY category;
2. SELECT MAX(retail) FROM books WHERE category = ‘COMPUTER’;
3. SELECT MAX(retail) FROM books HAVING category = ‘COMPUTER’;
4. SELECT retail FROM (SELECT MAX(retail) FROM books);

Question 5
(TCO 7) Which of the values listed below can be returned by a subquery referenced as follows?
WHERE vendorid = (subquery)

1. A single value
2. A column of one or more rows
3. A table
4. A subquery can’t be used in this way.

Question 6

(TCO 7) What type of subquery is executed once for each row processed by the main query?

1. Correlated
2. Uncorrelated
3. Inner
4. Outer

Question 7
(TCO 7) Given the two tables described below, which of the following queries will display the names of the customers whose orders have not shipped?
customer: with the fields customerid(PK), lastname, firstname
order: with the fields orderid(PK), orderdate, shipdate, customerid(FK)
1. SELECT lastname, firstname FROM customer WHERE customerid = (SELECT customerID FROM order WHERE shipdate = orderdate);
2. SELECT lastname, firstname FROM customer WHERE customerid = (SELECT customerid FROM order WHERE orderid IS NULL);
3. SELECT lastname, firstname FROM customer WHERE customerid = (SELECT customerid FROM order WHERE shipdate IS NULL);
4. SELECT lastname, firstname FROM customer WHERE customerid = (SELECT customerid FROM order WHERE shipdate IS NOT NULL);

Question 8
(TCO 7) Given the two tables described below, which of the following queries will display each customerid along with the number of orders placed by that customer?
customer: with the fields customerid(PK), lastname, firstname
order: with the fields orderid(PK), orderdate, shipdate, customerid(FK)
1. SELECT customerid, COUNT(customerid) FROM order;
2. SELECT customerid, COUNT(ordered) FROM order;
3. SELECT customerid, COUNT(orderid) FROM order GROUP BY customerid;
4. SELECT customerid, COUNT(orderid) FROM order GROUP BY orderid;

Question 9
(TCO 7) Given the books table described below, which of the following will display the average retail price of books?
books: bookid(PK), ISBN, title, pubdate, cost, retail, category, pubid(FK)
1. SELECT COUNT(retail) FROM books;
2. SELECT SUM(retail) FROM books;
3. SELECT AVG(retail) FROM books;
4. SELECT AVG(retail) FROM books GROUP BY category;

Question 10
(TCO 7) The expression below will be TRUE for what values of x?
x > ALL(5, 9)
1. 5 and below
2. 5 to 9
3. 5 and above
4. 9 and above

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.
* 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.