SQL Practice Exam 2

What keyword can you use to retrieve rows in which an expression matches a string pattern called a mask? (Choose the most specific answer.)

• OR

• ORDER BY

• WHERE

• LIKE

Which ORDER BY clause causes 10 rows to be retrieved from the result set, starting with the 20th?

• ORDER BY InvoiceTotal DESC OFFSET 20 ROWS FETCH FIRST 10 ROWS

• ORDER BY InvoiceTotal DESC OFFSET 10 ROWS FETCH NEXT 20 ROWS

• ORDER BY InvoiceTotal DESC OFFSET 0 ROWS FETCH NEXT 10 ROWS

• ORDER BY InvoiceTotal DESC OFFSET 10 ROWS FETCH FIRST 20 ROWS

Which clause specifies the number of rows that should be skipped before rows are returned from the result set?

• FETCH

• OFFSET

• SKIP

• RETRIEVE

Which clause specifies the number of rows that should be retrieved after skipping the specified number of rows?

• FETCH

• OFFSET

• SKIP

• RETRIEVE

When you code a SELECT statement, you must code the four main clauses in which order?

• SELECT, FROM, ORDER BY, WHERE

• SELECT, ORDER BY, FROM, WHERE

• SELECT, WHERE, ORDER BY, FROM

• SELECT, FROM, WHERE, ORDER BY

What do the keywords ALL, DISTINCT, and TOP allow you to do?

• create Boolean expressions in a WHERE clause

• add or remove rows from a base table

• filter the number of columns in the result set

• control the number of rows that are returned by a query

What keyword do you code at the end of the ORDER BY clause to sort the records that are retrieved by a SELECT statement in descending sequence?

• DESC
• DISTINCT

• ALL

• ASC

Which clause of the SELECT statement names the table that contains the data to be retrieved?

• WHERE

• FROM

• ORDER BY

• SELECT

What keyword can you code in the SELECT clause to prevent duplicate rows from being returned by a SELECT statement?

• ALL

• UNIQUE

• DISTINCT

• PREVENT

When coded in a WHERE clause, which search condition will return invoices when PaymentDate is not null and InvoiceTotal is greater than or equal to $500?

• PaymentDate IS NULL AND InvoiceTotal > 500

• PaymentDate IS NOT NULL OR InvoiceTotal >= 500

• NOT (PaymentDate IS NULL AND InvoiceTotal <= 500)

• PaymentDate IS NOT NULL AND InvoiceTotal >= 500