Exam 2

Question 1

Select

Answer 1

retrieves data from either a single table or multiple tables.

Indicates the column or columns to be retrieved.

Question 2

Having

Answer 2

Involving groups, indicates a condition, only if it is true will the groups be included in the results.

Question 3

Group By

Answer 3

Indicates column or columns on which rows are to be grouped

Question 4

Order By

Answer 4

Indicates column or columns on which the query output is to be sorted. List data in a specific order

Question 5

Where

Answer 5

Indicates conditions, only the rows for which the conditions are true will be retrieved.

Question 6

Subquery

Answer 6

The inner nested query, that gets evaluated first. Whose results can be used by the outer query.

Question 7

Like

Answer 7

Operator that uses one or more wildcard characters to test for a pattern match

Question 8

Between

Answer 8

An operator that lest you specify a range of values in a condition.

Question 9

Distinct

Answer 9

Operator eliminates duplicate values in query results

Question 10

In

Answer 10

Finds a value in a group of values specified by the condition