Question 1

Solmaris provides a variety of maintenance services for a fee.​

Accepted Answer

A) True 
 B)False

Question 2

The overall order total is stored in the TAL Distributors database.​

Accepted Answer

A) True 
 B)False

Question 3

If another appointment is required to complete additional service,the appointment date appears in the NEXT_SERVICE_DATE column of the ____________________ table of Solmaris.​

Accepted Answer

The answer of If another appointment is required to complete...

Question 4

The TRIP table at Colonial Adventure Tours includes the guide number.​

Accepted Answer

A) True 
 B)False

Question 5

Colonial Adventure Tours gathers and organizes information about guides,trips,customers,and ____________________.​

Accepted Answer

The answer of Colonial Adventure Tours gathers and organizes information...

Question 6

The _____ field of the SERVICE_REQUEST table in the Solmaris Condominium Group database gives a description of the specific service to be performed.​

Accepted Answer

A) STATUS 
B) ​DESCRIPTION 
C) CATEGORY_DESCRIPTION 
D) ​SERVICE_DESCRIPTION 
A) STATUS 
B) ​DESCRIPTION 
C) CATEGORY_DESCRIPTION 
D) ​SERVICE_DESCRIPTION

Question 7

The item number appears in the ITEM table and the ____________________ table in the TAL Distributors database.​

Accepted Answer

The answer of The item number appears in the ITEM...

Question 8

Colonial Adventure Tours offers three types of trips;hiking,biking,and _____.​

Accepted Answer

A) downhill skiing 
B) ​cross country skiing 
C) zip lining 
D) ​paddling 
A) downhill skiing 
B) ​cross country skiing 
C) zip lining 
D) ​paddling

Question 9

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

Accepted Answer

The answer of The table named ____________________ is used to...

Question 10

Each line in the TAL Distributors order form contains an item number,the number of units of the ordered item,the quoted price,and ____.​

Accepted Answer

A) wholesale price 
B) ​item description 
C) item weight 
D) ​item color 
A) wholesale price 
B) ​item description 
C) item weight 
D) ​item color

Question 11

Each row in the ORDER_LINE table has an order number,item number,number ordered,quoted price,and total amount.​

Accepted Answer

A) True 
 B)False

Question 12

Colonial Adventure Tours uses the ____________________ field in the RESERVATION table to store any additional fees for transportation and equipment.​

Accepted Answer

The answer of Colonial Adventure Tours uses the ____________________ field...

Question 13

Which of the following tables relates guides to trips?​

Accepted Answer

A) TRIP 
B) ​GUIDE 
C) TRIP_GUIDES 
D) ​RESERVATION 
A) TRIP 
B) ​GUIDE 
C) TRIP_GUIDES 
D) ​RESERVATION

Question 14

Solmaris Condominium Group provides maintenance service for owners at its two condo locations.The SERVICE_CATEGORY table contains a _____.​

Accepted Answer

A) condo ID 
B) ​location number 
C) description of the category 
D) ​location name 
A) condo ID 
B) ​location number 
C) description of the category 
D) ​location name

Question 15

How many tables make up the TAL Distributors database?​

Accepted Answer

A) 4 
B) ​5 
C) 6 
D) ​7 
A) 4 
B) ​5 
C) 6 
D) ​7

Question 16

TAL Distributors sells appliances,toys,and kitchen gadgets.​

Accepted Answer

A) True 
 B)False

Question 17

Colonial Adventure Tours organizes day-long guided trips to ____.​

Accepted Answer

A) Colorado 
B) ​New England 
C) Virginia 
D) ​Pennsylvania 
A) Colorado 
B) ​New England 
C) Virginia 
D) ​Pennsylvania

Question 18

The customer number appears in the CUSTOMER table and the ____________________ table in the TAL Distributors database.​

Accepted Answer

The answer of The customer number appears in the CUSTOMER...

Question 19

Information about the services requested by Solmaris owners is stored in the ____ table.​

Accepted Answer

A) LOCATION 
B) ​CONDO_UNIT 
C) SERVICE_REQUEST 
D) ​OWNER 
A) LOCATION 
B) ​CONDO_UNIT 
C) SERVICE_REQUEST 
D) ​OWNER

Question 20

Solmaris stores information about its condo locations in the _____ table.​

Accepted Answer

A) CONDO 
B) ​CONDO_UNIT 
C) LOCATION 
D) ​OWNER 
A) CONDO 
B) ​CONDO_UNIT 
C) LOCATION 
D) ​OWNER

Solmaris provides a variety of maintenance services for a fee.

The overall order total is stored in the TAL Distributors database.

If another appointment is required to complete additional service,the appointment date appears in the NEXT_SERVICE_DATE column of the ____________________ table of Solmaris.

The TRIP table at Colonial Adventure Tours includes the guide number.

Colonial Adventure Tours gathers and organizes information about guides,trips,customers,and ____________________.

The _____ field of the SERVICE_REQUEST table in the Solmaris Condominium Group database gives a description of the specific service to be performed.

The item number appears in the ITEM table and the ____________________ table in the TAL Distributors database.

Colonial Adventure Tours offers three types of trips;hiking,biking,and _____.

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

Each line in the TAL Distributors order form contains an item number,the number of units of the ordered item,the quoted price,and ____.

Each row in the ORDER_LINE table has an order number,item number,number ordered,quoted price,and total amount.

Colonial Adventure Tours uses the ____________________ field in the RESERVATION table to store any additional fees for transportation and equipment.

Which of the following tables relates guides to trips?

Solmaris Condominium Group provides maintenance service for owners at its two condo locations.The SERVICE_CATEGORY table contains a _____.

How many tables make up the TAL Distributors database?

TAL Distributors sells appliances,toys,and kitchen gadgets.

Colonial Adventure Tours organizes day-long guided trips to ____.

The customer number appears in the CUSTOMER table and the ____________________ table in the TAL Distributors database.

Information about the services requested by Solmaris owners is stored in the ____ table.

Solmaris stores information about its condo locations in the _____ table.

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

Solmaris provides a variety of maintenance services for a fee.​

The overall order total is stored in the TAL Distributors database.​

If another appointment is required to complete additional service,the appointment date appears in the NEXT_SERVICE_DATE column of the ____________________ table of Solmaris.​

The TRIP table at Colonial Adventure Tours includes the guide number.​

Colonial Adventure Tours gathers and organizes information about guides,trips,customers,and ____________________.​

The _____ field of the SERVICE_REQUEST table in the Solmaris Condominium Group database gives a description of the specific service to be performed.​

The item number appears in the ITEM table and the ____________________ table in the TAL Distributors database.​

Colonial Adventure Tours offers three types of trips;hiking,biking,and _____.​

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

Each line in the TAL Distributors order form contains an item number,the number of units of the ordered item,the quoted price,and ____.​

Each row in the ORDER_LINE table has an order number,item number,number ordered,quoted price,and total amount.​

Colonial Adventure Tours uses the ____________________ field in the RESERVATION table to store any additional fees for transportation and equipment.​

Which of the following tables relates guides to trips?​

Solmaris Condominium Group provides maintenance service for owners at its two condo locations.The SERVICE_CATEGORY table contains a _____.​

How many tables make up the TAL Distributors database?​

TAL Distributors sells appliances,toys,and kitchen gadgets.​

Colonial Adventure Tours organizes day-long guided trips to ____.​

The customer number appears in the CUSTOMER table and the ____________________ table in the TAL Distributors database.​

Information about the services requested by Solmaris owners is stored in the ____ table.​

Solmaris stores information about its condo locations in the _____ table.​

Database Design Fundamentals

Creating Tables

Single-Table Queries

Multiple-Table Queries

Updating Data

Database Administration

SQL Functions and Procedures

Filters

Solmaris provides a variety of maintenance services for a fee.

The overall order total is stored in the TAL Distributors database.

If another appointment is required to complete additional service,the appointment date appears in the NEXT_SERVICE_DATE column of the ____________________ table of Solmaris.

The TRIP table at Colonial Adventure Tours includes the guide number.

Colonial Adventure Tours gathers and organizes information about guides,trips,customers,and ____________________.

The _____ field of the SERVICE_REQUEST table in the Solmaris Condominium Group database gives a description of the specific service to be performed.

The item number appears in the ITEM table and the ____________________ table in the TAL Distributors database.

Colonial Adventure Tours offers three types of trips;hiking,biking,and _____.

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

Each line in the TAL Distributors order form contains an item number,the number of units of the ordered item,the quoted price,and ____.

Each row in the ORDER_LINE table has an order number,item number,number ordered,quoted price,and total amount.

Colonial Adventure Tours uses the ____________________ field in the RESERVATION table to store any additional fees for transportation and equipment.

Which of the following tables relates guides to trips?

Solmaris Condominium Group provides maintenance service for owners at its two condo locations.The SERVICE_CATEGORY table contains a _____.

How many tables make up the TAL Distributors database?

TAL Distributors sells appliances,toys,and kitchen gadgets.

Colonial Adventure Tours organizes day-long guided trips to ____.

The customer number appears in the CUSTOMER table and the ____________________ table in the TAL Distributors database.

Information about the services requested by Solmaris owners is stored in the ____ table.

Solmaris stores information about its condo locations in the _____ table.