In mysql, the ____ is used as a wildcard to represent any collection of characters.

Asked by geekster3d

Question 6

SQL has special functions, called ____________________ functions, to calculate sums, averages, counts, maximum values, and minimum values.​

Question 11

When the ____________________ operator connects simple conditions, all the simple conditions must be true in order for the compound condition to be true.​

Question 13

The ____ clause lets you group data on a particular column.​

Question 14

The ____ function determines the number of rows in a table.​

Question 16

In SQL for Oracle and for SQL Server, the ____ symbol is used as a wildcard to represent any collection of characters.​

Question 22

When you use the MAX function, SQL ignores any ____________________ value(s) in the column and eliminates them from the computations.​

Question 27

When you use the ____ function, you can use the asterisk (*) to represent any column.​

Question 31

The inner query in a nested query is called a(n) ____________________.​

Question 33

You use the ____________________ clause to retrieve rows that satisfy some condition.​

Question 34

The ____ operator specifies a range of values in a condition.​

Question 37

Which of the following operators can be used for a column computation?​

Question 38

Sometimes a condition involves a column that can accept null values.​

Question 40

0 out of 1 points

The column on which data is to be sorted is called a sort ____________________.​

Question 42

0 out of 1 points

A(n) ____________________ clause provides a concise way of phrasing certain conditions.​

Question 44

You can use the ____________________ clause to limit the groups that are included.​

Question 51

A(n) ____________________ is simply a question represented in a way that the DBMS can understand.​

Question 52

You can use the ____ operator followed by a collection of values to provide a concise way of phrasing certain conditions.​

Question 53

____________________ creates groups of rows that share some common characteristic.​

Question 55

Preceding a condition by the ____ operator reverses the truth of the original condition.​

Question 56

When you use the ____________________ function, you must specify the column to total, and the column data type must be numeric.​

Question 58

When you need to sort data on two columns, the less important column is called the ____ sort key.​

Question 61

A(n) ____________________ column is a column that does not exist in the database but can be computed using data in the existing columns.​

Question 62

The ____________________ operator uses one or more wildcard characters to test for a pattern match.​

Question 63

You can assign a name to a computed column by following the computation with the word ____________________ and the desired name.​

Question 64

In SQL, you use the ____ command to query a database.​

Question 67

The ____________________ operator finds rows that contain a null value in the specified column.​

Question 68

To sort records in descending order, follow the name of the sort key with the ____________________ operator.​

Question 71

When you need to sort data on two columns, the more important column is called the ____________________ sort key.​

Question 75

The ____ operator finds rows that do not contain a null value in the specified column.​