Homework 4

Question 1

The Oracle —————– statement is used to add multiple rows with a single INSERT statement.

Answer 1

The Oracle INSERT ALL statement is used to add multiple rows with a single INSERT statement.

Question 2

Aggregate functions can appear in select lists with ———–, and ——— clauses.

Answer 2

Aggregate functions can appear in select lists with ORDER BY, and GROUP BY clauses.

Question 3

The Oracle DISTINCT clause is used to ————————— from the result set.

Answer 3

The Oracle DISTINCT clause is used to remove duplicates from the result set.

Question 4

An —————————- summarizes the results of an expression over a number of rows, returning a single value.

Answer 4

16) An aggregate function summarizes the results of an expression over a number of rows, returning a single value.

Question 5

—————- returns the number of rows.

Answer 5

COUNT returns the number of rows.

Question 6

18) The Oracle ——————– clause is used to sort the records in your result set.

Answer 6

18) The Oracle ORDER BY clause is used to sort the records in your result set.

Question 7

The ORDER BY and GROUP BY clauses can only be used in ———— statement.

Answer 7

The ORDER BY and GROUP BY clauses can only be used in SELECT statement.

Question 8

When more than one expression is provided in the DISTINCT clause, the query will retrieve ———————– for the expressions listed.

Answer 8

When more than one expression is provided in the DISTINCT clause, the query will retrieve unique combinations for the expressions listed.

Question 9

————— is a function which can be used to sum or total the values of a column.

Answer 9

SUM is a function which can be used to sum or total the values of a column.

Question 10

———— function returns the average value of an expression.

Answer 10

AVG function returns the average value of an expression.

Question 11

The Oracle —————– condition is used to retrieve values within a range in a where clause in a SELECT statement.

Answer 11

The Oracle BETWEEN condition is used to retrieve values within a range in a where clause in a SELECT statement.

Question 12

In a select query the —————— pseudocolumn returns a number indicating the order in which Oracle selects the row from a table or set of joined rows.

Answer 12

In a select query the ROWNUM pseudocolumn returns a number indicating the order in which Oracle selects the row from a table or set of joined rows.

Question 13

In a select query the —————– clause doesn’t ignore NULL values.

Answer 13

In a select query the DISTINCT clause doesn’t ignore NULL values.