Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

Week #12 Quiz - CIST1220-Structured Query Language-SQL

memorize.ai (lvl 286)

(0)

10 cards

()

Section 1

Preview this deck

The ____ function calculates the standard deviation for a specific set of data. A) STDDEVIATION B) STD C) STDDEV D) STANDARDDEV

Front

1 / 10

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

4 years ago

Date created

Mar 1, 2020

Cards (10)

Section 1

(10 cards)

The ____ function calculates the standard deviation for a specific set of data. A) STDDEVIATION B) STD C) STDDEV D) STANDARDDEV

Front

C) STDDEV

Back

The MAX function can be used with character data. A) True B) False

Front

A) True

Back

The SUM function can only be used with ____ data. A) numeric B) character C) date D) alphanumeric

Front

A) numeric

Back

If a SELECT statement contains HAVING, GROUP BY, and WHERE clauses, the ____ clause will be processed first. A) HAVING B) GROUP BY C) WHERE D) ORDER BY

Front

C) WHERE

Back

Functions that return one result per group of rows are called ____ functions. A) group B) multiple-row C) aggregate D) all of the above

Front

D) all of the above

Back

The HAVING clause specifies which groups will be displayed in the results, while the WHERE clause restricts the records that are retrieved from the table for processing. A) True B) False

Front

A) True

Back

A group function can be nested inside a(n)____. A) group function B) single-row function C) order function D) both a and b

Front

D) both a and b

Back

The ORDER BY clause is used to group data. A) True B) False

Front

B) False

Back

A(n) ____ clause cannot include a group function. A) WHERE B) HAVING C) SELECT D) both a and c

Front

A) WHERE

Back

Which of the following is a valid statement? A) A single-row function can be nested inside a group function. B) Group functions can be nested inside other group functions. C) Group functions can be nested inside single-row functions. D) all of the above

Front

D) all of the above

Back