DBMS EXAM 1 QUESTIONS AND ANSWERS
An example of a relationship between categories in the KimTay database is the
relationship between sales reps and customers. - Correct Answers -True
Which of the following is a unique identifier? - Correct Answers -OWNER_ID
The invoice line in a KimTay invoice contains a total, which is usually called a(n) _____.
- Correct Answers -extension
Which of the following is not a table in the STAYWELL database? - Correct Answers -
ADDRESS
Why would you not combine the two tables INVOICES and INVOICE_LINE in the
KimTay database? - Correct Answers -If the two tables were combined, the new table
would be more complicated. Some of the individual positions within this table would
contain multiple entries, making it difficult to track the information between columns.
Determining which invoices contained invoice lines for a given item would be tricky. In
general, the simpler structure is preferable, and that is why invoice lines appear in a
separate table.
How many tables make up the KimTay database? - Correct Answers -5
What information is contained in the CUSTOMER table in the KIMTAY database? -
Correct Answers -Customer name, contact information, and customer representative.
The statement "A sales rep's pay class functionally determines his or her pay rate"
means that if you know the pay class, you can determine the pay rate. - Correct
Answers -True
Why have Social Security numbers traditionally been used as primary keys for database
tables that store personal data on individual people? - Correct Answers -All other
columns in such a table are functionally dependent on the Social Security number
column.
Which statement regarding primary keys is true? - Correct Answers -Some tables
include more than one column that can be used as a primary key.
The SERVICE_CATEGORY table in the StayWell database includes the service fees. -
Correct Answers -False
Combining the INVOICE_LINE and INVOICES tables in the KimTay database will
_____. - Correct Answers -make the table more complicated
An example of a relationship between categories in the KimTay database is the
relationship between sales reps and customers. - Correct Answers -True
Which of the following is a unique identifier? - Correct Answers -OWNER_ID
The invoice line in a KimTay invoice contains a total, which is usually called a(n) _____.
- Correct Answers -extension
Which of the following is not a table in the STAYWELL database? - Correct Answers -
ADDRESS
Why would you not combine the two tables INVOICES and INVOICE_LINE in the
KimTay database? - Correct Answers -If the two tables were combined, the new table
would be more complicated. Some of the individual positions within this table would
contain multiple entries, making it difficult to track the information between columns.
Determining which invoices contained invoice lines for a given item would be tricky. In
general, the simpler structure is preferable, and that is why invoice lines appear in a
separate table.
How many tables make up the KimTay database? - Correct Answers -5
What information is contained in the CUSTOMER table in the KIMTAY database? -
Correct Answers -Customer name, contact information, and customer representative.
The statement "A sales rep's pay class functionally determines his or her pay rate"
means that if you know the pay class, you can determine the pay rate. - Correct
Answers -True
Why have Social Security numbers traditionally been used as primary keys for database
tables that store personal data on individual people? - Correct Answers -All other
columns in such a table are functionally dependent on the Social Security number
column.
Which statement regarding primary keys is true? - Correct Answers -Some tables
include more than one column that can be used as a primary key.
The SERVICE_CATEGORY table in the StayWell database includes the service fees. -
Correct Answers -False
Combining the INVOICE_LINE and INVOICES tables in the KimTay database will
_____. - Correct Answers -make the table more complicated
