Question 1

When you use a name containing a space in Access SQL,you must ____.

Accepted Answer

A) enclose it in square brackets 
B) enclose it in quotation marks 
C) precede it by an asterisk 
D) precede it by a question mark 
A) enclose it in square brackets 
B) enclose it in quotation marks 
C) precede it by an asterisk 
D) precede it by a question mark

Question 2

The ____ clause can be used to create groups of records.

Accepted Answer

A) SELECT 
B) ORDER BY 
C) SORT BY 
D) GROUP BY 
A) SELECT 
B) ORDER BY 
C) SORT BY 
D) GROUP BY

Question 3

In Access SQL,the ____ is used as a wildcard to represent any individual character.

Accepted Answer

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

Question 4

In SQL,you sort data using the ____________________ clause.

Accepted Answer

The answer of In SQL,you sort data using the ____________________...

Question 5

What are some common restrictions place on table and column names by DBMSs?

Accepted Answer

Some common restrictions are: 1. The nam

Question 6

When rows are grouped,one line of output is produced for each group.

Accepted Answer

A) True 
 B)False

Question 7

Most relational DBMSs use a version of SQL as a data manipulation language.

Accepted Answer

A) True 
 B)False

Question 8

In Access,you can combine values in character fields into a single computed field by using the ____________________ operator.

Accepted Answer

The answer of In Access,you can combine values in character...

Question 9

A WHERE and a HAVING clause cannot be included in the same query.

Accepted Answer

A) True 
 B)False

Question 10

Describe five data types that you will often encounter when working with databases.

Accepted Answer

INTEGER: Stores integers,which are numbe

Question 11

The ____________________ of two tables is a table containing all rows that are in either the first table,the second table,or both.

Accepted Answer

The answer of The ____________________ of two tables is a...

Question 12

When rows are grouped,____.

Accepted Answer

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

Question 13

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

Accepted Answer

A) SELECT Description FROM Customer WHERE Warehouse='3' AND OnHand>20 ; 
B) SELECT Description FROM Part WHERE Warehouse='3' OR OnHand>20 ; 
C) SELECT Description FROM Part WHERE Warehouse='3' ; 
D) SELECT Description FROM Part WHERE OnHand>20 ; 
A) SELECT Description FROM Customer WHERE Warehouse='3' AND OnHand>20 ; 
B) SELECT Description FROM Part WHERE Warehouse='3' OR OnHand>20 ; 
C) SELECT Description FROM Part WHERE Warehouse='3' ; 
D) SELECT Description FROM Part WHERE OnHand>20 ;

Question 14

CHAR data types are numbers without a decimal part.

Accepted Answer

A) True 
 B)False

Question 15

Based on the code above,change the Zip code of the student with ID 11433 to 14455.

Accepted Answer

A) UPDATE Student SET Zip='14455' ; 
B) UPDATE Student SET Zip WHERE StudentID='11433' ; 
C) UPDATE Student IN Zip='14455' WHERE StudentID='11433' ; 
D) UPDATE Student SET Zip='14455' WHERE StudentID='11433' ; 
A) UPDATE Student SET Zip='14455' ; 
B) UPDATE Student SET Zip WHERE StudentID='11433' ; 
C) UPDATE Student IN Zip='14455' WHERE StudentID='11433' ; 
D) UPDATE Student SET Zip='14455' WHERE StudentID='11433' ;

Question 16

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 ; 
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 17

One common restriction placed on table and column names by DBMSs is that names can contain only letters,numbers,and ____________________.

Accepted Answer

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

Question 18

The BETWEEN operator is an essential feature of SQL.

Accepted Answer

A) True 
 B)False

Question 19

Many versions of SQL,including MySQL,use the ____________________ as a wildcard to represent any individual character.

Accepted Answer

underscore

Question 20

When you place one query inside another,the inner query is called a(n)____________________.

Accepted Answer

The answer of When you place one query inside another,the...

When you use a name containing a space in Access SQL,you must ____.

The ____ clause can be used to create groups of records.

In Access SQL,the ____ is used as a wildcard to represent any individual character.

In SQL,you sort data using the ____________________ clause.

What are some common restrictions place on table and column names by DBMSs?

When rows are grouped,one line of output is produced for each group.

Most relational DBMSs use a version of SQL as a data manipulation language.

In Access,you can combine values in character fields into a single computed field by using the ____________________ operator.

A WHERE and a HAVING clause cannot be included in the same query.

Describe five data types that you will often encounter when working with databases.

The ____________________ of two tables is a table containing all rows that are in either the first table,the second table,or both.

When rows are grouped,____.

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

CHAR data types are numbers without a decimal part.

Based on the code above,change the Zip code of the student with ID 11433 to 14455.

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.

One common restriction placed on table and column names by DBMSs is that names can contain only letters,numbers,and ____________________.

The BETWEEN operator is an essential feature of SQL.

Many versions of SQL,including MySQL,use the ____________________ as a wildcard to represent any individual character.

When you place one query inside another,the inner query is called a(n)____________________.

Introduction to Database Management

The Relational Model 1: Introduction, QBE, and Relational Algebra

The Relational Model 3: Advanced Topics

Database Design 1: Normalization

Database Design 2: Design Method

Dbms Functions

Database Administration

Database Management Approaches

Filters

Exam 3: The Relational Model 2: SQL

When you use a name containing a space in Access SQL,you must ____.

The ____ clause can be used to create groups of records.

In Access SQL,the ____ is used as a wildcard to represent any individual character.

In SQL,you sort data using the ____________________ clause.

What are some common restrictions place on table and column names by DBMSs?

When rows are grouped,one line of output is produced for each group.

Most relational DBMSs use a version of SQL as a data manipulation language.

In Access,you can combine values in character fields into a single computed field by using the ____________________ operator.

A WHERE and a HAVING clause cannot be included in the same query.

Describe five data types that you will often encounter when working with databases.

The ____________________ of two tables is a table containing all rows that are in either the first table,the second table,or both.

When rows are grouped,____.

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

CHAR data types are numbers without a decimal part.

Based on the code above,change the Zip code of the student with ID 11433 to 14455.

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.

One common restriction placed on table and column names by DBMSs is that names can contain only letters,numbers,and ____________________.

The BETWEEN operator is an essential feature of SQL.

Many versions of SQL,including MySQL,use the ____________________ as a wildcard to represent any individual character.

When you place one query inside another,the inner query is called a(n)____________________.

Introduction to Database Management

The Relational Model 1: Introduction, QBE, and Relational Algebra

The Relational Model 3: Advanced Topics

Database Design 1: Normalization

Database Design 2: Design Method

Dbms Functions

Database Administration

Database Management Approaches

Filters