Question 1

The TRIP_GUIDES table in the Colonial Adventure Tours database has three columns.​

Accepted Answer

A) True 
 B)False

Question 2

In the Colonial Adventure Tours database,the GUIDE table contains the guide's number,name,address,and salary.​

Accepted Answer

A) True 
 B)False

Question 3

The Solmaris Condominium Group database uses a combination of letters and numbers to represent an owner number.​

Accepted Answer

A) True 
 B)False

Question 4

The TRIP,GUIDE,and ____ tables are part of the Colonial Adventure Tours database.​

Accepted Answer

A) SALES 
B) ​LOCATION 
C) CUSTOMER 
D) ​REP 
A) SALES 
B) ​LOCATION 
C) CUSTOMER 
D) ​REP

Question 5

The reservation ID in the RESERVATION table in the Colonial Adventure Tours database is presented as a three-digit number.​

Accepted Answer

A) True 
 B)False

Question 6

The TAL Distributors database contains information that relates sales reps to the customers they represent and customers to the ____________________ they have placed.​

Accepted Answer

The answer of The TAL Distributors database contains information that...

Question 7

In the Colonial Adventure Tours database,the table named RESERVATION contains information about trip cost and other fees.​

Accepted Answer

A) True 
 B)False

Question 8

Each trip that Colonial Adventure Tours offers has a number that uniquely identifies the trip.​

Accepted Answer

A) True 
 B)False

Question 9

At TAL Distributors,the body of the order contains the order number and date;the customer's number,name,and address;and the sales rep number and name.​

Accepted Answer

A) True 
 B)False

Question 10

Colonial Adventure Tours offers three types of guided trips;____________________,biking,and paddling.​

Accepted Answer

The answer of Colonial Adventure Tours offers three types of...

Question 11

At TAL Distributors,the three sections of an order are the heading,body,and footing.​

Accepted Answer

A) True 
 B)False

Question 12

The computer calculates the ____________________ for TAL Distributors whenever an order is printed or displayed on the screen.​

Accepted Answer

total
orde

Question 13

The order line in a TAL Distributors order form contains a total that is called a(n)____.​

Accepted Answer

A) footing 
B) ​extension 
C) trailer 
D) ​sum 
A) footing 
B) ​extension 
C) trailer 
D) ​sum

Question 14

All the sales representatives at TAL Distributors get the same commission rate.​

Accepted Answer

A) True 
 B)False

Question 15

The three components of a TAL Distributors order are the heading,____________________,and footing.​

Accepted Answer

The answer of The three components of a TAL Distributors...

Question 16

An example of a relationship between categories is the relationship that exists in the TAL Distributors database between sales reps and customers.​

Accepted Answer

A) True 
 B)False

Question 17

The date for a particular trip is stored in the ____________________ table in the Colonial Adventure Tours database.​

Accepted Answer

The answer of The date for a particular trip is...

Question 18

TAL Distributors sells ____.​

Accepted Answer

A) furniture 
B) ​wooden toys,games,and puzzles 
C) appliances,housewares,and sporting goods 
D) ​electronic games 
A) furniture 
B) ​wooden toys,games,and puzzles 
C) appliances,housewares,and sporting goods 
D) ​electronic games

Question 19

An owner number in the OWNER table at Solmaris Condominium consists of ____ uppercase letters followed by a three-digit number.​

Accepted Answer

A) 2 
B) ​3 
C) 4 
D) ​5 
A) 2 
B) ​3 
C) 4 
D) ​5

Question 20

The Colonial Adventure Tours database uses a two-digit number to represent the guide number.​

Accepted Answer

A) True 
 B)False

The TRIP_GUIDES table in the Colonial Adventure Tours database has three columns.

In the Colonial Adventure Tours database,the GUIDE table contains the guide's number,name,address,and salary.

The Solmaris Condominium Group database uses a combination of letters and numbers to represent an owner number.

The TRIP,GUIDE,and ____ tables are part of the Colonial Adventure Tours database.

The reservation ID in the RESERVATION table in the Colonial Adventure Tours database is presented as a three-digit number.

The TAL Distributors database contains information that relates sales reps to the customers they represent and customers to the ____________________ they have placed.

In the Colonial Adventure Tours database,the table named RESERVATION contains information about trip cost and other fees.

Each trip that Colonial Adventure Tours offers has a number that uniquely identifies the trip.

At TAL Distributors,the body of the order contains the order number and date;the customer's number,name,and address;and the sales rep number and name.

Colonial Adventure Tours offers three types of guided trips;____________________,biking,and paddling.

At TAL Distributors,the three sections of an order are the heading,body,and footing.

The computer calculates the ____________________ for TAL Distributors whenever an order is printed or displayed on the screen.

The order line in a TAL Distributors order form contains a total that is called a(n)____.

All the sales representatives at TAL Distributors get the same commission rate.

The three components of a TAL Distributors order are the heading,____________________,and footing.

An example of a relationship between categories is the relationship that exists in the TAL Distributors database between sales reps and customers.

The date for a particular trip is stored in the ____________________ table in the Colonial Adventure Tours database.

TAL Distributors sells ____.

An owner number in the OWNER table at Solmaris Condominium consists of ____ uppercase letters followed by a three-digit number.

The Colonial Adventure Tours database uses a two-digit number to represent the guide number.

Database Design Fundamentals

Creating Tables

Single-Table Queries

Multiple-Table Queries

Updating Data

Database Administration

SQL Functions and Procedures

Filters

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

The TRIP_GUIDES table in the Colonial Adventure Tours database has three columns.​

In the Colonial Adventure Tours database,the GUIDE table contains the guide's number,name,address,and salary.​

The Solmaris Condominium Group database uses a combination of letters and numbers to represent an owner number.​

The TRIP,GUIDE,and ____ tables are part of the Colonial Adventure Tours database.​

The reservation ID in the RESERVATION table in the Colonial Adventure Tours database is presented as a three-digit number.​

The TAL Distributors database contains information that relates sales reps to the customers they represent and customers to the ____________________ they have placed.​

In the Colonial Adventure Tours database,the table named RESERVATION contains information about trip cost and other fees.​

Each trip that Colonial Adventure Tours offers has a number that uniquely identifies the trip.​

At TAL Distributors,the body of the order contains the order number and date;the customer's number,name,and address;and the sales rep number and name.​

Colonial Adventure Tours offers three types of guided trips;____________________,biking,and paddling.​

At TAL Distributors,the three sections of an order are the heading,body,and footing.​

The computer calculates the ____________________ for TAL Distributors whenever an order is printed or displayed on the screen.​

The order line in a TAL Distributors order form contains a total that is called a(n)____.​

All the sales representatives at TAL Distributors get the same commission rate.​

The three components of a TAL Distributors order are the heading,____________________,and footing.​

An example of a relationship between categories is the relationship that exists in the TAL Distributors database between sales reps and customers.​

The date for a particular trip is stored in the ____________________ table in the Colonial Adventure Tours database.​

TAL Distributors sells ____.​

An owner number in the OWNER table at Solmaris Condominium consists of ____ uppercase letters followed by a three-digit number.​

The Colonial Adventure Tours database uses a two-digit number to represent the guide number.​

Database Design Fundamentals

Creating Tables

Single-Table Queries

Multiple-Table Queries

Updating Data

Database Administration

SQL Functions and Procedures

Filters

The TRIP_GUIDES table in the Colonial Adventure Tours database has three columns.

In the Colonial Adventure Tours database,the GUIDE table contains the guide's number,name,address,and salary.

The Solmaris Condominium Group database uses a combination of letters and numbers to represent an owner number.

The TRIP,GUIDE,and ____ tables are part of the Colonial Adventure Tours database.

The reservation ID in the RESERVATION table in the Colonial Adventure Tours database is presented as a three-digit number.

The TAL Distributors database contains information that relates sales reps to the customers they represent and customers to the ____________________ they have placed.

In the Colonial Adventure Tours database,the table named RESERVATION contains information about trip cost and other fees.

Each trip that Colonial Adventure Tours offers has a number that uniquely identifies the trip.

At TAL Distributors,the body of the order contains the order number and date;the customer's number,name,and address;and the sales rep number and name.

Colonial Adventure Tours offers three types of guided trips;____________________,biking,and paddling.

At TAL Distributors,the three sections of an order are the heading,body,and footing.

The computer calculates the ____________________ for TAL Distributors whenever an order is printed or displayed on the screen.

The order line in a TAL Distributors order form contains a total that is called a(n)____.

All the sales representatives at TAL Distributors get the same commission rate.

The three components of a TAL Distributors order are the heading,____________________,and footing.

An example of a relationship between categories is the relationship that exists in the TAL Distributors database between sales reps and customers.

The date for a particular trip is stored in the ____________________ table in the Colonial Adventure Tours database.

TAL Distributors sells ____.

An owner number in the OWNER table at Solmaris Condominium consists of ____ uppercase letters followed by a three-digit number.

The Colonial Adventure Tours database uses a two-digit number to represent the guide number.