Question 1

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

Accepted Answer

The answer of When you use the ____________________ function,you must...

Question 2

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

Accepted Answer

The answer of When the ____________________ operator connects simple conditions,all...

Question 3

When the OR operator connects simple conditions,the compound condition will be true whenever any one of the simple conditions is true.​

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

The answer of ____________________ creates groups of rows that share...

Question 5

The UNIQUE operator eliminates duplicate values in a query.​

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A)  IS NULL
B)  ​NOT NULL
C)  !NULL
D)  ​IS NOT NULLE) C) and D)
F) A) and B)

Question 7

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

The answer of A(n)____________________ column is a column that does...

Question 8

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

Accepted Answer

A)  double
B)  ​primary
C)  minor
D)  ​foreignE) A) and D)
F) None of the above

Question 9

Instead of including every column in the SELECT clause,you can use an ampersand (&)to indicate that you want to include all columns.​

Accepted Answer

A) True 
 B)False

Question 10

In a SELECT statement,the FROM clause and the WHERE clause (when used)must appear on separate lines.​

Accepted Answer

A) True 
 B)False

Question 11

In the SELECT clause,you can use the ____ symbol to indicate that you want to include all columns.​

Accepted Answer

A)  \
B)  ​/
C)  *
D)  ​?E) A) and D)
F) B) and C)

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A)  REVERSE
B)  ​NOT
C)  NULL
D)  ​ORE) B) and C)
F) A) and B)

Question 14

Describe simple and compound conditions.​

Accepted Answer

A simple condition has this form: column...

Question 15

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

Accepted Answer

A)  SUM
B)  ​COUNT
C)  MAX
D)  ​MINE) None of the above
F) A) and B)

Question 16

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

Accepted Answer

A)  WHERE
B)  ​SELECT
C)  FROM
D)  ​SETE) A) and C)
F) A) and B)

Question 17

To specify that query results be listed in a specific order,use the SORT BY clause.​

Accepted Answer

A) True 
 B)False

Question 18

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 19

The COUNT function only applies to columns with numeric values.​

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

The answer of When you need to sort data on...

Exam 4: Single-Table Queries

In a SELECT statement,the FROM clause and the WHERE clause (when used)must appear on separate lines.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

In the SELECT clause,you can use the ____ symbol to indicate that you want to include all columns.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

When the OR operator connects simple conditions,the compound condition will be true whenever any one of the simple conditions is true.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The COUNT function only applies to columns with numeric values.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The UNIQUE operator eliminates duplicate values in a query.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Instead of including every column in the SELECT clause,you can use an ampersand (&)to indicate that you want to include all columns.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Describe simple and compound conditions.​

Correct AnswerverifiedA simple condition has this form: column...View AnswerShow Answer

To specify that query results be listed in a specific order,use the SORT BY clause.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

In a SELECT statement,the FROM clause and the WHERE clause (when used)must appear on separate lines.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

In the SELECT clause,you can use the ____ symbol to indicate that you want to include all columns.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

When the OR operator connects simple conditions,the compound condition will be true whenever any one of the simple conditions is true.

Correct Answer
verified

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

Correct Answer
verified

The COUNT function only applies to columns with numeric values.

Correct Answer
verified

____________________ creates groups of rows that share some common characteristic.

Correct Answer
verified

The UNIQUE operator eliminates duplicate values in a query.

Correct Answer
verified

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

Correct Answer
verified

Instead of including every column in the SELECT clause,you can use an ampersand (&)to indicate that you want to include all columns.

Correct Answer
verified

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

Correct Answer
verified

Preceding a condition by the NOT operator reverses the truth of the original condition.

Correct Answer
verified

Describe simple and compound conditions.

Correct Answer
verified
A simple condition has this form: column...
View Answer

To specify that query results be listed in a specific order,use the SORT BY clause.

Correct Answer
verified

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

Correct Answer
verified