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
I really appreciate the information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in #IBM #INFORMATION #ANALYZER, kindly Contact MaxMunus
BalasHapusMaxMunus Offer World Class Virtual Instructor-led training on #IBM #INFORMATION #ANALYZER. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 1,00,000 + training in India, USA, UK, Australia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain, and UAE etc.
Avishek Priyadarshi
MaxMunus
E-mail: avishek@maxmunus.com
Skype id: avishek_2.
Ph:(0) 8553177744 / 080 - 41103383
www.MaxMunus.com