Oracle Database Quiz Section 7 Quiz Answer

Image Source : dqindia.com

1.     Which of the following would best be represented by an arc?
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?
True
False (*)

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

4.     An arc can often be modeled as Supertype and Subtypes. True or False?
True (*)
False

5.     Which of the following would best be represented by an arc?
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?
True
False (*)

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

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

9.     Cascading UIDs are a feature often found in what type of Relationship? 
Invalid Relationship
Recursive Relationship
General Relationship
Hierarchical Relationship (*)

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

11.  A Recursive Relationship is represented on an ERD by a/an:
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?
True
False (*)

13.  Business organizational charts are often modeled as a Hierarchical relationship. True or False?
True (*)
False

14.  A recursive relationship must be Mandatory at both ends. True or False?
True
False (*)

15.  A Hierarchical relationship is a series of relationships that reflect entities organized into successive levels. True or False?
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?
True (*)
False

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

3.     A Recursive Relationship is represented on an ERD by a/an:
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?
True (*)
False

5.     A relationship between an entity and itself is called a/an:
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?
True (*)
False

7.     Cascading UIDs are a feature often found in what type of Relationship?
Recursive Relationship
General Relationship
Invalid Relationship
Hierarchical Relationship (*)

8.     Which of the following would best be represented by an arc?
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 ________.
Relationship
Arc (*)
UID
Attribute

10.  All relationships participating in an arc must be mandatory. True or False?
True
False (*)

11.  An arc can often be modeled as Supertype and Subtypes. True or False?
True (*)
False

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

13.  Which of the following can be added to a relationship?
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?
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?
True
False (*)

1.     A relationship between an entity and itself is called a/an:
Invalid Relationship
Recursive Relationship (*)
General Relationship
Hierarchical Relationship

2.     A recursive relationship must be Mandatory at both ends. True or False?
True
False (*)

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

4.     A single relationship can be both Recursive and Hierarchical at the same time. True or False?
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?
True (*)
False

6.     Business organizational charts are often modeled as a Hierarchical relationship. True or False?
True (*)
False

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

8.     Which of the following can be added to a relationship?
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:
Attributes
Constraints. (*)
Entities.
Relationships

10.  Which of the following would best be represented by an arc?
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?
True (*)
False

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

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

14.  Arcs model an Exclusive OR constraint. True or False?
True (*)
False

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

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

2.     Arcs model an Exclusive OR constraint. True or False?
True (*)
False

3.     An arc can often be modeled as Supertype and Subtypes. True or False?
True (*)
False

4.     Which of the following would best be represented by an arc?
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 ________.
UID
Arc (*)
Attribute
Relationship

6.     Which of the following would best be represented by an arc?
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.
Exclusivity (*)
Differences
Inheritance
Sameness

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

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

10.  A recursive relationship must be Mandatory at both ends. True or False?
True
False (*)

11.  Cascading UIDs are a feature often found in what type of Relationship?
Recursive Relationship
General Relationship
Hierarchical Relationship (*)
Invalid Relationship

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

13.  A Recursive Relationship is represented on an ERD by a/an:
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?
True (*)
False

15.  Business organizational charts are often modeled as a Hierarchical relationship. True or False?
True (*)
False

Share :