A Guide to SQL Study Set 2

Computing

Quiz 1 :

Introduction to Kimtay Pet Supplies and Staywell Student Accommodation Databases

Quiz 1 :

Introduction to Kimtay Pet Supplies and Staywell Student Accommodation Databases

Question Type
search
arrow
The SERVICE_CATEGORY table in the StayWell database includes the service fees.
Free
True False
Answer:

Answer:

False

Tags
Choose question tag
close menu
arrow
StayWell provides maintenance services across the properties they manage. The SERVICE_CATEGORY table in their database contains a _____.
Free
Multiple Choice
Answer:

Answer:

C

Tags
Choose question tag
close menu
arrow
Information about the services requested by StayWell residents is stored in the _____ table.
Free
Multiple Choice
Answer:

Answer:

C

Tags
Choose question tag
close menu
arrow
Each line in a KimTay invoice contains an item ID, the number of units of the item ordered, the quoted price, and ____.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The StayWell database uses a combination of letters and numbers to identify each resident.
True False
Answer:
Tags
Choose question tag
close menu
arrow
The KimTay INVOICES table consists of the invoice number, invoice date, and _____.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
An example of a relationship between categories in the KimTay database is the relationship between sales reps and customers.
True False
Answer:
Tags
Choose question tag
close menu
arrow
StayWell organizes a variety of maintenance services for a fee.
True False
Answer:
Tags
Choose question tag
close menu
arrow
In general, when designing tables, which type of structure is most preferable?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
StayWell rents out and helps to maintain _____.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
An owner number in the OWNER table in the StayWell database consists of _____ uppercase letters followed by a three-digit number.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Combining the INVOICE_LINE and INVOICES tables in the KimTay database will _____.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
StayWell stores information about the facilities where student residents live in the _____ table.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
StayWell has twelve offices, one to manage each of their twelve rental locations.
True False
Answer:
Tags
Choose question tag
close menu
arrow
The invoice line in a KimTay invoice contains a total, which is usually called a(n) _____.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The SALES_REP table consists of the sales representatives' IDs, first names, last names, addresses, mobile numbers, total commissions, and _____.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Each row in the PROPERTY table in the StayWell database contains a property _____ that identifies that particular property.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
KimTay sells _____.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Which field of the SERVICE_REQUEST table in the StayWell database indicates the issue reported by the resident who made the request?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
How many tables make up the KimTay database?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
Showing 1 - 20 of 36