Question 1

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 2

You form compound conditions by connecting two or more simple conditions using the ____ operator.​

Accepted Answer

A) AND 
B) ​OR 
C) NOT 
D) ​All of the above 
A) AND 
B) ​OR 
C) NOT 
D) ​All of the above

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Question 5

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 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

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

Question 8

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

Question 9

You can 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 assign a name to a...

Question 10

In SQL,you specify the order of data in query results by using the ____________________ clause.​

Accepted Answer

The answer of In SQL,you specify the order of data...

Question 11

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

Accepted Answer

A) * 
B) ​% 
C) $?$ 
D) ​! 
A) * 
B) ​% 
C) $?$ 
D) ​!

Question 12

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

Accepted Answer

A) LIKE 
B) ​CONTAIN 
C) VALUES 
D) ​IN 
A) LIKE 
B) ​CONTAIN 
C) VALUES 
D) ​IN

Question 13

You use the ____ clause to list data in a specific order.​

Accepted Answer

A) ORDER 
B) ​SET ORDER 
C) ORDER BY 
D) ​LIST BY 
A) ORDER 
B) ​SET ORDER 
C) ORDER BY 
D) ​LIST BY

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

The DISTINCT operator is useful when used in conjunction with the COUNT function.​

Accepted Answer

A) True 
 B)False

Question 16

You can use computed columns in comparisons.​

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

All SELECT statements require a WHERE clause.​

Accepted Answer

A) True 
 B)False

Question 19

The WHERE clause applies to both rows and groups.​

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

The answer of SQL has special functions,called ____________________ functions,to calculate...

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

You form compound conditions by connecting two or more simple conditions using the ____ operator.

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

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

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

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

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

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

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

In SQL,you specify the order of data in query results by using the ____________________ clause.

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

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

You use the ____ clause to list data in a specific order.

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

The DISTINCT operator is useful when used in conjunction with the COUNT function.

You can use computed columns in comparisons.

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

All SELECT statements require a WHERE clause.

The WHERE clause applies to both rows and groups.

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

Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group

Database Design Fundamentals

Creating Tables

Multiple-Table Queries

Updating Data

Database Administration

SQL Functions and Procedures

Filters

Exam 4: Single-Table Queries

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

You form compound conditions by connecting two or more simple conditions using the ____ operator.​

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

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

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

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

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

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

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

In SQL,you specify the order of data in query results by using the ____________________ clause.​

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

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

You use the ____ clause to list data in a specific order.​

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

The DISTINCT operator is useful when used in conjunction with the COUNT function.​

You can use computed columns in comparisons.​

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

All SELECT statements require a WHERE clause.​

The WHERE clause applies to both rows and groups.​

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

Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group

Database Design Fundamentals

Creating Tables

Multiple-Table Queries

Updating Data

Database Administration

SQL Functions and Procedures

Filters

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

You form compound conditions by connecting two or more simple conditions using the ____ operator.

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

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

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

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

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

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

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

In SQL,you specify the order of data in query results by using the ____________________ clause.

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

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

You use the ____ clause to list data in a specific order.

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

The DISTINCT operator is useful when used in conjunction with the COUNT function.

You can use computed columns in comparisons.

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

All SELECT statements require a WHERE clause.

The WHERE clause applies to both rows and groups.

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