A) furniture B) pet supplies C) sporting goods D) electronic games A) furniture B) pet supplies C) sporting goods D) electronic games

Exam 1: Introduction to Kimtay Pet Supplies and Staywell Student Accommodation Databases

To determine how many Pump & Filter Kits are available in the warehouse, a KimTay employee would need to consult which database table?

(Multiple Choice)

4.8/5

(32)

Question 21

The StayWell database's OWNER table _____.

(Multiple Choice)

4.7/5

(33)

Question 22

KimTay sells _____.

(Multiple Choice)

4.8/5

(41)

Question 23

The KimTay database must combine data from all of its tables in order to print a(n) _____.

(Multiple Choice)

4.9/5

(30)

Question 24

Can an administrator at StayWell use their database to determine which student resident put in a request for maintenance? Explain why or why not.

(Essay)

4.8/5

(35)

Question 25

Each row in the PROPERTY table in the StayWell database contains a property _____ that identifies that particular property.

(Multiple Choice)

4.9/5

(46)

Question 26

In the StayWell database, each rental property is identified by _____.

(Multiple Choice)

4.9/5

(36)

Question 27

The SALES_REP table consists of the sales representatives' IDs, first names, last names, addresses, mobile numbers, total commissions, and _____.

(Multiple Choice)

4.8/5

(39)

Question 28

Though they haven't yet achieved an e-commerce-based business status, in the future, StayWell would like to be able to use their database in conjunction with _____.

(Multiple Choice)

4.9/5

(42)

Question 29

The invoice line in a KimTay invoice contains a total, which is usually called a(n) _____.

(Multiple Choice)

4.8/5

(41)

Question 30

Information about the services requested by StayWell residents is stored in the _____ table.

(Multiple Choice)

4.8/5

(42)

Question 31

KimTay's management would like to set up a structure that contains different categories of information and the relationships between these categories. In other words, they want a _____.

(Multiple Choice)

4.8/5

(37)

Question 32

Which field of the SERVICE_REQUEST table in the StayWell database indicates the issue reported by the resident who made the request?

(Multiple Choice)

4.8/5

(33)

Question 33

StayWell stores information about the facilities where student residents live in the _____ table.

(Multiple Choice)

4.9/5

(36)

Question 34

KimTay's database allows sales reps to sell the same item for different prices by _____.

(Multiple Choice)

4.8/5

(37)

Question 35

At KimTay, the invoice total appears in which section of the invoice?

(Multiple Choice)

4.8/5

(32)

Question 36

Showing 21 - 36 of 36

To determine how many Pump & Filter Kits are available in the warehouse, a KimTay employee would need to consult which database table?

The StayWell database's OWNER table _____.

KimTay sells _____.

The KimTay database must combine data from all of its tables in order to print a(n) _____.

Can an administrator at StayWell use their database to determine which student resident put in a request for maintenance? Explain why or why not.

Each row in the PROPERTY table in the StayWell database contains a property _____ that identifies that particular property.

In the StayWell database, each rental property is identified by _____.

The SALES_REP table consists of the sales representatives' IDs, first names, last names, addresses, mobile numbers, total commissions, and _____.

Though they haven't yet achieved an e-commerce-based business status, in the future, StayWell would like to be able to use their database in conjunction with _____.

The invoice line in a KimTay invoice contains a total, which is usually called a(n) _____.

Information about the services requested by StayWell residents is stored in the _____ table.

KimTay's management would like to set up a structure that contains different categories of information and the relationships between these categories. In other words, they want a _____.

Which field of the SERVICE_REQUEST table in the StayWell database indicates the issue reported by the resident who made the request?

StayWell stores information about the facilities where student residents live in the _____ table.

KimTay's database allows sales reps to sell the same item for different prices by _____.

At KimTay, the invoice total appears in which section of the invoice?

Database Design Fundamentals

Creating Tables

Single Table Queries

Multiple Table Queries

Updating Data

Database Administration

Functions Procedures and Triggers

Filters