Filters
Question type

Study Flashcards

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 _____.


A) table
B) database
C) digital template
D) spreadsheet

E) A) and B)
F) None of the above

Correct Answer

verifed

verified

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


A) total sales
B) commission rates
C) customers
D) invoice numbers

E) A) and B)
F) All of the above

Correct Answer

verifed

verified

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


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

E) B) and D)
F) A) and B)

Correct Answer

verifed

verified

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


A) including a QUOTED_PRICE column in the INVOICE_LINE table
B) including a PRICE column in the ITEM table
C) using the prices from the ITEM table in the invoice body
D) omitting price information from the ITEM table

E) B) and D)
F) A) and B)

Correct Answer

verifed

verified

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


A) LOCATION
B) PROPERTY
C) SERVICE_REQUEST
D) OWNER

E) None of the above
F) All of the above

Correct Answer

verifed

verified

The StayWell database's OWNER table _____.


A) includes property IDs
B) omits property IDs
C) includes single rows with multiple data entries
D) cannot be easily cross-referenced to the PROPERTY table

E) B) and C)
F) None of the above

Correct Answer

verifed

verified

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


A) SALES_REP
B) INVOICES
C) ITEM
D) INVOICE_LINE

E) B) and C)
F) A) and D)

Correct Answer

verifed

verified

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 _____.


A) an overseas call center
B) live administrators taking phone calls
C) advertisements in student-facing publications
D) mobile apps and online booking systems

E) None of the above
F) A) and B)

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

No; there are no direct relationships be...

View Answer

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


A) a combination of letters and numbers
B) a unique integer
C) a unique character value
D) the owner's owner ID

E) A) and D)
F) A) and C)

Correct Answer

verifed

verified

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


A) top
B) heading
C) body
D) footing

E) A) and B)
F) None of the above

Correct Answer

verifed

verified

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


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

E) B) and D)
F) A) and B)

Correct Answer

verifed

verified

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


A) inventory report
B) sales rep directory
C) invoice
D) customer directory

E) B) and C)
F) A) and D)

Correct Answer

verifed

verified

KimTay sells _____.


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

E) All of the above
F) A) and D)

Correct Answer

verifed

verified

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


A) RENTAL_UNIT
B) OFFICE
C) PROPERTY
D) OWNER

E) None of the above
F) All of the above

Correct Answer

verifed

verified

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


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

E) A) and B)
F) All of the above

Correct Answer

verifed

verified

Showing 21 - 36 of 36

Related Exams

Show Answer