WorksheetsISPFL6 - Final - Quiz 1
Total questions: 30
Worksheet time: 15mins
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()
What does the SQL LIKE operator do?
Matches exact values
Matches similar values based on a specified pattern
Matches NULL values
Matches values within a given range
SQL aliases are useful for:
Shortening SQL queries
Providing alternate names for columns or tables
Joining tables together
Ordering query results
Which SQL function returns the average value of a numerical column?
AVG()
MIN()
MAX()
SUM()
The SQL BETWEEN operator selects values:
Outside a given range
Within a given range
Above a specified value
Below a specified value
The SQL FETCH FIRST clause is similar to:
LIMIT
TOP
OFFSET
ORDER BY
The SQL LIKE operator is used to search for a specified pattern in a column.
True
False
The SQL MIN() function returns the largest value within a selected column.
True
False
SQL aliases are permanent names assigned to tables or columns.
True
False
The SQL IN operator allows you to specify multiple values in a WHERE clause.
True
False
The SQL BETWEEN operator selects values within a given range.
True
False
The SQL COUNT() function returns the total sum of a numerical column.
True
False
The SQL LIMIT clause is used to set a maximum number of rows to return in a result set.
True
False
The SQL MAX() function returns the smallest value within a selected column.
True
False
Wildcard characters are used to substitute one or more characters in a string.
True
False
The SQL FETCH FIRST clause is used to fetch the last row from a result set.
True
False
The SQL LIKE operator can be used with the NOT keyword to exclude rows that match a specified pattern.
True
False
The SQL AVG() function returns the average value of a numerical column.
True
False
The SQL IN operator is used to perform logical comparisons between two columns.
True
False
The SQL BETWEEN operator can be used to specify a range of dates.
True
False
SQL aliases are used to give a permanent name to a column or table.
True
False
