Database Design-Section 9 Quiz

Test: Section 9 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 9 Quiz
(Answer all questions in this section)

1. The explanation below is an example of which constraint type?
A column must contain only values consistent with the defined data format of the column Mark for Review
(1) Points


Entity integrity


Column integrity (*)


Referential integrity


User-defined integrity



Correct Correct


2. Identify all of the incorrect statements that complete this sentence: A primary key is...(Choose three) Mark for Review
(1) Points

(Choose all correct answers)


One or more columns in a table that uniquely identifies each row in that table.


Only one column that must be null. (*)


A single column that uniquely identifies each column in a table. (*)


A set of columns in one table that uniquely identifies each row in another table. (*)



Incorrect Incorrect. Refer to Section 9 Lesson 1.


3. A table does not have to have a primary key. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


4. A foreign key always refers to a primary key in the same table. True or False? Mark for Review
(1) Points


True


False (*)



Correct Correct


5. When translating an arc relationship to a physical design, you must turn the arc relationships into foreign keys. What additional step must you take with the created foreign keys to ensure the exclusivity principle of arc relationships? (Assume that you are implementing an Exclusive Design) (Choose Two) Mark for Review
(1) Points

(Choose all correct answers)


Make all relationships mandatory


Make all relationships optional (*)


Create an additional check constraint to verify that one foreign key is populated and the others are not (*)


All the above



Correct Correct


Page 1 of 3 Next Summary


Test: Section 9 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 9 Quiz
(Answer all questions in this section)

6. When mapping supertypes, relationships at the supertype level transform as usual. Relationships at the subtype level are implemented as foreign keys, but the foreign key columns all become optional. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


7. An "Arc Implementation" can be done just like any other Relationship - you simply add the required Foreign Keys. True or False? Mark for Review
(1) Points


True


False (*)



Incorrect Incorrect. Refer to Section 9 Lesson 4.


8. In a physical model, many to many relationships are resolved via a structure called a(n): ________________ Mark for Review
(1) Points


Intersection Table


Subtype


Intersection Entity (*)


Supertype



Incorrect Incorrect. Refer to Section 9 Lesson 3.


9. One-to-Many Optional to Mandatory becomes a _______________ on the Master table. Mark for Review
(1) Points


Unique Key


Optional Foreign Key (*)


Mandatory Foreign Key


Primary Key



Incorrect Incorrect. Refer to Section 9 Lesson 3.


10. It is possible to implement non-transferability via a simple Foreign Key Relationship. True or False? Mark for Review
(1) Points


True


False (*)



Incorrect Incorrect. Refer to Section 9 Lesson 3.


Previous Page 2 of 3 Next Summary


Test: Section 9 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 9 Quiz
(Answer all questions in this section)

11. An Arc is transformed to the physical model by adding a foeign Key for every relationship in the Arc. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


12. The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


13. The transformation from an ER diagram to a physical design involves changing terminology. Entities in the ER diagram become __________ : Mark for Review
(1) Points


Columns


Tables (*)


Unique Keys


Foreign Keys



Incorrect Incorrect. Refer to Section 9 Lesson 2.


14. In a physical data model, an attribute becomes a _____________. Mark for Review
(1) Points


Foreign Key


Constraint


Column (*)


Table



Incorrect Incorrect. Refer to Section 9 Lesson 2.


15. In a physical data model, a relationship is represented as a: Mark for Review
(1) Points


Column


Foreign Key (*)


Unique Identifier


Primary Key



Incorrect Incorrect. Refer to Section 9 Lesson 2.


Previous Page 3 of 3 Summary


Test: Section 9 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 9 Quiz
(Answer all questions in this section)

1. A table does not have to have a primary key. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


2. Identify all of the correct statements that complete this sentence: A primary key is: (Choose Three) Mark for Review
(1) Points

(Choose all correct answers)


A set of columns that uniquely identifies each row in a table (*)


A single column that uniquely identifies each row in a table (*)


A set of columns and keys in a single table that uniquely identifies each row in a single table (*)


Only one column that cannot be null



Correct Correct


3. The explanation below is an example of which constraint type?
If the value in the balance column of the ACCOUNTS table is below 100, we must send a letter to the account owner which will require extra programming to enforce. Mark for Review
(1) Points


User-defined integrity (*)


Entity integrity


Referential integrity


Column integrity



Incorrect Incorrect. Refer to Section 9 Lesson 1.


4. The explanation below is an example of which constraint type?
A column must contain only values consistent with the defined data format of the column Mark for Review
(1) Points


Entity integrity


Column integrity (*)


Referential integrity


User-defined integrity



Correct Correct


5. One-to-One relationships are transformed into Foreign Keys in the tables created at either end of that relationship. True or False? Mark for Review
(1) Points


True


False (*)



Correct Correct


Page 1 of 3 Next Summary


Test: Section 9 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 9 Quiz
(Answer all questions in this section)

6. To resolve a many to many relationship in a physical model you create a(n) ___________________? Mark for Review
(1) Points


Two tables with Foreign key constraints between them


Unique key constraints


Intersection entity


Intersection table (*)



Incorrect Incorrect. Refer to Section 9 Lesson 3.


7. It is possible to implement non-transferability via a simple Foreign Key Relationship. True or False? Mark for Review
(1) Points


True


False (*)



Correct Correct


8. The Oracle Database can implement a many to many relationship. You simply create two foreign keys between the two tables. True or False? Mark for Review
(1) Points


True


False (*)



Incorrect Incorrect. Refer to Section 9 Lesson 3.


9. Why would this table name NOT work in an Oracle database? this_year_end+next_year Mark for Review
(1) Points


Table names must begin with an alphabetic character.


It is too long.


The Plus sign + is not allowed in object names. (*)


None of the above.



Incorrect Incorrect. Refer to Section 9 Lesson 2.


10. In a physical data model, a relationship is represented as a combination of: (Choose Two) Mark for Review
(1) Points

(Choose all correct answers)


Column


Check Constraint or Unique Key


Primary Key or Unique Key (*)


Foreign Key (*)



Incorrect Incorrect. Refer to Section 9 Lesson 2.


Previous Page 2 of 3 Next Summary


Test: Section 9 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 9 Quiz
(Answer all questions in this section)

11. The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


12. In a physical data model, an attribute becomes a _____________. Mark for Review
(1) Points


Constraint


Table


Column (*)


Foreign Key



Correct Correct


13. When mapping supertypes, relationships at the supertype level transform as usual. Relationships at subtype level are implemented as foreign keys, but the foreign key columns all become mandatory. True or False? Mark for Review
(1) Points


True


False (*)



Incorrect Incorrect. Refer to Section 9 Lesson 4.


14. When mapping supertypes, relationships at the supertype level transform as usual. Relationships at the subtype level are implemented as foreign keys, but the foreign key columns all become optional. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


15. Which of the following is a valid reason for considering a Subtype Implementation? Mark for Review
(1) Points


Business functionality, business rules, access paths, and frequency of access are all very different between the subtypes. (*)


The resulting table will reside in a single database and be used by just ONE user.


The common access paths for the supertypes are different.


Most of the relationships are at the supertype level.



Incorrect Incorrect. Refer to Section 9 Lesson 4.


Previous Page 3 of 3 Summary


Test: Section 9 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 9 Quiz
(Answer all questions in this section)

1. When mapping supertypes, relationships at the supertype level transform as usual. Relationships at subtype level are implemented as foreign keys, but the foreign key columns all become mandatory. True or False? Mark for Review
(1) Points


True


False (*)



Correct Correct


2. When mapping supertypes, relationships at the supertype level transform as usual. Relationships at the subtype level are implemented as foreign keys, but the foreign key columns all become optional. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


3. An "Arc Implementation" can be done just like any other Relationship - you simply add the required Foreign Keys. True or False? Mark for Review
(1) Points


True


False (*)



Correct Correct


4. An Arc is transformed to the physical model by adding a foeign Key for every relationship in the Arc. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


5. Relationships on an ERD can only be transformed into UIDs in the physical model? True or False? Mark for Review
(1) Points


True


False (*)



Incorrect Incorrect. Refer to Section 9 Lesson 3.


Page 1 of 3 Next Summary


Test: Section 9 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 9 Quiz
(Answer all questions in this section)

6. One-to-One relationships are transformed into Foreign Keys in the tables created at either end of that relationship. True or False? Mark for Review
(1) Points


True


False (*)



Correct Correct


7. A barrred Relationship will result in a Foreign Key column that also is part of: Mark for Review
(1) Points


The Primary Key (*)


The Check Constraint


The Column Name


The Table Name



Correct Correct


8. The explanation below is an example of which constraint type?
If the value in the balance column of the ACCOUNTS table is below 100, we must send a letter to the account owner which will require extra programming to enforce. Mark for Review
(1) Points


Referential integrity


User-defined integrity (*)


Entity integrity


Column integrity



Correct Correct


9. The explanation below is an example of which constraint type?
A column must contain only values consistent with the defined data format of the column Mark for Review
(1) Points


Entity integrity


Referential integrity


User-defined integrity


Column integrity (*)



Correct Correct


10. The explanation below is an example of which constraint type?
A primary key must be unique, and no part of the primary key can be null. Mark for Review
(1) Points


Entity integrity (*)


Column integrity


User-defined integrity


Referential integrity



Incorrect Incorrect. Refer to Section 9 Lesson 1.


Previous Page 2 of 3 Next Summary


Test: Section 9 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 9 Quiz
(Answer all questions in this section)

11. A foreign key always refers to a primary key in the same table. True or False? Mark for Review
(1) Points


True


False (*)



Correct Correct


12. The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


13. In a physical data model, a relationship is represented as a combination of: (Choose Two) Mark for Review
(1) Points

(Choose all correct answers)


Check Constraint or Unique Key


Foreign Key (*)


Column


Primary Key or Unique Key (*)



Correct Correct


14. In a physical data model, an attribute becomes a _____________. Mark for Review
(1) Points


Foreign Key


Constraint


Table


Column (*)



Correct Correct


15. In an Oracle database, why would 1_TABLE not work as a table name? Mark for Review
(1) Points


There is no problem here. You can create a table called 1_TABLE.


TABLE is a reserved word.


The database does not understand all capital letters.


Object names must not start with a number. They must begin with a letter. (*)



Incorrect Incorrect. Refer to Section 9 Lesson 2.


Previous Page 3 of 3 Summary


Test: Section 9 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 9 Quiz
(Answer all questions in this section)

1. The explanation below is an example of which constraint type?
The value in the dept_no column of the EMPLOYEES table must match a value in the dept_no column in the DEPARTMENTS table. Mark for Review
(1) Points


Column integrity


User-defined integrity


Referential integrity (*)


Entity integrity



Incorrect Incorrect. Refer to Section 9 Lesson 1.


2. The explanation below is an example of which constraint type?
If the value in the balance column of the ACCOUNTS table is below 100, we must send a letter to the account owner which will require extra programming to enforce. Mark for Review
(1) Points


User-defined integrity (*)


Referential integrity


Column integrity


Entity integrity



Correct Correct


3. Foreign keys must be null. True or False? Mark for Review
(1) Points


True


False (*)



Incorrect Incorrect. Refer to Section 9 Lesson 1.


4. Identify all of the correct statements that complete this sentence: A primary key is: (Choose Three) Mark for Review
(1) Points

(Choose all correct answers)


A set of columns and keys in a single table that uniquely identifies each row in a single table (*)


Only one column that cannot be null


A single column that uniquely identifies each row in a table (*)


A set of columns that uniquely identifies each row in a table (*)



Correct Correct


5. One-to-Many Optional to Mandatory becomes a _______________ on the Master table. Mark for Review
(1) Points


Primary Key


Optional Foreign Key (*)


Mandatory Foreign Key


Unique Key



Correct Correct


Page 1 of 3 Next Summary


Test: Section 9 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 9 Quiz
(Answer all questions in this section)

6. A barrred Relationship will result in a Foreign Key column that also is part of: Mark for Review
(1) Points


The Column Name


The Table Name


The Primary Key (*)


The Check Constraint



Correct Correct


7. Two entities A and B have an optional (A) to Mandatory (B) One-to-One relationship. When they are transformed, the Foreign Key(s) is placed on: Mark for Review
(1) Points


The table B (*)


Both tables A and B get a new column and a Foreign Key.


Nowhere, One-to-One relationships are not transformed.


The table A



Incorrect Incorrect. Refer to Section 9 Lesson 3.


8. To resolve a many to many relationship in a physical model you create a(n) ___________________? Mark for Review
(1) Points


Intersection table (*)


Unique key constraints


Two tables with Foreign key constraints between them


Intersection entity



Correct Correct


9. When mapping supertypes, relationships at the supertype level transform as usual. Relationships at subtype level are implemented as foreign keys, but the foreign key columns all become mandatory. True or False? Mark for Review
(1) Points


True


False (*)



Correct Correct


10. The "Arc Implementation" is a synonym for what type of implementation? Mark for Review
(1) Points


Subtype Implementation


Supertype and Subtype Implementation (*)


Supertype Implementation


Cascade Implementation



Incorrect Incorrect. Refer to Section 9 Lesson 4.


Previous Page 2 of 3 Next Summary


Test: Section 9 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 9 Quiz
(Answer all questions in this section)

11. An "Arc Implementation" can be done just like any other Relationship - you simply add the required Foreign Keys. True or False? Mark for Review
(1) Points


True


False (*)



Correct Correct


12. In an Oracle database, why would 1_TABLE not work as a table name? Mark for Review
(1) Points


TABLE is a reserved word.


There is no problem here. You can create a table called 1_TABLE.


Object names must not start with a number. They must begin with a letter. (*)


The database does not understand all capital letters.



Correct Correct


13. In a physical data model, a relationship is represented as a: Mark for Review
(1) Points


Foreign Key (*)


Unique Identifier


Primary Key


Column



Correct Correct


14. In an Oracle database, why would the following table name not be allowed 'EMPLOYEE JOBS'? Mark for Review
(1) Points


EMPLOYEE is a reserved word


The database does not understand all capital letters


JOBS is a reserved word


You cannot have spaces between words in a table name (*)



Incorrect Incorrect. Refer to Section 9 Lesson 2.


15. The transformation from an ER diagram to a physical design involves changing terminology. Entities in the ER diagram become __________ : Mark for Review
(1) Points


Foreign Keys


Tables (*)


Columns


Unique Keys



Correct Correct


Previous Page 3 of 3 Summary


Test: Section 9 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 9 Quiz
(Answer all questions in this section)

1. In an Oracle database, why would 1_TABLE not work as a table name? Mark for Review
(1) Points


TABLE is a reserved word.


Object names must not start with a number. They must begin with a letter. (*)


There is no problem here. You can create a table called 1_TABLE.


The database does not understand all capital letters.



Correct Correct


2. In a physical data model, an entity becomes a _____________. Mark for Review
(1) Points


Attribute


Table (*)


Column


Constraint



Incorrect Incorrect. Refer to Section 9 Lesson 2.


3. The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


4. In a physical data model, an attribute becomes a _____________. Mark for Review
(1) Points


Constraint


Table


Column (*)


Foreign Key



Correct Correct


5. An "Arc Implementation" can be done just like any other Relationship - you simply add the required Foreign Keys. True or False? Mark for Review
(1) Points


True


False (*)



Correct Correct


Page 1 of 3 Next Summary


Test: Section 9 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 9 Quiz
(Answer all questions in this section)

6. When translating an arc relationship to a physical design, you must turn the arc relationships into foreign keys. What additional step must you take with the created foreign keys to ensure the exclusivity principle of arc relationships? (Assume that you are implementing an Exclusive Design) (Choose Two) Mark for Review
(1) Points

(Choose all correct answers)


Make all relationships mandatory


Make all relationships optional (*)


Create an additional check constraint to verify that one foreign key is populated and the others are not (*)


All the above



Correct Correct


7. When mapping supertypes, relationships at the supertype level transform as usual. Relationships at the subtype level are implemented as foreign keys, but the foreign key columns all become optional. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


8. A barrred Relationship will result in a Foreign Key column that also is part of: Mark for Review
(1) Points


The Primary Key (*)


The Check Constraint


The Table Name


The Column Name



Correct Correct


9. The Oracle Database can implement a many to many relationship. You simply create two foreign keys between the two tables. True or False? Mark for Review
(1) Points


True


False (*)



Correct Correct


10. One-to-One relationships are transformed into Foreign Keys in the tables created at either end of that relationship. True or False? Mark for Review
(1) Points


True


False (*)



Correct Correct


Previous Page 2 of 3 Next Summary


Test: Section 9 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 9 Quiz
(Answer all questions in this section)

11. Two entities A and B have an optional (A) to Mandatory (B) One-to-One relationship. When they are transformed, the Foreign Key(s) is placed on: Mark for Review
(1) Points


Nowhere, One-to-One relationships are not transformed.


The table B (*)


Both tables A and B get a new column and a Foreign Key.


The table A



Correct Correct


12. Foreign keys cannot be null when Mark for Review
(1) Points


It refers to the same table


It contains three or more columns


It is part of a primary key (*)


It refers to another table



Correct Correct


13. The explanation below is an example of which constraint type?
A column must contain only values consistent with the defined data format of the column Mark for Review
(1) Points


Column integrity (*)


Referential integrity


Entity integrity


User-defined integrity



Correct Correct


14. The explanation below is an example of which constraint type?
A primary key must be unique, and no part of the primary key can be null. Mark for Review
(1) Points


User-defined integrity


Column integrity


Entity integrity (*)


Referential integrity



Incorrect Incorrect. Refer to Section 9 Lesson 1.


15. Identify all of the incorrect statements that complete this sentence: A primary key is...(Choose three) Mark for Review
(1) Points

(Choose all correct answers)


Only one column that must be null. (*)


A set of columns in one table that uniquely identifies each row in another table. (*)


One or more columns in a table that uniquely identifies each row in that table.


A single column that uniquely identifies each column in a table. (*)



Correct Correct


Previous Page 3 of 3 Summary