Oracle Database Quiz Section 3 Quiz Answer
 |
| Image Source : dqindia.com |
1. What are the three properties that every relationship should have?
Name, optionality, cardinality (*)
A UID bar, a diamond, an arc
Name, optionality, arcs
Transferability, degree, name
Name, optionality, cardinality (*)
A UID bar, a diamond, an arc
Name, optionality, arcs
Transferability, degree, name
2.
Relationships can be either mandatory or
optional. True or False?
True (*)
False
True (*)
False
3.
In a business that sells pet food, choose the
best relationship name between FOOD TYPE and ANIMAL (e.g. dog, horse, or cat).
(Choose Two)
Each ANIMAL must be the seller of one or more FOOD TYPES.
Each FOOD TYPE may be manufactured by one or more ANIMALs.
Each FOOD TYPE must be suitable for one or more ANIMALs. (*)
Each FOOD TYPE may be given to one or more ANIMALs. (*)
Each ANIMAL must be the seller of one or more FOOD TYPES.
Each FOOD TYPE may be manufactured by one or more ANIMALs.
Each FOOD TYPE must be suitable for one or more ANIMALs. (*)
Each FOOD TYPE may be given to one or more ANIMALs. (*)
4.
One Relationship can be mandatory in one
direction and optional in the other direction. True or False?
True (*)
False
True (*)
False
5.
Which of the following are used to show
Cardinality on an ERD? (Choose two)
Crow's foot. (*)
Solid line.
Single toe. (*)
Dashed line.
Crow's foot. (*)
Solid line.
Single toe. (*)
Dashed line.
6.
Which of the following are true about
Cardinality? (Choose two)
Cardinality tells "how many". (*)
Cardinality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.
Cardinality specifies whether something is required or not.
Cardinality specifies only singularity or plurality, but not a specific plural number. (*)
Cardinality tells "how many". (*)
Cardinality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.
Cardinality specifies whether something is required or not.
Cardinality specifies only singularity or plurality, but not a specific plural number. (*)
7.
Which symbol is used to show that a particular
attribute is mandatory?
&
#
o
* (*)
&
#
o
* (*)
8.
Entity boxes are drawn as
Soft Boxes (*)
Hard Boxes
Normal Circles
Bold Circles
Soft Boxes (*)
Hard Boxes
Normal Circles
Bold Circles
9.
ERDish describes a relationship in words. True or
False?
True (*)
False
True (*)
False
10.
Which of the following are used to show a
relationship on an ERD? (Choose Three)
Dashed line. (*)
Crow's foot. (*)
Solid line. (*)
# symbol.
Dashed line. (*)
Crow's foot. (*)
Solid line. (*)
# symbol.
11.
When reading a relationship between 2 entities,
the relationship is read both from left to right and right to left. True or
False?
True (*)
False
True (*)
False
12.
Relationship names are not shown on an ERD. True
or False?
True
False (*)
True
False (*)
13.
Matrix Diagrams show Optionality and Cardinality
of the ERDs they document. True or False?
True
False (*)
True
False (*)
14.
Matrix Diagrams are developed BEFORE the ERD.
True or False?
True (*)
False
True (*)
False
15.
Matrix Diagrams are used to verify that all
relationships have been identified for an ERD. True or False?
True (*)
False
True (*)
False
1.
Which of the following are used to show a
relationship on an ERD? (Choose Three)
# symbol.
Solid line. (*)
Dashed line. (*)
Crow's foot. (*)
# symbol.
Solid line. (*)
Dashed line. (*)
Crow's foot. (*)
2.
Relationship names are not shown on an ERD. True
or False?
True
False (*)
True
False (*)
3.
When reading the relationships in an ERD, you are
said to be speaking:
Entity-ish
Gibberish
ERDish (*)
Relationship-ish
Entity-ish
Gibberish
ERDish (*)
Relationship-ish
4.
ERDish describes a relationship in words. True or
False?
True (*)
False
True (*)
False
5.
What are the three properties that every
relationship should have?
Name, optionality, arcs
Transferability, degree, name
Name, optionality, cardinality (*)
A UID bar, a diamond, an arc
Name, optionality, arcs
Transferability, degree, name
Name, optionality, cardinality (*)
A UID bar, a diamond, an arc
6.
Relationships can be either mandatory or
optional. True or False?
True (*)
False
True (*)
False
7.
Which of the following are used to show
Cardinality on an ERD? (Choose two)
Single toe. (*)
Dashed line.
Crow's foot. (*)
Solid line.
Single toe. (*)
Dashed line.
Crow's foot. (*)
Solid line.
8.
Relationships always exist between
3 or more attributes
3 or more entities
2 entities (or one entity and itself) (*)
2 attributes
3 or more attributes
3 or more entities
2 entities (or one entity and itself) (*)
2 attributes
9.
In a business that sells pet food, choose the
best relationship name between FOOD TYPE and ANIMAL (e.g. dog, horse, or cat).
(Choose Two)
Each ANIMAL must be the seller of one or more FOOD TYPES.
Each FOOD TYPE may be given to one or more ANIMALs. (*)
Each FOOD TYPE may be manufactured by one or more ANIMALs.
Each FOOD TYPE must be suitable for one or more ANIMALs. (*)
Each ANIMAL must be the seller of one or more FOOD TYPES.
Each FOOD TYPE may be given to one or more ANIMALs. (*)
Each FOOD TYPE may be manufactured by one or more ANIMALs.
Each FOOD TYPE must be suitable for one or more ANIMALs. (*)
10.
Which of
the following are true about Cardinality? (Choose two)
Cardinality specifies whether something is required or not.
Cardinality specifies only singularity or plurality, but not a specific plural number. (*)
Cardinality tells "how many". (*)
Cardinality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.
Cardinality specifies whether something is required or not.
Cardinality specifies only singularity or plurality, but not a specific plural number. (*)
Cardinality tells "how many". (*)
Cardinality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.
11.
To
identify an attribute as part of a unique identifier on an ER diagram, the #
symbol goes in front of it. True or False?
True (*)
False
True (*)
False
12.
Entity
names are always singular. True or False?
True (*)
False
True (*)
False
13.
Matrix
Diagrams show Optionality and Cardinality of the ERDs they document. True or
False?
True
False (*)
True
False (*)
14.
Matrix
Diagrams are developed BEFORE the ERD. True or False?
True (*)
False
True (*)
False
15.
Matrix
Diagrams are used to verify that all relationships have been identified for an
ERD. True or False?
True (*)
False
True (*)
False
1.
Entity
names are always singular. True or False?
True (*)
False
True (*)
False
2.
Entity
boxes are drawn as
Normal Circles
Hard Boxes
Soft Boxes (*)
Bold Circles
Normal Circles
Hard Boxes
Soft Boxes (*)
Bold Circles
3.
Relationship names are not shown on an ERD.
True or False?
True
False (*)
True
False (*)
4.
ERDish
describes a relationship in words. True or False?
True (*)
False
True (*)
False
5.
Which of the following are used to show a
relationship on an ERD? (Choose Three)
Crow's foot. (*)
Solid line. (*)
# symbol.
Dashed line. (*)
Crow's foot. (*)
Solid line. (*)
# symbol.
Dashed line. (*)
6.
When reading a relationship between 2 entities,
the relationship is read both from left to right and right to left. True or
False?
True (*)
False
True (*)
False
7.
Which of the following are true about
Cardinality? (Choose two)
Cardinality specifies whether something is required or not.
Cardinality tells "how many". (*)
Cardinality specifies only singularity or plurality, but not a specific plural number. (*)
Cardinality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.
Cardinality specifies whether something is required or not.
Cardinality tells "how many". (*)
Cardinality specifies only singularity or plurality, but not a specific plural number. (*)
Cardinality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.
8.
Which of the following are true about
Relationship Optionality? (Choose two)
Optionality specifies only singularity or plurality, but not a specific plural number.
Optionality answers "may or must". (*)
Optionality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.
Optionality specifies whether something is required or not. (*)
Optionality specifies only singularity or plurality, but not a specific plural number.
Optionality answers "may or must". (*)
Optionality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.
Optionality specifies whether something is required or not. (*)
9.
In a business that sells pet food, choose the
best relationship name between FOOD TYPE and ANIMAL (e.g. dog, horse, or cat).
(Choose Two)
Each FOOD TYPE may be given to one or more ANIMALs. (*)
Each FOOD TYPE may be manufactured by one or more ANIMALs.
Each FOOD TYPE must be suitable for one or more ANIMALs. (*)
Each ANIMAL must be the seller of one or more FOOD TYPES.
Each FOOD TYPE may be given to one or more ANIMALs. (*)
Each FOOD TYPE may be manufactured by one or more ANIMALs.
Each FOOD TYPE must be suitable for one or more ANIMALs. (*)
Each ANIMAL must be the seller of one or more FOOD TYPES.
10.
What are the three properties that every
relationship should have?
Transferability, degree, name
Name, optionality, arcs
Name, optionality, cardinality (*)
A UID bar, a diamond, an arc
Transferability, degree, name
Name, optionality, arcs
Name, optionality, cardinality (*)
A UID bar, a diamond, an arc
11.
Relationship Cardinality is important. True or
False?
True (*)
False
True (*)
False
12.
Relationships can be either mandatory or
optional. True or False?
True (*)
False
True (*)
False
13.
Matrix Diagrams are used to verify that all
relationships have been identified for an ERD. True or False?
True (*)
False
True (*)
False
14.
Matrix Diagrams are developed BEFORE the ERD.
True or False?
True (*)
False
True (*)
False
15.
Matrix Diagrams show Optionality and Cardinality
of the ERDs they document. True or False?
True
False (*)
True
False (*)
1.
Entity boxes are drawn as
Normal Circles
Hard Boxes
Bold Circles
Soft Boxes (*)
Normal Circles
Hard Boxes
Bold Circles
Soft Boxes (*)
2.
Entity
names are always singular. True or False?
True (*)
False
True (*)
False
3.
Matrix
Diagrams are developed BEFORE the ERD. True or False?
True (*)
False
True (*)
False
4.
Matrix
Diagrams show Optionality and Cardinality of the ERDs they document. True or
False?
True
False (*)
True
False (*)
5.
Matrix Diagrams are used to verify that all
relationships have been identified for an ERD. True or False?
True (*)
False
True (*)
False
6.
Which of the following are used to show a
relationship on an ERD? (Choose Three)
# symbol.
Dashed line. (*)
Crow's foot. (*)
Solid line. (*)
# symbol.
Dashed line. (*)
Crow's foot. (*)
Solid line. (*)
7.
When reading the relationships in an ERD, you are
said to be speaking:
Entity-ish
Relationship-ish
Gibberish
ERDish (*)
Entity-ish
Relationship-ish
Gibberish
ERDish (*)
8.
Relationship names are not shown on an ERD. True
or False?
True
False (*)
True
False (*)
9.
ERDish describes a relationship in words. True or
False?
True (*)
False
True (*)
False
10.
Which of the following are true about
Relationship Optionality? (Choose two)
Optionality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.
Optionality answers "may or must". (*)
Optionality specifies only singularity or plurality, but not a specific plural number.
Optionality specifies whether something is required or not. (*)
Optionality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.
Optionality answers "may or must". (*)
Optionality specifies only singularity or plurality, but not a specific plural number.
Optionality specifies whether something is required or not. (*)
11.
One Relationship can be mandatory in one
direction and optional in the other direction. True or False?
True (*)
False
True (*)
False
12.
Relationships always exist between
3 or more attributes
3 or more entities
2 entities (or one entity and itself) (*)
2 attributes
3 or more attributes
3 or more entities
2 entities (or one entity and itself) (*)
2 attributes
13.
Which of the following are true about
Cardinality? (Choose two)
Cardinality specifies whether something is required or not.
Cardinality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.
Cardinality tells "how many". (*)
Cardinality specifies only singularity or plurality, but not a specific plural number. (*)
Cardinality specifies whether something is required or not.
Cardinality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.
Cardinality tells "how many". (*)
Cardinality specifies only singularity or plurality, but not a specific plural number. (*)
14.
Which of the following are used to show
Cardinality on an ERD? (Choose two)
Single toe. (*)
Crow's foot. (*)
Dashed line.
Solid line.
Single toe. (*)
Crow's foot. (*)
Dashed line.
Solid line.
15.
What are the three properties that every
relationship should have?
A UID bar, a diamond, an arc
Transferability, degree, name
Name, optionality, cardinality (*)
Name, optionality, arcs
A UID bar, a diamond, an arc
Transferability, degree, name
Name, optionality, cardinality (*)
Name, optionality, arcs