Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

CIT 350 - unit 8 MySQL Chap 3

memorize.ai (lvl 286)

(0)

10 cards

()

Section 1

Preview this deck

When coded in a WHERE clause, which search condition will return invoices when payment_date isn't null and invoice_total is greater than or equal to $500?

Front

1 / 10

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (10)

Section 1

(10 cards)

When coded in a WHERE clause, which search condition will return invoices when payment_date isn't null and invoice_total is greater than or equal to $500?

Front

payment_date IS NOT NULL AND invoice_total >= 500

Back

Which of the following WHERE clauses will return vendor names from A to C?

Front

WHERE vendor_name < 'D'

Back

When coded in a WHERE clause, which of the following search conditions will not return a result set that includes all invoices with an invoice_total value of $1000 or less?

Front

invoice_total IN (0,1000)

Back

To override the order of precedence in an arithmetic expression, you can use __________________.

Front

parenteses

Back

If you want to filter the rows that are returned by a SELECT statement, you must include a/an ___________________ clause.

Front

WHERE

Back

Which of the following isn't a valid column alias?

Front

total sales

Back

Which of the following would return a maximum of 7 rows, starting with the 4th row?

Front

LIMIT 7,4

Back

The order of precedence for the logical operators in a WHERE clause is

Front

Not,And, Or

Back

To retrieve rows in which an expression matches a string pattern called a mask, you can use the ______________ keyword followed by the mask.

Front

LIKE

Back

To return all of the columns from the base table, you can code the ________________ operator in the SELECT clause.

Front

asterick

Back