Lesson 8

Question 1

Subquery

Answer 1

A query embedded in another query.

Question 2

SELECT Subquery

Answer 2

Embedding another SELECT statement inside of a query.

Question 3

Outer Query

Answer 3

Main query that has an inner query embedded inside of it.

Question 4

Inner Query

Answer 4

The query that is embedded inside another query.

Question 5

IN

Answer 5

Conditional operator that is a shorthand for multiple OR conditions.

Question 6

NOT

Answer 6

Conditional operator used to display a row if the condition is not true.

Question 7

NOT IN

Answer 7

Combines the NOT and IN conditional operators.

Question 8

OR

Answer 8

Only one condition must be true for the condition to be true.

Question 9

AND

Answer 9

Both or all the conditions must be true for the condition to be true.

Question 10

LIKE

Answer 10

Used in the WHERE clause to find a specified pattern in a column.

Question 11

Wildcard

Answer 11

A character that substitutes for one or more characters in a string.

Question 12

%Wildcard

Answer 12

Represents zero or more characters.

Question 13

_Wildcard

Answer 13

Represents a single character.