<header>
Author: Mark Shellman, Hassan Afyouni
Print ISBN:
Title: Guide to SQL, 10th Edi琀椀on
SSO ISBN:
Chapter Name: Introduc琀椀on to KimTay Pet Supplies and Staywell Student Accommoda琀椀on Database
Chapter Number: 1
Content Manager Contact: Michele Stulga
Content Creator: Sam Afyouni
Crea琀椀on Date: 8/20/2020
<header>
<ques琀椀on type="mc">
1. What is a database?
a. A database is a structure that contains di昀昀erent categories of informa琀椀on and the rela琀椀onships
between these categories.
b. A database is a structure that contains di昀昀erent informa琀椀on of categories.
c. A database is a structure that contains informa琀椀on about categories and the rela琀椀onships
between these categories.
d. A database is a structure that contains informa琀椀on about rela琀椀onships.
ANS: A
<ques琀椀on type="mc">
2. Which of the following is a valid KIMTAY database fact?
a. An INVOICE contains many customers.
b. A CUSTOMER may have many rela琀椀onships.
c. An ITEM is sold to only one customer in an invoice.
d. A sales representa琀椀ve represents only one customer.
ANS: C
<ques琀椀on type="mc">
3. Which table in the KIMTAY database is ITEM_ID found?
a. ITEM table
b. ITEM and INVOICES tables
c. INVOICES table
d. ITEM and INVOICE_LINE tables
ANS: D
<ques琀椀on type="mc">
4. What informa琀椀on is contained in the CUSTOMER table in the KIMTAY database?
a. Customer name, contact informa琀椀on, and invoice number.
b. Customer name, contact informa琀椀on, and customer representa琀椀ve.
c. Customer name, contact informa琀椀on, and items ordered.
d. Customer name, customer representa琀椀ve, and items ordered by customer.
ANS: B
,<ques琀椀on type="mc">
5.Which of the following is a table in the STAYWELL database?
a. OWNER
b. OWNER_NUM
c. FIREST_NAME
d. PROPERTY_ID
ANS: A
<ques琀椀on type="mc">
6.Which of the following is not a table in the STAYWELL database?
a. PROPERTY
b. ADDRESS
c. OWNER
d. RESIDENTS
ANS: B
<ques琀椀on type="mc">
7.Which of the following is a unique iden琀椀昀椀er?
a. OWNER
b. OWNER_ID
c. FIRST_NAME and LAST_NAME
d. OWNER_NAME
ANS: B
<ques琀椀on type="mc">
8.Which of the following is not a table in the KIMTAY database?
a. CUSTOMER
b. INVOICE_LINE
c. REPRESENTIVE
d. ITEM
ANS: C
,<header>
Author: Mark Shellman, Hassan Afyouni
Print ISBN:
Title: Guide to SQL, 10th Edi琀椀on
SSO ISBN:
Chapter Name: DATABASE DESIGN FUNDAMENTALS
Chapter Number: 2
Content Manager Contact: Michele Stulga
Content Creator: Sam Afyouni
Crea琀椀on Date: 8/20/2020
<header>
<ques琀椀on type="mc">
1. Which of the following statements is true?
a. A rela琀椀onal database is a collec琀椀on of related a琀琀ributes
b. A rela琀椀onal database is a collec琀椀on of rows
c. A rela琀椀onal database is a collec琀椀on of tables
d. All of the above
e. None of the above
ANS: C
<ques琀椀on type="mc">
2. Which of the following statements about func琀椀onal dependencies is true?
a. Column B is func琀椀onally dependent on another column when a value for B depends a single
value for A at any one 琀椀me.
b. Column B is func琀椀onally dependent on another column when a value for B is part of A.
c. Column B is func琀椀onally dependent on another column when a value for B determines a single
value for A at any one 琀椀me.
d. Column B is func琀椀onally dependent on another column when a value for A determines a single
value for B at any one 琀椀me.
ANS: D
<ques琀椀on type="mc">
3. A primary key is ______.
a. a unique iden琀椀昀椀er of a column
b. a unique iden琀椀昀椀er of a table
c. a column that iden琀椀昀椀es other columns in a table
d. an iden琀椀昀椀er of columns in a rela琀椀onal table
ANS: B
, <ques琀椀on type="mc">
4. When is a table is in 昀椀rst normal form (1NF)?
a. When a column is not part of unique iden琀椀昀椀er
b. When a table contains a unique iden琀椀昀椀er
c. When a column is not part of a repea琀椀ng group
d. When a table does not contain a repea琀椀ng group
ANS: D
<ques琀椀on type="mc">
5. Which of the following is not an en琀椀ty?
a. A person
b. A descrip琀椀on
c. A thing
d. An event
ANS: B
<ques琀椀on type="mc">
6. When is a rela琀椀on in second normal form (2NF)?
a. It is in 昀椀rst normal form and a nonkey column is dependent on only a por琀椀on of the primary key.
b. It is in 昀椀rst normal form and no nonkey column is dependent on only a por琀椀on of the primary
key.
c. It is in 昀椀rst normal form and no key column is dependent on only a por琀椀on of the primary key.
d. It is in 昀椀rst normal form and key column is dependent on only a por琀椀on of the primary key.
ANS: B
<ques琀椀on type="mc">
7. Which of the following is not a step of database design?
a. Iden琀椀fy the en琀椀琀椀es involved
b. Iden琀椀fy the unique iden琀椀昀椀ers for the en琀椀琀椀es
c. Iden琀椀fy the a琀琀ributes for all the en琀椀琀椀es
d. Iden琀椀fy the func琀椀onal dependencies that exist among the a琀琀ributes
e. All of the above
f. None of the above
ANS: F
<ques琀椀on type="mc">
8. Data anomalies are classi昀椀ed into which of the following four categories?
a. Updates, addi琀椀ons, dele琀椀ons, and unnormalized data
b. Updates, addi琀椀ons, dele琀椀ons, and concurrent data
c. Updates, addi琀椀ons, dele琀椀ons, and consistent data
d. Updates, addi琀椀ons, dele琀椀ons, and inconsistent data
ANS: D
<ques琀椀on type="mc">
Author: Mark Shellman, Hassan Afyouni
Print ISBN:
Title: Guide to SQL, 10th Edi琀椀on
SSO ISBN:
Chapter Name: Introduc琀椀on to KimTay Pet Supplies and Staywell Student Accommoda琀椀on Database
Chapter Number: 1
Content Manager Contact: Michele Stulga
Content Creator: Sam Afyouni
Crea琀椀on Date: 8/20/2020
<header>
<ques琀椀on type="mc">
1. What is a database?
a. A database is a structure that contains di昀昀erent categories of informa琀椀on and the rela琀椀onships
between these categories.
b. A database is a structure that contains di昀昀erent informa琀椀on of categories.
c. A database is a structure that contains informa琀椀on about categories and the rela琀椀onships
between these categories.
d. A database is a structure that contains informa琀椀on about rela琀椀onships.
ANS: A
<ques琀椀on type="mc">
2. Which of the following is a valid KIMTAY database fact?
a. An INVOICE contains many customers.
b. A CUSTOMER may have many rela琀椀onships.
c. An ITEM is sold to only one customer in an invoice.
d. A sales representa琀椀ve represents only one customer.
ANS: C
<ques琀椀on type="mc">
3. Which table in the KIMTAY database is ITEM_ID found?
a. ITEM table
b. ITEM and INVOICES tables
c. INVOICES table
d. ITEM and INVOICE_LINE tables
ANS: D
<ques琀椀on type="mc">
4. What informa琀椀on is contained in the CUSTOMER table in the KIMTAY database?
a. Customer name, contact informa琀椀on, and invoice number.
b. Customer name, contact informa琀椀on, and customer representa琀椀ve.
c. Customer name, contact informa琀椀on, and items ordered.
d. Customer name, customer representa琀椀ve, and items ordered by customer.
ANS: B
,<ques琀椀on type="mc">
5.Which of the following is a table in the STAYWELL database?
a. OWNER
b. OWNER_NUM
c. FIREST_NAME
d. PROPERTY_ID
ANS: A
<ques琀椀on type="mc">
6.Which of the following is not a table in the STAYWELL database?
a. PROPERTY
b. ADDRESS
c. OWNER
d. RESIDENTS
ANS: B
<ques琀椀on type="mc">
7.Which of the following is a unique iden琀椀昀椀er?
a. OWNER
b. OWNER_ID
c. FIRST_NAME and LAST_NAME
d. OWNER_NAME
ANS: B
<ques琀椀on type="mc">
8.Which of the following is not a table in the KIMTAY database?
a. CUSTOMER
b. INVOICE_LINE
c. REPRESENTIVE
d. ITEM
ANS: C
,<header>
Author: Mark Shellman, Hassan Afyouni
Print ISBN:
Title: Guide to SQL, 10th Edi琀椀on
SSO ISBN:
Chapter Name: DATABASE DESIGN FUNDAMENTALS
Chapter Number: 2
Content Manager Contact: Michele Stulga
Content Creator: Sam Afyouni
Crea琀椀on Date: 8/20/2020
<header>
<ques琀椀on type="mc">
1. Which of the following statements is true?
a. A rela琀椀onal database is a collec琀椀on of related a琀琀ributes
b. A rela琀椀onal database is a collec琀椀on of rows
c. A rela琀椀onal database is a collec琀椀on of tables
d. All of the above
e. None of the above
ANS: C
<ques琀椀on type="mc">
2. Which of the following statements about func琀椀onal dependencies is true?
a. Column B is func琀椀onally dependent on another column when a value for B depends a single
value for A at any one 琀椀me.
b. Column B is func琀椀onally dependent on another column when a value for B is part of A.
c. Column B is func琀椀onally dependent on another column when a value for B determines a single
value for A at any one 琀椀me.
d. Column B is func琀椀onally dependent on another column when a value for A determines a single
value for B at any one 琀椀me.
ANS: D
<ques琀椀on type="mc">
3. A primary key is ______.
a. a unique iden琀椀昀椀er of a column
b. a unique iden琀椀昀椀er of a table
c. a column that iden琀椀昀椀es other columns in a table
d. an iden琀椀昀椀er of columns in a rela琀椀onal table
ANS: B
, <ques琀椀on type="mc">
4. When is a table is in 昀椀rst normal form (1NF)?
a. When a column is not part of unique iden琀椀昀椀er
b. When a table contains a unique iden琀椀昀椀er
c. When a column is not part of a repea琀椀ng group
d. When a table does not contain a repea琀椀ng group
ANS: D
<ques琀椀on type="mc">
5. Which of the following is not an en琀椀ty?
a. A person
b. A descrip琀椀on
c. A thing
d. An event
ANS: B
<ques琀椀on type="mc">
6. When is a rela琀椀on in second normal form (2NF)?
a. It is in 昀椀rst normal form and a nonkey column is dependent on only a por琀椀on of the primary key.
b. It is in 昀椀rst normal form and no nonkey column is dependent on only a por琀椀on of the primary
key.
c. It is in 昀椀rst normal form and no key column is dependent on only a por琀椀on of the primary key.
d. It is in 昀椀rst normal form and key column is dependent on only a por琀椀on of the primary key.
ANS: B
<ques琀椀on type="mc">
7. Which of the following is not a step of database design?
a. Iden琀椀fy the en琀椀琀椀es involved
b. Iden琀椀fy the unique iden琀椀昀椀ers for the en琀椀琀椀es
c. Iden琀椀fy the a琀琀ributes for all the en琀椀琀椀es
d. Iden琀椀fy the func琀椀onal dependencies that exist among the a琀琀ributes
e. All of the above
f. None of the above
ANS: F
<ques琀椀on type="mc">
8. Data anomalies are classi昀椀ed into which of the following four categories?
a. Updates, addi琀椀ons, dele琀椀ons, and unnormalized data
b. Updates, addi琀椀ons, dele琀椀ons, and concurrent data
c. Updates, addi琀椀ons, dele琀椀ons, and consistent data
d. Updates, addi琀椀ons, dele琀椀ons, and inconsistent data
ANS: D
<ques琀椀on type="mc">
