Midterms

Question 1

This clause is used to specify the number of records to return

Answer 1

Limit Clause

Question 2

This is useful on large tables with thousands of records. Returning a large number of records can impact performance.

Answer 2

Limit Clause

Question 3

This operator displays a record if all the conditions separated by this operator are true

Answer 3

AND operator

Question 4

This operator displays a record if any of the conditions separated by this operator is True

Answer 4

Or Operator

Question 5

This is a function where it returns the smallest value of the selected column

Answer 5

MIN() function

Question 6

This function returns the largest value of the selected column

Answer 6

MAX() function

Question 7

This function return the number of rows that matches a specified criterion

Answer 7

COUNT() function

Question 8

This function returns the average value of a numeric column

Answer 8

AVG() function

Question 9

This function returns the total sum of a numeric column

Answer 9

SUM() function

Question 10

This operator is used in a WHERE clause to search for a specified pattern in a column

Answer 10

LIKE operator

Question 11

What are the two wildcards often used in conjunction with the LIKE operator

Answer 11

Percent Sign - %
Underscore Sign - _

Question 12

This represents zero, one, or multiple characters

Answer 12

Percent Sign

Question 13

This represents one, single character

Answer 13

Underscore Sign

Question 14

True or False:
The percent and underscore sign cannot be used in combinations

Answer 14

False (It can actually used in combinations)

Question 15

Like Operator Descriptions:
WHERE CustomerName LIKE ‘a%’

Answer 15

Finds any values that start with “a”

Question 16

Like Operator Descriptions:
WHERE CustomerName LIKE ‘%a’

Answer 16

Finds any values that ends with “a”

Question 17

Like Operator Descriptions:
WHERE CustomerName LIKE ‘%or%’

Answer 17

Find any values that have “or” in any position

Question 18

Like Operator Descriptions:
WHERE CustomerName LIKE ‘_r’

Answer 18

Finds any values that have “r” in the second position

Question 19

Like Operator Descriptions:
WHERE CustomerName LIKE ‘a _ _’

Answer 19

Finds any values that start with “a” and are at least 2 characters in length

Question 20

Like Operator Descriptions:
WHERE CustomerName LIKE ‘a _ _ _’

Answer 20

Finds any values that start with “a” and are at least 3 characters in length

Question 21

Like Operator Descriptions:
WHERE CustomerName LIKE ‘a%o’

Answer 21

Finds values that start with “a” and ends with “o”

Question 22

This character is used to substitute one or more characters in a string

Answer 22

Wildcard character

Question 23

These characters are used with the LIKE operator.

Answer 23

Wildcard Characters

Question 24

The LIKE operator is used in a _________ to search for a specified pattern in a column.

Answer 24

WHERE clause

Question 25

This allows you to specify multiple values in a WHERE clause

Answer 25

IN Operator

Question 26

True or False:
The IN operator is a shorthand for multiple OR conditions

Answer 26

True

Question 27

This operator selects values within a given range.

Answer 27

BETWEEN operator

Question 28

What are the values that can select in a BETWEEN operator?

Answer 28

Numbers, Text, or Dates.

Question 29

True or False:
The BETWEEN operator is inclusive: begin and end values are included.

Answer 29

True

Question 30

These are used to give a table, or a column in a table, a temporary name.

Answer 30

Aliases

Question 31

These are often used to make column names more readable

Answer 31

Aliases

Question 32

True or False:
An alias only exists for the duration of that query.

Answer 32

True

Question 33

What is the keyword if an alias is created?

Answer 33

“AS” keyword

Question 34

This clause is used to combine rows from two or more tables, based on a related column between them.

Answer 34

JOIN clause