A Guide to SQL 10th Edition by Philip J. Pratt , Mary Z. Last Test bank
A Guide to SQL
( Test Bank)
A Guide to SQL 10th Edition by Philip J. Pratt , Mary Z. Last Test bank
Edition: 10th Canadian
Author Name: Philip J. Pratt , Mary Z. Last
contact:
Whatsapp +1 (949) 734-4773
for the Facebook page click here
for more books for ( Test Bank and Solution Manual) click here
For Solution Manual click here
sample free
1. An example of a relationship between categories in the KimTay database is the relationship between sales reps and customers.
ANSWER: |
True |
FEEDBACK: |
Correct |
Each database also contains relationships between categories. For example, the KimTay Pet Supplies database contains information that relates sales reps to the customers they represent and customers to the invoices they have placed. |
Incorrect |
Each database also contains relationships between categories. For example, the KimTay Pet Supplies database contains information that relates sales reps to the customers they represent and customers to the invoices they have placed. |
|
POINTS: |
1 |
DIFFICULTY: |
Easy |
REFERENCES: |
What Is a Database? |
QUESTION TYPE: |
True / False |
HAS VARIABLES: |
False |
LEARNING OBJECTIVES: |
Guide to SQL.10e.1.1 – Introduce KimTay Pet Supplies, a company whose database is used to manage a pet supplies business. |
KEYWORDS: |
Bloom’s: Remember |
DATE CREATED: |
9/9/2020 1:37 PM |
DATE MODIFIED: |
9/29/2020 10:41 AM |
|
2. The StayWell database uses a combination of letters and numbers to identify each resident.
ANSWER: |
False |
FEEDBACK: |
Correct |
Each owner is identified by a unique owner number that consists of two uppercase letters followed by a three-digit number. |
Incorrect |
Each owner is identified by a unique owner number that consists of two uppercase letters followed by a three-digit number. |
|
POINTS: |
1 |
DIFFICULTY: |
Moderate |
REFERENCES: |
StayWell Student Accommodation Database |
QUESTION TYPE: |
True / False |
HAS VARIABLES: |
False |
LEARNING OBJECTIVES: |
Guide to SQL.10e.1.2 – Introduce StayWell, a Seattle-based company whose database is used to manage accommodation for university students on behalf of property owners. |
KEYWORDS: |
Bloom’s: Remember |
DATE CREATED: |
9/9/2020 1:37 PM |
DATE MODIFIED: |
9/29/2020 12:03 PM |
|
3. StayWell organizes a variety of maintenance services for a fee.
ANSWER: |
True |
FEEDBACK: |
Correct |
Currently, prospective owners and renters need to contact the offices and speak to an administrator on all matters relating to renting of properties. The office organizes maintenance services for a fee, which is also currently done via email or direct communication. |
Incorrect |
Currently, prospective owners and renters need to contact the offices and speak to an administrator on all matters relating to renting of properties. The office organizes maintenance services for a fee, which is also currently done via email or direct communication. |
|
POINTS: |
1 |
DIFFICULTY: |
Easy |
REFERENCES: |
StayWell Student Accommodation Database |
QUESTION TYPE: |
True / False |
HAS VARIABLES: |
False |
LEARNING OBJECTIVES: |
Guide to SQL.10e.1.2 – Introduce StayWell, a Seattle-based company whose database is used to manage accommodation for university students on behalf of property owners. |
KEYWORDS: |
Bloom’s: Remember |
DATE CREATED: |
9/9/2020 1:37 PM |
DATE MODIFIED: |
9/29/2020 12:23 PM |
|
4. The SERVICE_CATEGORY table in the StayWell database includes the service fees.
ANSWER: |
False |
FEEDBACK: |
Correct |
The SERVICE_CATEGORY table includes details of maintenance services. The CATEGORY_NUM provides a unique number for the service, and CATEGORY_DESCRIPTION shows what the service is. |
Incorrect |
The SERVICE_CATEGORY table includes details of maintenance services. The CATEGORY_NUM provides a unique number for the service, and CATEGORY_DESCRIPTION shows what the service is. |
|
POINTS: |
1 |
DIFFICULTY: |
Easy |
REFERENCES: |
StayWell Student Accommodation Database |
QUESTION TYPE: |
True / False |
HAS VARIABLES: |
False |
LEARNING OBJECTIVES: |
Guide to SQL.10e.1.2 – Introduce StayWell, a Seattle-based company whose database is used to manage accommodation for university students on behalf of property owners. |
KEYWORDS: |
Bloom’s: Remember |
DATE CREATED: |
9/9/2020 1:37 PM |
DATE MODIFIED: |
9/29/2020 12:27 PM |
|
There are no reviews yet.