Question 1

​One common restriction placed on table and column names by DBMSs is that names cannot exceed ____________________ characters.

Accepted Answer

18
eighteen​

Question 2

The ____ function calculates the number of entries in a table.​

Accepted Answer

A)   ​COUNT
B)   ​SUM
C)   ​MAX
D)   ​MIN A

Question 3

​Based on the code above,list the descriptions of all items that are not in Storehouse 3.Based on the code above,list the descriptions of all items that are not in Storehouse 3.

Accepted Answer

A)   ​SELECT Description FROM Customer WHERE NOT Storehouse='3' ;
B)   ​SELECT Description FROM Item WHERE Storehouse='4' ;
C)   ​SELECT Description FROM Item WHERE Storehouse>'3' ;
D)   ​SELECT Description FROM Item WHERE NOT Storehouse='3' ; D

Question 4

Based on the code above,list the descriptions of all items that are located in Storehouse 3 or for which there are more than 20 units on hand,or both.​

Accepted Answer

A)   ​SELECT Description FROM Customer WHERE Storehouse='3' AND OnHand>20 ;
B)   ​SELECT Description FROM Item WHERE Storehouse='3' OR OnHand>20 ;
C)   ​SELECT Description FROM Item WHERE Storehouse='3' ;
D)   ​SELECT Description FROM Item WHERE OnHand>20 ;

Question 5

____________________ means creating groups of records that share some common characteristics.​

Accepted Answer

The answer of ____________________ means creating groups of records that...

Question 6

SQL has built-in functions,which are also called ____________________ functions.​

Accepted Answer

The answer of SQL has built-in functions,which are also called...

Question 7

SQL was developed under the name ____________________ at the IBM San Jose research facilities.​

Accepted Answer

The answer of SQL was developed under the name ____________________...

Question 8

In versions of SQL other than Access,the ____ is used as a wildcard to represent any collection of characters.​

Accepted Answer

A)   ​asterisks (*) 
B)   ​percent sign (%) 
C)   ​underscore (_) 
D)   ​question mark (?)

Question 9

​When rows are grouped,____.

Accepted Answer

A)   ​the totals appear with the rows
B)   ​the rows appear in order
C)   ​one line of output is produced for each group
D)   ​no output is produced

Question 10

​To qualify a field name,precede the name of the field with the name of the table,followed by a(n)____________________.

Accepted Answer

The answer of ​To qualify a field name,precede the name...

Question 11

One common restriction placed on table and column names by DBMSs is that names must start with a(n)____________________.​

Accepted Answer

The answer of One common restriction placed on table and...

Question 12

​To make changes to existing data in a table,you would use the ____ command.

Accepted Answer

A)   ​MODIFY
B)   ​CHANGE
C)   ​SELECT
D)   ​UPDATE

Question 13

How are compound conditions formed?​

Accepted Answer

The answer of How are compound conditions formed?​...

Question 14

​A valid name for a table might be tbl$Student.

Accepted Answer

A) True 
 B)False

Question 15

Based on the code above,for each sales rep,list the rep number,the number of customers assigned to the rep,and the average balance of the rep's customers.Group the records by rep number and order the records by rep number.​

Accepted Answer

A)   ​SELECT RepNum, AVG(Balance)  FROM Customer GROUP BY RepNum ORDER BY RepNum ;
B)   ​SELECT RepNum, COUNT(*) , AVG(Balance)  FROM Part GROUP BY RepNum ORDER BY RepNum ;
C)   ​SELECT RepNum, COUNT(*) , AVG(Balance)  FROM Customer GROUP BY RepNum ORDER BY RepNum ;
D)   ​SELECT RepNum, COUNT(*)  FROM Customer GROUP BY RepNum ORDER BY RepNum ;

Question 16

Discuss the restriction about the structure of two tables involved in a union.​

Accepted Answer

The answer of Discuss the restriction about the structure of...

Question 17

​The HAVING clause is to groups what the WHERE clause is to rows.

Accepted Answer

A) True 
 B)False

Question 18

CHAR data types are numbers without a decimal part.​

Accepted Answer

A) True 
 B)False

Question 19

Based on the code above,list the number,name,and balance of all customers with balances greater than or equal to $2,000 and less than or equal to $5,000.​

Accepted Answer

A)   ​SELECT CustomerNum, CustomerName, Balance FROM Customer WHERE Balance BETWEEN 2000 AND 5000 ;
B)   ​SELECT CustomerNum, CustomerName, Balance FROM Customer WHERE Balance > 2000 ;
C)   ​SELECT CustomerName, Balance FROM Customer WHERE Balance BETWEEN 2000 AND 5000 ;
D)   ​SELECT CustomerNum, CustomerName FROM Customer WHERE Balance BETWEEN 2000 AND 5000 ;

Question 20

For each pair of tables to be joined,a condition must be included indicating how the tables are related.​

Accepted Answer

A) True 
 B)False

Exam 3: The Relational : SQL

​One common restriction placed on table and column names by DBMSs is that names cannot exceed ____________________ characters.

The ____ function calculates the number of entries in a table.​

​Based on the code above,list the descriptions of all items that are not in Storehouse 3.Based on the code above,list the descriptions of all items that are not in Storehouse 3.

Based on the code above,list the descriptions of all items that are located in Storehouse 3 or for which there are more than 20 units on hand,or both.​

____________________ means creating groups of records that share some common characteristics.​

SQL has built-in functions,which are also called ____________________ functions.​

SQL was developed under the name ____________________ at the IBM San Jose research facilities.​

In versions of SQL other than Access,the ____ is used as a wildcard to represent any collection of characters.​

​When rows are grouped,____.

​To qualify a field name,precede the name of the field with the name of the table,followed by a(n)____________________.

One common restriction placed on table and column names by DBMSs is that names must start with a(n)____________________.​

​To make changes to existing data in a table,you would use the ____ command.

How are compound conditions formed?​

​A valid name for a table might be tbl$Student.

Based on the code above,for each sales rep,list the rep number,the number of customers assigned to the rep,and the average balance of the rep's customers.Group the records by rep number and order the records by rep number.​

Discuss the restriction about the structure of two tables involved in a union.​

​The HAVING clause is to groups what the WHERE clause is to rows.

CHAR data types are numbers without a decimal part.​

Based on the code above,list the number,name,and balance of all customers with balances greater than or equal to $2,000 and less than or equal to $5,000.​

For each pair of tables to be joined,a condition must be included indicating how the tables are related.​

One common restriction placed on table and column names by DBMSs is that names cannot exceed ____________________ characters.

The ____ function calculates the number of entries in a table.

Based on the code above,list the descriptions of all items that are not in Storehouse 3.Based on the code above,list the descriptions of all items that are not in Storehouse 3.

Based on the code above,list the descriptions of all items that are located in Storehouse 3 or for which there are more than 20 units on hand,or both.

____________________ means creating groups of records that share some common characteristics.

SQL has built-in functions,which are also called ____________________ functions.

SQL was developed under the name ____________________ at the IBM San Jose research facilities.

In versions of SQL other than Access,the ____ is used as a wildcard to represent any collection of characters.

When rows are grouped,____.

To qualify a field name,precede the name of the field with the name of the table,followed by a(n)____________________.

One common restriction placed on table and column names by DBMSs is that names must start with a(n)____________________.

To make changes to existing data in a table,you would use the ____ command.

How are compound conditions formed?

A valid name for a table might be tbl$Student.

Based on the code above,for each sales rep,list the rep number,the number of customers assigned to the rep,and the average balance of the rep's customers.Group the records by rep number and order the records by rep number.

Discuss the restriction about the structure of two tables involved in a union.

The HAVING clause is to groups what the WHERE clause is to rows.

CHAR data types are numbers without a decimal part.

Based on the code above,list the number,name,and balance of all customers with balances greater than or equal to $2,000 and less than or equal to $5,000.

For each pair of tables to be joined,a condition must be included indicating how the tables are related.