Adv SQL Quiz

COUNT, AVG, SUM, MAX, and MIN are known as what?

• Aggregate Functions

• Calculated Field

• Wildcard Filters

• Joins

Which SQL function is used to find the average value of any column?

• Mean()

• AVG()

• SUM()

• AVERAGE()

The MAX() function returns the number of rows

• True

• False

A column named Score from Grade table

has values as 10, 12, 13, 15, 9, 10, 14, 15, 10, 15, 12.

Predict the output of the below query.

SELECT COUNT (Score) FROM Grade;

• 9

• 11

• 13

• 15

A column named Score from Grade table

has values as 10, 12, 13, 15, 9, 10, 14, 15, 10, 15, 12.

Predict the output of the below query.

SELECT MIN (Score) FROM Grade;

• 9

• 11

• 13

• 15

The GROUP BY statement is often used with aggregate functions to group the result-set by one or more columns.

• True

• False

Which is the correct order of clauses in a SELECT statement?

• SELECT

  FROM

  WHERE

  ORDER BY

  HAVING

  GROUP BY

• SELECT

  FROM

  HAVING

  GROUP BY

  WHERE

  ORDER BY

• SELECT

  FROM

  WHERE

  HAVING

  ORDER BY

  GROUP BY

• SELECT

  FROM

  WHERE

  GROUP BY

  HAVING

  ORDER BY

What is the difference between WHERE and HAVING?

• WHERE specifies a GEOGRAPHIC location for a database server

• HAVING only applies to aggregate functions like GROUP BY

• There are interchangeable

• WHERE has limited use

Which join would you use to create a query that returns ALL data from Table B and only those on Table A that match?

• INNER JOIN

• RIGHT JOIN

• LEFT JOIN

• NATURAL JOIN

The LEFT JOIN returns all the data rows from ___

• BOTH THE TABLES

• RIGHT SIDE TABLE

• LEFT SIDE TABLE

• NONE OF THE TABLES