Question 1

The CUSTOMER table in the Colonial Adventure Tours database includes a column for the trip date.​

Accepted Answer

A) True 
 B)False  False

Question 2

The ____________________ of the order form at TAL Distributors contains the order number and date;the customer's number,name,and address;and the sales rep's number and name.​

Accepted Answer

heading​

Question 3

Why would you not combine the two tables ORDERS and ORDER_LINE at TAL Distributors?​

Accepted Answer

If the two tables were combined,the new table would be more complicated.Some of the individual positions within this table will contain multiple entries,making it difficult to track the information between columns.In general,the simpler structure is preferable,and that is why order lines appear in a separate table.​

Question 4

Each guide is uniquely identified by his or her GUIDE_NUM.​

Accepted Answer

A) True 
 B)False

Question 5

The TRIP table in the Colonial Adventure Tours database includes a column for the trip cost.​

Accepted Answer

A) True 
 B)False

Question 6

Each row in the table CONDO_UNIT table at Solmaris contains a condo _____ that identifies the particular condo.​

Accepted Answer

A) sequence 
B) ​ID 
C) name 
D) ​owner 
A) sequence 
B) ​ID 
C) name 
D) ​owner

Question 7

The ORDER_LINE table in the TAL Distributors database contains information about the date an order was placed.​

Accepted Answer

A) True 
 B)False

Question 8

The order number appears in the ORDERS table and the ____________________ table in the TAL Distributors database.​

Accepted Answer

The answer of The order number appears in the ORDERS...

Question 9

In the Colonial Adventure Tours database,each guide is uniquely identified by a(n)____________________.​

Accepted Answer

guide
numb

Question 10

Colonial Adventure Tours identifies each reservation by a unique reservation number that uses the last ____________________ digits of the current year followed by a five-digit number.​

Accepted Answer

The answer of Colonial Adventure Tours identifies each reservation by...

Question 11

In some database systems,the word "order" has a special purpose.​

Accepted Answer

A) True 
 B)False

Question 12

The TAL Distributors database includes four tables.​

Accepted Answer

A) True 
 B)False

Question 13

Solmaris manages _____ condo locations.​

Accepted Answer

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

Question 14

In addition to the trip ID,Colonial Adventure Tours tracks the trip name,the trip's starting location,the state in which the trip originates,the trip's total distance,the trip's maximum group size,the trip's type,and the trip's ____________________.​

Accepted Answer

The answer of In addition to the trip ID,Colonial Adventure...

Question 15

The body of the order for TAL Distributors contains one or more order lines,sometimes called line ____________________.​

Accepted Answer

The answer of The body of the order for TAL...

Question 16

The owner number appears in the OWNER table and the ____________________ table in the Solmaris Condominium Group database.​

Accepted Answer

The answer of The owner number appears in the OWNER...

Question 17

When designing tables a ____ structure is preferred.​

Accepted Answer

A) complex 
B) ​simple 
C) detailed 
D) ​complete 
A) complex 
B) ​simple 
C) detailed 
D) ​complete

Question 18

Why does the TAL Distributors database use the table ORDERS instead of ORDER?​

Accepted Answer

In some database systems,the w

Question 19

Combining the ORDER_LINE and ORDERS tables will ____.​

Accepted Answer

A) save space in the table 
B) ​make the table more effective 
C) increase space in the table 
D) ​make the table more complicated 
A) save space in the table 
B) ​make the table more effective 
C) increase space in the table 
D) ​make the table more complicated

Question 20

The category number appears in the SERVICE_CATEGORY table and the ____________________ table in the Solmaris Condominium Group database.​

Accepted Answer

The answer of The category number appears in the SERVICE_CATEGORY...

The CUSTOMER table in the Colonial Adventure Tours database includes a column for the trip date.

The ____________________ of the order form at TAL Distributors contains the order number and date;the customer's number,name,and address;and the sales rep's number and name.

Why would you not combine the two tables ORDERS and ORDER_LINE at TAL Distributors?

Each guide is uniquely identified by his or her GUIDE_NUM.

The TRIP table in the Colonial Adventure Tours database includes a column for the trip cost.

Each row in the table CONDO_UNIT table at Solmaris contains a condo _____ that identifies the particular condo.

The ORDER_LINE table in the TAL Distributors database contains information about the date an order was placed.

The order number appears in the ORDERS table and the ____________________ table in the TAL Distributors database.

In the Colonial Adventure Tours database,each guide is uniquely identified by a(n)____________________.

Colonial Adventure Tours identifies each reservation by a unique reservation number that uses the last ____________________ digits of the current year followed by a five-digit number.

In some database systems,the word "order" has a special purpose.

The TAL Distributors database includes four tables.

Solmaris manages _____ condo locations.

In addition to the trip ID,Colonial Adventure Tours tracks the trip name,the trip's starting location,the state in which the trip originates,the trip's total distance,the trip's maximum group size,the trip's type,and the trip's ____________________.

The body of the order for TAL Distributors contains one or more order lines,sometimes called line ____________________.

The owner number appears in the OWNER table and the ____________________ table in the Solmaris Condominium Group database.

When designing tables a ____ structure is preferred.

Why does the TAL Distributors database use the table ORDERS instead of ORDER?

Combining the ORDER_LINE and ORDERS tables will ____.

The category number appears in the SERVICE_CATEGORY table and the ____________________ table in the Solmaris Condominium Group database.

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 CUSTOMER table in the Colonial Adventure Tours database includes a column for the trip date.​

The ____________________ of the order form at TAL Distributors contains the order number and date;the customer's number,name,and address;and the sales rep's number and name.​

Why would you not combine the two tables ORDERS and ORDER_LINE at TAL Distributors?​

Each guide is uniquely identified by his or her GUIDE_NUM.​

The TRIP table in the Colonial Adventure Tours database includes a column for the trip cost.​

Each row in the table CONDO_UNIT table at Solmaris contains a condo _____ that identifies the particular condo.​

The ORDER_LINE table in the TAL Distributors database contains information about the date an order was placed.​

The order number appears in the ORDERS table and the ____________________ table in the TAL Distributors database.​

In the Colonial Adventure Tours database,each guide is uniquely identified by a(n)____________________.​

Colonial Adventure Tours identifies each reservation by a unique reservation number that uses the last ____________________ digits of the current year followed by a five-digit number.​

In some database systems,the word "order" has a special purpose.​

The TAL Distributors database includes four tables.​

Solmaris manages _____ condo locations.​

In addition to the trip ID,Colonial Adventure Tours tracks the trip name,the trip's starting location,the state in which the trip originates,the trip's total distance,the trip's maximum group size,the trip's type,and the trip's ____________________.​

The body of the order for TAL Distributors contains one or more order lines,sometimes called line ____________________.​

The owner number appears in the OWNER table and the ____________________ table in the Solmaris Condominium Group database.​

When designing tables a ____ structure is preferred.​

Why does the TAL Distributors database use the table ORDERS instead of ORDER?​

Combining the ORDER_LINE and ORDERS tables will ____.​

The category number appears in the SERVICE_CATEGORY table and the ____________________ table in the Solmaris Condominium Group database.​

Database Design Fundamentals

Creating Tables

Single-Table Queries

Multiple-Table Queries

Updating Data

Database Administration

SQL Functions and Procedures

Filters

The CUSTOMER table in the Colonial Adventure Tours database includes a column for the trip date.

The ____________________ of the order form at TAL Distributors contains the order number and date;the customer's number,name,and address;and the sales rep's number and name.

Why would you not combine the two tables ORDERS and ORDER_LINE at TAL Distributors?

Each guide is uniquely identified by his or her GUIDE_NUM.

The TRIP table in the Colonial Adventure Tours database includes a column for the trip cost.

Each row in the table CONDO_UNIT table at Solmaris contains a condo _____ that identifies the particular condo.

The ORDER_LINE table in the TAL Distributors database contains information about the date an order was placed.

The order number appears in the ORDERS table and the ____________________ table in the TAL Distributors database.

In the Colonial Adventure Tours database,each guide is uniquely identified by a(n)____________________.

Colonial Adventure Tours identifies each reservation by a unique reservation number that uses the last ____________________ digits of the current year followed by a five-digit number.

In some database systems,the word "order" has a special purpose.

The TAL Distributors database includes four tables.

Solmaris manages _____ condo locations.

In addition to the trip ID,Colonial Adventure Tours tracks the trip name,the trip's starting location,the state in which the trip originates,the trip's total distance,the trip's maximum group size,the trip's type,and the trip's ____________________.

The body of the order for TAL Distributors contains one or more order lines,sometimes called line ____________________.

The owner number appears in the OWNER table and the ____________________ table in the Solmaris Condominium Group database.

When designing tables a ____ structure is preferred.

Why does the TAL Distributors database use the table ORDERS instead of ORDER?

Combining the ORDER_LINE and ORDERS tables will ____.

The category number appears in the SERVICE_CATEGORY table and the ____________________ table in the Solmaris Condominium Group database.