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. - Answers - True
Which of the following is a unique identifier? - Answers - OWNER_ID
The invoice line in a KimTay invoice contains a total, which is usually called a(n) _____.
- Answers - extension
Which of the following is not a table in the STAYWELL database? - Answers -
ADDRESS
Why would you not combine the two tables INVOICES and INVOICE_LINE in the
KimTay database? - 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? - Answers - 5
Which of the following is not a table in the KIMTAY database? - Answers -
REPRESENTIVE
In the StayWell database, each rental property is identified by _____. - Answers - a
unique integer
Which table in the KIMTAY database is ITEM_ID found? - Answers - ITEM and
INVOICE_LINE tables
Which of the following is a valid KIMTAY database fact? - Answers - An ITEM is sold to
only one customer in an invoice.
Which of the following is a table in the STAYWELL database? - Answers - OWNER
In the following shorthand representation of a database, the underlined items are
_____.
INVOICES (INVOICE_NUM, INVOICE_DATE, CUST_ID)
INVOICE_LINE (INVOICE_NUM, ITEM_ID, QUANTITY, QUOTED_PRICE)
ITEM (ITEM_ID, DESCRIPTION, ON_HAND, CATEGORY, LOCATION, PRICE) -
Answers - primary keys
In a relational database, _____. - Answers - each row should be unique
An example of a relationship between categories in the KimTay database is the
relationship between sales reps and customers. - Answers - True
Which of the following is a unique identifier? - Answers - OWNER_ID
The invoice line in a KimTay invoice contains a total, which is usually called a(n) _____.
- Answers - extension
Which of the following is not a table in the STAYWELL database? - Answers -
ADDRESS
Why would you not combine the two tables INVOICES and INVOICE_LINE in the
KimTay database? - 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? - Answers - 5
Which of the following is not a table in the KIMTAY database? - Answers -
REPRESENTIVE
In the StayWell database, each rental property is identified by _____. - Answers - a
unique integer
Which table in the KIMTAY database is ITEM_ID found? - Answers - ITEM and
INVOICE_LINE tables
Which of the following is a valid KIMTAY database fact? - Answers - An ITEM is sold to
only one customer in an invoice.
Which of the following is a table in the STAYWELL database? - Answers - OWNER
In the following shorthand representation of a database, the underlined items are
_____.
INVOICES (INVOICE_NUM, INVOICE_DATE, CUST_ID)
INVOICE_LINE (INVOICE_NUM, ITEM_ID, QUANTITY, QUOTED_PRICE)
ITEM (ITEM_ID, DESCRIPTION, ON_HAND, CATEGORY, LOCATION, PRICE) -
Answers - primary keys
In a relational database, _____. - Answers - each row should be unique
