Data Information Management Quiz 3.doc...
Data___Information_Management_Quiz_3.docx.pdf-Which aggregate function returns a count
Showing 1-5 out of 10
Data Information Management Quiz 3.docx.pdf-Whic...
Data___Information_Management_Quiz_3.docx.pdf-Which aggregate function returns a count
Data Information Management Quiz ...
Data___Information_Management_Quiz_3.docx.pdf-Which aggregate function returns a count
Page 1
Which aggregate function returns a count of all non-null values returned by a value
expression? (Points : 2)
COUNT(*)
COUNT(value expression)
SUM(value expression)
MAX(value expression)
Which aggregate function does not disregard NULL values? (Points : 2)
COUNT(*)
SUM
MIN
MAX
When using an aggregate function, what is the name of the column in the final result set?
(Points : 2)
The column has no name.
The name is generated by the database system.
The name assigned in the AS clause.


Page 2
All of these are possible names for the column.
None of these are possible names for the column.
The SQL standard provides a set of
functions that enable you to calculate a
single value from the rows in a result set or from the values returned by a value expression
(Points : 2)
mathematical
calculation
summary
aggregate
When the GROUP BY clause is used without aggregate functions it will give you the same
result as what keyword? (Points : 2)
FROM
HAVING
WHERE
DISTINCT
Grouping data with aggregate functions enables you to see
for categories of
data. (Points : 2)


Page 3
subtotals
individual values
grand tota
What character is used to separate the columns referenced in the GROUP BY clause? (Points :
2)
Colon :
Semicolon ;
Comma ,
Period .
When using multiple tables, which clause enables you to include data that does not match
across tables? (Points : 2)
INNER JOIN
HAVING
OUTER JOIN
WHERE
Which aggregate function can be used with grouped data? (Points : 2)


Page 4
COUNT(*)
MAX()
SUM()
None of these aggregate functions work with grouped data.
All of these aggregate functions work with grouped data.
Filters that use a predicate on an aggregate function must be placed in what clause? (Points :
2)
WHERE
GROUP BY
HAVING
FROM
Columns referenced in the HAVING clause must also be referenced where? (Points : 2)
In the GROUP BY clause
Enclosed within an aggregate function
Either in the GROUP BY clause or enclosed within an aggregate function
Neither in the GROUP BY clause nor enclosed within an aggregate function


Page 5
Columns referenced in the WHERE clause must be a part of what? (Points : 2)
Tables defined in the FROM clause.
The columns referenced in the SELECT clause.
The columns used in aggregate functions.
The columns referenced in the ORDER BY clause.
When you want to group only a subset of rows you should eliminate rows first in what clause?
(Points : 2)
SELECT
FROM
WHERE
HAVING
Which of the following is a method to ensure only the desired rows will be updated? (Points :
2)
Call in an outside consultant whenever an update is needed.
First, write a SELECT statement to select the rows you want updated, and then transfer
the WHERE clause to the UPDATE statement.
Have the same person always perform updates.
What keyword is used to undo the changes that were made during a transaction? (Points : 2)


Ace your assessments! Get Better Grades
Browse thousands of Study Materials & Solutions from your Favorite Schools
Texas A %26 M University-...
Texas_A_%26_M_University-Corpus_Christi
School:
Data_Management
Course:
Great resource for chem class. Had all the past labs and assignments
Leland P.
Santa Clara University
Introducing Study Plan
Using AI Tools to Help you understand and remember your course concepts better and faster than any other resource.
Find the best videos to learn every concept in that course from Youtube and Tiktok without searching.
Save All Relavent Videos & Materials and access anytime and anywhere
Prepare Smart and Guarantee better grades

Students also viewed documents