Quiz 2 - IT Database management systems

what does the symbol % represent in LIKE pattern?

Any number of characters (zero or more)

What does the underscore _ represent?

Exactly one character

Looking at the table, the pattern address LIKE 'H%' means:

Starts with H

The pattern address LIKE 'H___' means:

Exactly 4 characters, starts with H

What does the note say about 'H%'?

Starts with H

The pattern address LIKE '%e' means:

Ends with the letter e

Which values match address LIKE '%e'?

Apple, Home, House

The pattern '%e' requires the value to be at least 1 character long.

True

Which values do not match address LIKE '%e'?

Appley, Hi

What is address LIKE '%Staff%' ?

Contains “Staff anywhere“ in the text

What does NOT LIKE 'H%' return?

Does not start with H

SELECT

retrive/get data from a table

COUNT(*)

counts all rows

Which data type can COUNT , MIN and MAX be used with?

numeric + nonnumeric

What does the ORDER BY clause do?

Sorts the results of your SQL query

How many columns can you sort by with ORDER BY?

One or more columns

ASC

Ascending order (small to large)

DESC mean?

Descending order (large to small)

Which data type can SUM and AVG be used with?

Numeric

__________ can be used in SELECT and HAVING

Aggregate functions