FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 4: Single-Table Queries

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 32

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

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

Describe simple and compound conditions.​

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

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

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

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

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

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

The UNIQUE operator eliminates duplicate values in a query.​

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

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

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

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

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

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

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

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

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