Section 7 Quiz Database Design Oracle

Section 7 Quiz
(Answer all questions in this section)


1. Which of the following would best be represented by an arc? Mark for Review
(1) Points
STUDENT (senior, male)
STUDENT (Grade A student, Average Student)
STUDENT (graduating, female)
STUDENT ( University, Technical College) (*)


2. Arcs are Mandatory in Data modeling. All ERD's must have at least one Arc. True or False? Mark for Review
(1) Points
True
False (*)


3. To visually represent exclusivity between two or more relationships in an ERD you would most likely use an ________. Mark for Review
(1) Points
Arc (*)
Relationship
Attribute
UID


4. An arc can often be modeled as Supertype and Subtypes. True or False? Mark for Review
(1) Points
True (*)
False


5. Which of the following would best be represented by an arc? Mark for Review
(1) Points
TEACHER (Female, Bob)
PARENT (Girl, Bob)
DELIVERY ADDRESS (Home, Office) (*)
STUDENT (Grade A student, Average Student)


6. All relationships participating in an arc must be mandatory. True or False? Mark for Review
(1) Points
True
False (*)


7. Every business has restrictions on which attribute values and which relationships are allowed. These are known as: Mark for Review
(1) Points
Constraints. (*)
Relationships
Entities.
Attributes


8. Arcs are used to visually represent _________ between two or more relationships in an ERD. Mark for Review
(1) Points
Differences
Inheritance
Sameness
Exclusivity (*)


9. Cascading UIDs are a feature often found in what type of Relationship? Mark for Review
(1) Points
Invalid Relationship
Recursive Relationship
General Relationship
Heirarchical Relationship (*)


10. A relationship between an entity and itself is called a/an: Mark for Review
(1) Points
Recursive Relationship (*)
Invalid Relationship
Heirarchical Relationship
General Relationship


11. A Recursive Relationship is represented on an ERD by a/an: Mark for Review
(1) Points
Single Toe
Pig's Ear (*)
Crow's Foot
Dog's Tail


12. A single relationship can be both Recursive and Hierarchical at the same time. True or False? Mark for Review
(1) Points
True
False (*)


13. Business organizational charts are often modeled as a Hierarchical relationship. True or False? Mark for Review
(1) Points
True (*)
False


14. A recursive relationship must be Mandatory at both ends. True or False? Mark for Review
(1) Points
True
False (*)


15. A Hierarchical relationship is a series of relationships that reflect entities organized into successive levels. True or False? Mark for Review
(1) Points
True (*)
False


1. A particular problem may be solved using either a Recursive Relationship or a Hierarchical Relationship, though not at the same time. True or False? Mark for Review
(1) Points
True (*)
False


2. A single relationship can be both Recursive and Hierarchical at the same time. True or False? Mark for Review
(1) Points
True
False (*)


3. A Recursive Relationship is represented on an ERD by a/an: Mark for Review
(1) Points
Single Toe
Dog's Tail
Pig's Ear (*)
Crow's Foot


4. Business organizational charts are often modeled as a Hierarchical relationship. True or False? Mark for Review
(1) Points
True (*)
False


5. A relationship between an entity and itself is called a/an: Mark for Review
(1) Points
General Relationship
Recursive Relationship (*)
Heirarchical Relationship
Invalid Relationship


6. A Hierarchical relationship is a series of relationships that reflect entities organized into successive levels. True or False? Mark for Review
(1) Points
True (*)
False


7. Cascading UIDs are a feature often found in what type of Relationship? Mark for Review
(1) Points
Recursive Relationship
General Relationship
Invalid Relationship
Heirarchical Relationship (*)


8. Which of the following would best be represented by an arc? Mark for Review
(1) Points
STUDENT (senior, male)
STUDENT ( University, Technical College) (*)
STUDENT (Grade A student, Average Student)
STUDENT (graduating, female)


9. To visually represent exclusivity between two or more relationships in an ERD you would most likely use an ________. Mark for Review
(1) Points
Relationship
Arc (*)
UID
Attribute


10. All relationships participating in an arc must be mandatory. True or False? Mark for Review
(1) Points
True
False (*)


11. An arc can often be modeled as Supertype and Subtypes. True or False? Mark for Review
(1) Points
True (*)
False


12. Arcs are used to visually represent _________ between two or more relationships in an ERD. Mark for Review
(1) Points
Sameness
Differences
Exclusivity (*)
Inheritance


13. Which of the following can be added to a relationship? Mark for Review
(1) Points
An optional attribute can be created
A composite attribute
An attribute
An arc can be assigned (*)


14. Which of the following would best be represented by an arc? Mark for Review
(1) Points
TEACHER (Female, Bob)
STUDENT (Grade A student, Average Student)
DELIVERY ADDRESS (Home, Office) (*)
PARENT (Girl, Bob)


15. Arcs are Mandatory in Data modeling. All ERD's must have at least one Arc. True or False? Mark for Review
(1) Points
True
False (*)


1. A relationship between an entity and itself is called a/an: Mark for Review
(1) Points
Invalid Relationship
Recursive Relationship (*)
General Relationship
Heirarchical Relationship


2. A recursive relationship must be Mandatory at both ends. True or False? Mark for Review
(1) Points
True
False (*)


3. A Hierarchical relationship is a series of relationships that reflect entities organized into successive levels. True or False? Mark for Review
(1) Points
True (*)
False


4. A single relationship can be both Recursive and Hierarchical at the same time. True or False? Mark for Review
(1) Points
True
False (*)


5. A particular problem may be solved using either a Recursive Relationship or a Hierarchical Relationship, though not at the same time. True or False? Mark for Review
(1) Points
True (*)
False


6. Business organizational charts are often modeled as a Hierarchical relationship. True or False? Mark for Review
(1) Points
True (*)
False


7. A Recursive Relationship is represented on an ERD by a/an: Mark for Review
(1) Points
Single Toe
Pig's Ear (*)
Crow's Foot
Dog's Tail


8. Which of the following can be added to a relationship? Mark for Review
(1) Points
An arc can be assigned (*)
An optional attribute can be created
An attribute
A composite attribute


9. Every business has restrictions on which attribute values and which relationships are allowed. These are known as: Mark for Review
(1) Points
Attributes
Constraints. (*)
Entities.
Relationships


10. Which of the following would best be represented by an arc? Mark for Review
(1) Points
TEACHER (Female, Bob)
DELIVERY ADDRESS (Home, Office) (*)
PARENT (Girl, Bob)
STUDENT (Grade A student, Average Student)


11. An arc can often be modeled as Supertype and Subtypes. True or False? Mark for Review
(1) Points
True (*)
False


12. Arcs are Mandatory in Data modeling. All ERD's must have at least one Arc. True or False? Mark for Review
(1) Points
True
False (*)


13. To visually represent exclusivity between two or more relationships in an ERD you would most likely use an ________. Mark for Review
(1) Points
Attribute
Relationship
UID
Arc (*)


14. Arcs model an Exclusive OR constraint. True or False? Mark for Review
(1) Points
True (*)
False


15. Arcs are used to visually represent _________ between two or more relationships in an ERD. Mark for Review
(1) Points
Differences
Sameness
Exclusivity (*)
Inheritance


1. All relationships participating in an arc must be mandatory. True or False? Mark for Review
(1) Points
True
False (*)


2. Arcs model an Exclusive OR constraint. True or False? Mark for Review
(1) Points
True (*)
False


3. An arc can often be modeled as Supertype and Subtypes. True or False? Mark for Review
(1) Points
True (*)
False


4. Which of the following would best be represented by an arc? Mark for Review
(1) Points
STUDENT (Grade A student, Average Student)
TEACHER (Female, Bob)
DELIVERY ADDRESS (Home, Office) (*)
PARENT (Girl, Bob)


5. To visually represent exclusivity between two or more relationships in an ERD you would most likely use an ________. Mark for Review
(1) Points
UID
Arc (*)
Attribute
Relationship


6. Which of the following would best be represented by an arc? Mark for Review
(1) Points
STUDENT (graduating, female)
STUDENT ( University, Technical College) (*)
STUDENT (Grade A student, Average Student)
STUDENT (senior, male)


7. Arcs are used to visually represent _________ between two or more relationships in an ERD. Mark for Review
(1) Points
Exclusivity (*)
Differences
Inheritance
Sameness


8. Every business has restrictions on which attribute values and which relationships are allowed. These are known as: Mark for Review
(1) Points
Entities.
Relationships
Constraints. (*)
Attributes


9. A single relationship can be both Recursive and Hierarchical at the same time. True or False? Mark for Review
(1) Points
True
False (*)


10. A recursive relationship must be Mandatory at both ends. True or False? Mark for Review
(1) Points
True
False (*)


11. Cascading UIDs are a feature often found in what type of Relationship? Mark for Review
(1) Points
Recursive Relationship
General Relationship
Heirarchical Relationship (*)
Invalid Relationship


12. A Hierarchical relationship is a series of relationships that reflect entities organized into successive levels. True or False? Mark for Review
(1) Points
True (*)
False


13. A Recursive Relationship is represented on an ERD by a/an: Mark for Review
(1) Points
Crow's Foot
Single Toe
Pig's Ear (*)
Dog's Tail


14. A particular problem may be solved using either a Recursive Relationship or a Hierarchical Relationship, though not at the same time. True or False? Mark for Review
(1) Points
True (*)
False


15. Business organizational charts are often modeled as a Hierarchical relationship. True or False? Mark for Review
(1) Points
True (*)

False