MIS 380 QUIZES 5-7 QUESTIONS AND CORRECT DETAILED
ANSWERS (VERIFIED ANSWERS) |ALREADY GRADED
A+||BRAND NEW
Which of the following functions are NOT aggregate functions. (check
all that apply) Ans✓✓✓Abs() and Len()
What are the 5 aggregate functions? Ans✓✓✓Max(), Min(), Avg(),
Sum(), and Count()
Which of the following lists gives the order of execution of an SQL
statement by the DBMS? Ans✓✓✓FROM, WHERE, SELECT
Which aggregate functions only work on numeric columns?
Ans✓✓✓AVG() and SUM()
In a conditional statement in the WHERE clause, which of the following
statements is the correct way to test for 'boots' and 'heels'? (check all that
apply) Ans✓✓✓WHERE category = 'boots' OR category = 'heels'
What are the three most common SQL Clauses? Ans✓✓✓SELECT,
FROM, WHERE
The keyword "distinct" is used to do what? Ans✓✓✓Eliminate duplicate
rows
, The two clauses that can be used to describe JOIN conditions are the ___
clause and the ____ clause. Ans✓✓✓FROM and WHERE
Which aggregate functions CANNOT work on computed fields.
Ans✓✓✓COUNT()
Aggregate functions operate on what (what operands)? Ans✓✓✓Values
across multiple rows
Aggregate functions can appear in which clauses of an SQL query?
Ans✓✓✓SELECT, HAVING
Which of the following pairs of comparison operators is equivalent to
the BETWEEN operator? Ans✓✓✓>= and <=
Which of the following lists includes items that can be included in the
FROM clause? (check all that apply) Ans✓✓✓Table names, View
names, and Subqueries
By adding the GROUP BY clause to a query, the following statement(s)
is/are true. Ans✓✓✓The query is changed from rows to groups
What is meant when a text field contains a null value? Ans✓✓✓The
field has an undetermined data value
ANSWERS (VERIFIED ANSWERS) |ALREADY GRADED
A+||BRAND NEW
Which of the following functions are NOT aggregate functions. (check
all that apply) Ans✓✓✓Abs() and Len()
What are the 5 aggregate functions? Ans✓✓✓Max(), Min(), Avg(),
Sum(), and Count()
Which of the following lists gives the order of execution of an SQL
statement by the DBMS? Ans✓✓✓FROM, WHERE, SELECT
Which aggregate functions only work on numeric columns?
Ans✓✓✓AVG() and SUM()
In a conditional statement in the WHERE clause, which of the following
statements is the correct way to test for 'boots' and 'heels'? (check all that
apply) Ans✓✓✓WHERE category = 'boots' OR category = 'heels'
What are the three most common SQL Clauses? Ans✓✓✓SELECT,
FROM, WHERE
The keyword "distinct" is used to do what? Ans✓✓✓Eliminate duplicate
rows
, The two clauses that can be used to describe JOIN conditions are the ___
clause and the ____ clause. Ans✓✓✓FROM and WHERE
Which aggregate functions CANNOT work on computed fields.
Ans✓✓✓COUNT()
Aggregate functions operate on what (what operands)? Ans✓✓✓Values
across multiple rows
Aggregate functions can appear in which clauses of an SQL query?
Ans✓✓✓SELECT, HAVING
Which of the following pairs of comparison operators is equivalent to
the BETWEEN operator? Ans✓✓✓>= and <=
Which of the following lists includes items that can be included in the
FROM clause? (check all that apply) Ans✓✓✓Table names, View
names, and Subqueries
By adding the GROUP BY clause to a query, the following statement(s)
is/are true. Ans✓✓✓The query is changed from rows to groups
What is meant when a text field contains a null value? Ans✓✓✓The
field has an undetermined data value
