Devry CIS 336 Week 6 Quiz Latest

Description

Devry CIS 336 Week 6 Quiz Latest 

Devry CIS336 Week 6 Quiz Latest

1. 1.Question : (TCO 7) Which is NOT an aggregate function?

SUM

COUNT

ROUND

MAX

Question 2. Question : (TCO 7) Which of the following statements is correct?

WHERE operates on groups formed by aggregate functions and HAVING operates on individual rows.

WHERE can only be used along with HAVING.

HAVING can only be used along with WHERE.

WHERE operates on individual rows and HAVING operates on groups formed by aggregate functions.

Question 3. Question : (TCO 7) Given the books table described below, which of the following will display the date of the book with the earliest publication date?

books: bookid(PK), ISBN, title, pubdate, cost, retail, category, pubid(FK)

SELECT MIN(pubdate) FROM books;

SELECT title FROM books WHERE pubdate = MIN(pubdate);

SELECT title FROM books WHERE pubdate < MIN(pubdate);

SELECT pubdate from books WHERE MIN(pubdate) IS NOT NULL;

Question 4. Question : (TCO 7) Given the books table described below, which of the following will display the title and retail price of books that are priced higher than the average retail price of all books?

books: bookid(PK), ISBN, title, pubdate, cost, retail, category, pubid(FK)

SELECT title, retail FROm books WHERE retail IN (SELECT AVG(retail) FROM books);

SELECT title, retail FROM books WHERE retail > (SELECT AVG(retail) FROM books);

SELECT title, retail FROM books WHERE retail > AVG(retail);

SELECT title, AVG(retail) FROM books;

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

WHERE vendorid = (subquery)

A single value

A column of one or more rows

A table

A subquery can’t be used in this way.

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

Correlated

Uncorrelated

Inner

Outer

Question 7. Question : (TCO 7) Given the two tables described below, which of the following queries will display the names of the customers with orders shipped after December 1, 2014?

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

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

SELECT lastname, firstname FROM customer WHERE customerid = (SELECT customerID FROM order WHERE shipdate > ‘2014-01-12’);

SELECT lastname, firstname FROM customer WHERE customerid = (SELECT customerID FROM order WHERE shipdate < ‘2014-01-12’);

SELECT lastname, firstname FROM customer WHERE customerid = (SELECT customerID FROM order WHERE shipdate > ‘2014-12-01’);

SELECT lastname, firstname FROM customer WHERE customerid = (SELECT customerID FROM order WHERE shipdate < ‘2014-12-01’);

Question 8. Question : (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)

SELECT customerid, COUNT(customerid) FROM order;

SELECT customerid, COUNT(ordered) FROM order;

SELECT customerid, COUNT(orderid) FROM order GROUP BY customerid;

SELECT customerid, COUNT(orderid) FROM order GROUP BY orderid;

Question 9. Question : (TCO 7) Given the books table described below, which of the following will display each category along with the average retail price of books in that category?

books: bookid(PK), ISBN, title, pubdate, cost, retail, category, pubid(FK)

SELECT AVG(retail) FROM books;

SELECT category, AVG(retail) FROM books GROUP BY category:

SELECT category, AVG(retail) FROM books HAVING category;

SELECT category, SUM(retail) FROM books GROUP BY category;

Question 10. Question : (TCO 7) The expression below will be TRUE for what values of x?

x > ALL(5, 9)

5 and below

5 to 9

5 and above

9 and above

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

Devry CIS 336 Week 6 Quiz Latest