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