Chapter 03 slides

Chapter 3 Quiz

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 NOT NULL AND InvoiceTotal >= 500

Which operator do you use to concatenate character strings in a string expression?

+

Which of the following is not a valid column alias name?

Total Sales

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

When you code an ORDER BY clause, which of the following can you not use?

column data type

Keyword

A word that has a predefined meaning

Boolean Expression or Predicate

An expression that evaluates to True or False

Column alias

A different name specified for a column (normally through use of the AS clause)

String Expression

A combination of one or more character columns and literal values

Concatenation

Combining character columns and / or literal values

+(plus sign)

Concatenation operator

Literal value

Something enclosed in single quotation marks

(* / % + -)

Arithmetic operators

Function

Something that performs an operation and returns a result

Parameter or argument

A value passed to a function

Nested Sort

One sort nested within another sort

Null Value

Represents a value that is unknown, unavailable, or not applicable. It is not the same as a zero, a blank space, or an empty string

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