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

The table named ____________________ stores information about condo locations for Solmaris Condominium Group.

(Short Answer)

4.7/5

(34)

Question 61

A(n)____________________ is a structure that contains different categories of information and the relationships between these categories.

(Short Answer)

5.0/5

(38)

Question 62

Colonial Adventure Tours offers biking,hiking,and paddling trips.

(True/False)

4.9/5

(30)

Question 63

List the three practical issues that would need to be dealt with if the ORDERS table and the ORDER_LINE table at TAL Distributors were combined?

(Essay)

4.9/5

(40)

Question 64

At Solmaris Condominium Group,condo units are numbered differently at each location.

(True/False)

4.7/5

(32)

Question 65

The ORDERS table consists of the order number,order date,and ____.

(Multiple Choice)

4.8/5

(45)

Question 66

A category name uniquely identifies each service that Solmaris performs

(True/False)

4.9/5

(42)

Question 67

Each order line at TAL Distributors contains a total,usually called a(n)____________________.

(Short Answer)

4.9/5

(43)

Question 68

The REP table consists of the sales representatives' number,last name,first name,address,total commission,and ____.

(Multiple Choice)

4.7/5

(32)

Question 69

The customer's name and address and the number of the sales rep who represents the customer are stored with sales rep information.

(True/False)

4.9/5

(46)

Question 70

Because TAL Distributors wants the flexibility to quote and charge different prices to different customers,the QUOTED_PRICE column is included in the ORDER_LINE table.

(True/False)

5.0/5

(30)

Question 71

The SERVICE_CATEGORY table in the Solmaris Condominium Group database includes the service fee

(True/False)

4.8/5

(32)

Question 72

The item description is stored with the information about items.

(True/False)

4.8/5

(44)

Question 73

The _____ table includes the maximum number of people that can participate in a trip in the Colonial Adventure Tours database.

(Multiple Choice)

4.8/5

(38)

Question 74

The TRIP_GUIDES table in the Colonial Adventure Tours database is used to relate trips and guides.

(True/False)

4.9/5

(39)

Question 75

Showing 61 - 75 of 75

The table named ____________________ stores information about condo locations for Solmaris Condominium Group.

A(n)____________________ is a structure that contains different categories of information and the relationships between these categories.

Colonial Adventure Tours offers biking,hiking,and paddling trips.

List the three practical issues that would need to be dealt with if the ORDERS table and the ORDER_LINE table at TAL Distributors were combined?

At Solmaris Condominium Group,condo units are numbered differently at each location.

The ORDERS table consists of the order number,order date,and ____.

A category name uniquely identifies each service that Solmaris performs

Each order line at TAL Distributors contains a total,usually called a(n)____________________.

The REP table consists of the sales representatives' number,last name,first name,address,total commission,and ____.

The customer's name and address and the number of the sales rep who represents the customer are stored with sales rep information.

Because TAL Distributors wants the flexibility to quote and charge different prices to different customers,the QUOTED_PRICE column is included in the ORDER_LINE table.

The SERVICE_CATEGORY table in the Solmaris Condominium Group database includes the service fee

The item description is stored with the information about items.

The _____ table includes the maximum number of people that can participate in a trip in the Colonial Adventure Tours database.

The TRIP_GUIDES table in the Colonial Adventure Tours database is used to relate trips and guides.

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 table named ____________________ stores information about condo locations for Solmaris Condominium Group.​

A(n)____________________ is a structure that contains different categories of information and the relationships between these categories.​

Colonial Adventure Tours offers biking,hiking,and paddling trips.​

List the three practical issues that would need to be dealt with if the ORDERS table and the ORDER_LINE table at TAL Distributors were combined?​

At Solmaris Condominium Group,condo units are numbered differently at each location.​

The ORDERS table consists of the order number,order date,and ____.​

A category name uniquely identifies each service that Solmaris performs​

Each order line at TAL Distributors contains a total,usually called a(n)____________________.​

The REP table consists of the sales representatives' number,last name,first name,address,total commission,and ____.​

The customer's name and address and the number of the sales rep who represents the customer are stored with sales rep information.​

Because TAL Distributors wants the flexibility to quote and charge different prices to different customers,the QUOTED_PRICE column is included in the ORDER_LINE table.​

The SERVICE_CATEGORY table in the Solmaris Condominium Group database includes the service fee​

The item description is stored with the information about items.​

The _____ table includes the maximum number of people that can participate in a trip in the Colonial Adventure Tours database.​

The TRIP_GUIDES table in the Colonial Adventure Tours database is used to relate trips and guides.​

Database Design Fundamentals

Creating Tables

Single-Table Queries

Multiple-Table Queries

Updating Data

Database Administration

SQL Functions and Procedures

Filters

The table named ____________________ stores information about condo locations for Solmaris Condominium Group.

A(n)____________________ is a structure that contains different categories of information and the relationships between these categories.

Colonial Adventure Tours offers biking,hiking,and paddling trips.

List the three practical issues that would need to be dealt with if the ORDERS table and the ORDER_LINE table at TAL Distributors were combined?

At Solmaris Condominium Group,condo units are numbered differently at each location.

The ORDERS table consists of the order number,order date,and ____.

A category name uniquely identifies each service that Solmaris performs

Each order line at TAL Distributors contains a total,usually called a(n)____________________.

The REP table consists of the sales representatives' number,last name,first name,address,total commission,and ____.

The customer's name and address and the number of the sales rep who represents the customer are stored with sales rep information.

Because TAL Distributors wants the flexibility to quote and charge different prices to different customers,the QUOTED_PRICE column is included in the ORDER_LINE table.

The SERVICE_CATEGORY table in the Solmaris Condominium Group database includes the service fee

The item description is stored with the information about items.

The _____ table includes the maximum number of people that can participate in a trip in the Colonial Adventure Tours database.

The TRIP_GUIDES table in the Colonial Adventure Tours database is used to relate trips and guides.