A Guide to SQL Test Questions with Correct Answers Latest Update 2025
To determine how many Pump & Filter Kits are available in the warehouse, a KimTay employee would
need to consult which database table? - Answers ITEM
StayWell has twelve offices, one to manage each of their twelve rental locations. - Answers False
When a StayWell property is owned by more than one person, the OWNER table includes _____. -
Answers only the primary contact
Information about the services requested by StayWell residents is stored in the _____ table. - Answers
SERVICE_REQUEST
If a StayWell administrator needs to know where a resident lives, he or she should consult which tables?
- Answers RESIDENTS and PROPERTY
The SALES_REP table consists of the sales representatives' IDs, first names, last names, addresses,
mobile numbers, total commissions, and _____. - Answers commission rates
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 _____. - Answers mobile apps and online
booking systems
KimTay's database allows sales reps to sell the same item for different prices by _____. - Answers
including a QUOTED_PRICE column in the INVOICE_LINE table
How many tables make up the KimTay database? - Answers 5
The SERVICE_CATEGORY table in the StayWell database includes the service fees. - Answers False
In general, when designing tables, which type of structure is most preferable? - Answers simple
In the StayWell database, each rental property is identified by _____. - Answers a unique integer
Each line in a KimTay invoice contains an item ID, the number of units of the item ordered, the quoted
price, and ____. - Answers an item description
Can an administrator at StayWell use their database to determine which student resident put in a
request for maintenance? Explain why or why not. - Answers Because multiple people are living in the
same building it would be hard to track.
The StayWell database's OWNER table _____. - Answers omits property IDs
The KimTay database stores several items for each customer's invoice, including the _____. - Answers
invoice date
, The KimTay database must combine data from all of its tables in order to print a(n) _____. - Answers
invoice
The StayWell database includes OWNER and PROPERTY tables. Both tables have columns with the
owner numbers, but the OWNER table does not have a column associating property IDs with owners.
Why is this? - Answers There are more properties than owners because some owners have multiple
properties.
Why would you not combine the two tables INVOICES and INVOICE_LINE in the KimTay database? -
Answers Some of the individual positions in the table contain multiple entire, making harder to to track
the information between columns.
The StayWell database uses a combination of letters and numbers to identify each resident. - Answers
False
An example of a relationship between categories in the KimTay database is the relationship between
sales reps and customers. - Answers True
Which field of the SERVICE_REQUEST table in the StayWell database indicates the issue reported by the
resident who made the request? - Answers DESCRIPTION
The KimTay INVOICES table consists of the invoice number, invoice date, and _____. - Answers customer
ID
Combining the INVOICE_LINE and INVOICES tables in the KimTay database will _____. - Answers make
the table more complicated
The invoice line in a KimTay invoice contains a total, which is usually called a(n) _____. - Answers
extension
Name and briefly describe the tables in the StayWell database. - Answers Office contains the location,
name and office number of the two offices.
Owner contains the first and last name, address and owner number of the owner.
Property has the property id, office number, address, the amount of square footage, rooms, and floors,
as well as the monthly rent and owner number.
Service Category has the category number and description.
Service Request shows the request the residents have made.
Residents has the first and last name, property id, and resident id.
StayWell stores information about the facilities where student residents live in the _____ table. -
Answers PROPERTY
To determine how many Pump & Filter Kits are available in the warehouse, a KimTay employee would
need to consult which database table? - Answers ITEM
StayWell has twelve offices, one to manage each of their twelve rental locations. - Answers False
When a StayWell property is owned by more than one person, the OWNER table includes _____. -
Answers only the primary contact
Information about the services requested by StayWell residents is stored in the _____ table. - Answers
SERVICE_REQUEST
If a StayWell administrator needs to know where a resident lives, he or she should consult which tables?
- Answers RESIDENTS and PROPERTY
The SALES_REP table consists of the sales representatives' IDs, first names, last names, addresses,
mobile numbers, total commissions, and _____. - Answers commission rates
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 _____. - Answers mobile apps and online
booking systems
KimTay's database allows sales reps to sell the same item for different prices by _____. - Answers
including a QUOTED_PRICE column in the INVOICE_LINE table
How many tables make up the KimTay database? - Answers 5
The SERVICE_CATEGORY table in the StayWell database includes the service fees. - Answers False
In general, when designing tables, which type of structure is most preferable? - Answers simple
In the StayWell database, each rental property is identified by _____. - Answers a unique integer
Each line in a KimTay invoice contains an item ID, the number of units of the item ordered, the quoted
price, and ____. - Answers an item description
Can an administrator at StayWell use their database to determine which student resident put in a
request for maintenance? Explain why or why not. - Answers Because multiple people are living in the
same building it would be hard to track.
The StayWell database's OWNER table _____. - Answers omits property IDs
The KimTay database stores several items for each customer's invoice, including the _____. - Answers
invoice date
, The KimTay database must combine data from all of its tables in order to print a(n) _____. - Answers
invoice
The StayWell database includes OWNER and PROPERTY tables. Both tables have columns with the
owner numbers, but the OWNER table does not have a column associating property IDs with owners.
Why is this? - Answers There are more properties than owners because some owners have multiple
properties.
Why would you not combine the two tables INVOICES and INVOICE_LINE in the KimTay database? -
Answers Some of the individual positions in the table contain multiple entire, making harder to to track
the information between columns.
The StayWell database uses a combination of letters and numbers to identify each resident. - Answers
False
An example of a relationship between categories in the KimTay database is the relationship between
sales reps and customers. - Answers True
Which field of the SERVICE_REQUEST table in the StayWell database indicates the issue reported by the
resident who made the request? - Answers DESCRIPTION
The KimTay INVOICES table consists of the invoice number, invoice date, and _____. - Answers customer
ID
Combining the INVOICE_LINE and INVOICES tables in the KimTay database will _____. - Answers make
the table more complicated
The invoice line in a KimTay invoice contains a total, which is usually called a(n) _____. - Answers
extension
Name and briefly describe the tables in the StayWell database. - Answers Office contains the location,
name and office number of the two offices.
Owner contains the first and last name, address and owner number of the owner.
Property has the property id, office number, address, the amount of square footage, rooms, and floors,
as well as the monthly rent and owner number.
Service Category has the category number and description.
Service Request shows the request the residents have made.
Residents has the first and last name, property id, and resident id.
StayWell stores information about the facilities where student residents live in the _____ table. -
Answers PROPERTY
