Quiz 3 Flashcards
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
PaymentDate IS NOT NULL AND InvoiceTotal >= 500
NOT (PaymentDate IS NULL AND InvoiceTotal <= 500)
PaymentDate IS NOT NULL AND InvoiceTotal >= 500
Which clause of the SELECT statement names the table that contains the data to be retrieved?
ORDER BY
WHERE
FROM
SELECT
FROM
When coded within a SELECT clause, which TOP clause will return a result set consisting of the ten largest invoice numbers?
TOP InvoiceNumber, InvoiceTotal
TOP 10 InvoiceTotal
TOP 10 InvoiceNumber
TOP 10 PERCENT InvoiceNumber
TOP 10 PERCENT WITH TIES InvoiceNumber
TOP 10 InvoiceNumber
word that has a predefined meaning
Keyword
Expression that evaulates to true or false
Boolean Expression or predicate
A different name specified for a column (through the use of AS clause)
Column alias
combination of one or more character columns and literal values
string expression
Something enclosed in single quotation marks
literal value
Arithmetic operators
(*?%+-)
Performs an operation and returns a result
Function
Value passed to a function
Parameter or argument
One sort nested within another sort
Nested sort
Represent a value that is unknow, unavailable, or not applicable.
NULL Value
Which wildcard character do you use in the SELECT clause to return all of the columns from the base table?
-
=
+
*
*
Which of the following is not a valid column alias name?
“Total Sales”
Total
TotalSales
Total Sales
Total Sales (Cause of the space)
