MIS 380 FINAL Questions and Correct Answers/ Latest Update / Already Graded

Page |1


MIS 380 FINAL Questions and Correct
Answers/ Latest Update / Already Graded
What are aggregate functions?

Ans: Count, Avg, Max, Min, Sum


Which of the following lists gives the order of execution of an SQL
Statement by the DBMS?



a. FROM, WHERE, SELECT

b. FROM, SELECT, WHERE

c. WHERE FROM SELECT

d. SELECT FROM WHERE

Ans: a. FROM, WHERE, SELECT


Which of the following aggregate functions only work on numeric
columns?



SUM, COUNT, MAX, MIN, AVG

Ans: SUM & AVG



All rights reserved © 2025/ 2026 |

, Page |2

In a conditional statement in the WHERE clause, which of the following
statements is the correct way to test for 'boots' and heels' ?

Ans: 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 & the ____clause

Ans: FROM clause & WHERE clause


Which of the following aggregate functions CANNOT work on
computed fields?



Sum, Count, Avg, min, max

Ans: COUNT




All rights reserved © 2025/ 2026 |