Question 1

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 NULL 
A)  IS NULL 
B)  NOT NULL 
C)  !NULL 
D)  IS NOT NULL

Question 2

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 3

The HAVING clause is used to restrict groups.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

The answer of The ____________________ operator finds rows that contain...

Question 5

The ____________________ operator eliminates duplicate values in the query results.

Accepted Answer

The answer of The ____________________ operator eliminates duplicate values in...

Question 6

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 7

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 8

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

Accepted Answer

The answer of A(n) ____________________ is simply a question represented...

Question 9

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

Accepted Answer

A)  LIKE 
B)  BETWEEN 
C)  DISTINCT 
D)  GROUP 
A)  LIKE 
B)  BETWEEN 
C)  DISTINCT 
D)  GROUP

Question 10

The BETWEEN operator is an essential feature of SQL.

Accepted Answer

A) True 
 B)False

Question 11

When you connect two or more simple conditions with the AND operator, each condition must be listed on a separate line.

Accepted Answer

A) True 
 B)False

Question 12

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 13

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,...

Question 14

In a nested query, the outer query is evaluated first.

Accepted Answer

A) True 
 B)False

Question 15

The WHERE clause applies to both rows and groups.

Accepted Answer

A) True 
 B)False

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

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

The HAVING clause is used to restrict groups.

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

The ____________________ operator eliminates duplicate values in the query results.

The basic form of the SQL SELECT command is ____.

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

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

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

The BETWEEN operator is an essential feature of SQL.

When you connect two or more simple conditions with the AND operator, each condition must be listed on a separate line.

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

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

In a nested query, the outer query is evaluated first.

The WHERE clause applies to both rows and groups.

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

Database Design Fundamentals

Creating Tables

Multiple-Table Queries

Updating Data

Database Administration

SQL Functions and Procedures

Filters

Exam 4: Single-Table Queries

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

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

The HAVING clause is used to restrict groups.

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

The ____________________ operator eliminates duplicate values in the query results.

The basic form of the SQL SELECT command is ____.

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

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

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

The BETWEEN operator is an essential feature of SQL.

When you connect two or more simple conditions with the AND operator, each condition must be listed on a separate line.

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

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

In a nested query, the outer query is evaluated first.

The WHERE clause applies to both rows and groups.

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

Database Design Fundamentals

Creating Tables

Multiple-Table Queries

Updating Data

Database Administration

SQL Functions and Procedures

Filters