ISPFL6 - Final - Quiz 1

Which SQL clause is used to return the smallest value within a selected column?

• TOP

• MIN()

• LIMIT

• FETCH FIRST

The SQL LIKE operator is used in conjunction with which clause?

• GROUP BY

• ORDER BY

• WHERE

• HAVING

Which SQL clause is used to select values within a given range?

• RANGE

• BETWEEN

• RANGE BETWEEN

• IN

What SQL function returns the total sum of a numerical column?

• COUNT()

• AVG()

• SUM()

• MAX()

SQL aliases are used for:

• Giving names to databases

• Giving names to tables

• Giving names to columns

• Giving names to rows

The SQL IN operator is used to:

• Specify multiple values in a WHERE clause

• Join tables together

• Filter rows based on a condition

• Perform mathematical operations

Which wildcard character is used to substitute for a single character in a string?

• %

• _

• *

• $

What does the SQL COUNT() function return?

• The number of distinct values in a column

• The number of rows in a set

• The average value of a numerical column

• The smallest value within a selected column

The SQL LIMIT clause is used to:

• Set a maximum number of rows to return in a result set

• Set a minimum number of rows to return in a result set

• Order the result set in ascending order

• Filter rows based on a condition

Which SQL clause is used to return the largest value within a selected column?

• FETCH FIRST

• MAX()

• TOP

• SUM()