Question 1

How do you construct the SELECT query?

Accepted Answer

In SQL, you use the SELECT command to query a database. The basic form of the SQL SELECT command is SELECT-FROM-WHERE. After you type the word SELECT, you list the columns that you want to include in the query results. This portion of the command is called the SELECT clause. Next, you type the word FROM followed by the name of the table that contains the data you need to query.This portion of the command is called the FROM clause. Finally, after the word WHERE, you list any conditions (restrictions)that apply to the data you want to retrieve.This optional portion of the command is called the WHERE clause.

Question 2

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

Accepted Answer

A) GROUP 
B) GROUP BY 
C) SET GROUP 
D) GROUPING 
A) GROUP 
B) GROUP BY 
C) SET GROUP 
D) GROUPING B

Question 3

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

Accepted Answer

computed

Question 4

The WHERE clause applies to both rows and groups.

Accepted Answer

A) True 
 B)False

Question 5

The ____ function calculates a total of the values in a column.

Accepted Answer

A) TOTAL 
B) CALCULATE 
C) SUM 
D) ADD 
A) TOTAL 
B) CALCULATE 
C) SUM 
D) ADD

Question 6

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

Accepted Answer

The answer of MySQL has special functions, called ____________________ functions,...

Question 7

The only arithmetic operators that can be used in SELECT statements are + for addition and - for subtraction.

Accepted Answer

A) True 
 B)False

Question 8

When data is sorted on two columns, the more important column is called the major sort key.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

The answer of When you use the MAX function, SQL...

Question 10

The basic form of the SQL SELECT command is ____.

Accepted Answer

A) FROM-SELECT-WHERE 
B) SELECT-FROM-WHERE 
C) FROM-WHERE-SELECT 
D) WHERE-SELECT-FROM 
A) FROM-SELECT-WHERE 
B) SELECT-FROM-WHERE 
C) FROM-WHERE-SELECT 
D) WHERE-SELECT-FROM

Question 11

The GROUP BY clause sorts the data in a particular order.

Accepted Answer

A) True 
 B)False

Question 12

The WHERE clause is used to limit the rows that are included in a query's result.

Accepted Answer

A) True 
 B)False

Question 13

There are no special formatting rules in MySQL.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

The answer of A(n)____________________ clause provides a concise way of...

Question 15

A simple condition has the form: column name, comparison operator, and then either another column name or a value.

Accepted Answer

A) True 
 B)False

Question 16

____________________ conditions are formed by connecting two or more simple conditions.

Accepted Answer

The answer of ____________________ conditions are formed by connecting two...

Question 17

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

Accepted Answer

The answer of The column on which data is to...

Question 18

MySQL supports only the version of the "not equal to" comparison operator.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

The answer of You can also assign a name to...

Question 20

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

Accepted Answer

A) True 
 B)False

How do you construct the SELECT query?

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

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

The WHERE clause applies to both rows and groups.

The ____ function calculates a total of the values in a column.

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

The only arithmetic operators that can be used in SELECT statements are + for addition and - for subtraction.

When data is sorted on two columns, the more important column is called the major sort key.

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

The basic form of the SQL SELECT command is ____.

The GROUP BY clause sorts the data in a particular order.

The WHERE clause is used to limit the rows that are included in a query's result.

There are no special formatting rules in MySQL.

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

A simple condition has the form: column name, comparison operator, and then either another column name or a value.

____________________ conditions are formed by connecting two or more simple conditions.

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

MySQL supports only the version of the "not equal to" comparison operator.

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

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

Introduction to Premiere Products, Henry Books, and Alexamara Marina Group

Database Design Fundamentals

An Introduction to SQL

Multiple-Table Queries

Updating Data

Database Administration

MySQL Special Topics

Filters

Exam 4: Single-Table Queries

How do you construct the SELECT query?

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

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

The WHERE clause applies to both rows and groups.

The ____ function calculates a total of the values in a column.

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

The only arithmetic operators that can be used in SELECT statements are + for addition and - for subtraction.

When data is sorted on two columns, the more important column is called the major sort key.

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

The basic form of the SQL SELECT command is ____.

The GROUP BY clause sorts the data in a particular order.

The WHERE clause is used to limit the rows that are included in a query's result.

There are no special formatting rules in MySQL.

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

A simple condition has the form: column name, comparison operator, and then either another column name or a value.

____________________ conditions are formed by connecting two or more simple conditions.

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

MySQL supports only the version of the "not equal to" comparison operator.

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

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

Introduction to Premiere Products, Henry Books, and Alexamara Marina Group

Database Design Fundamentals

An Introduction to SQL

Multiple-Table Queries

Updating Data

Database Administration

MySQL Special Topics

Filters