MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Database
ER Model And Business Rules
Quiz 1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Q.1
Generalization is the process of defining more general entity types from a set of more specialized entity types.
True
False
Q.2
It is appropriate to use a supertype/subtype relationship when there are attributes that apply to some of the instances of an entity type.
True
False
Q.3
If an entity adheres to the disjoint rule, then an entity instance can be a member of more than one entity for a given supertype.
True
False
Q.4
Overlapping and disjoint subtypes have different approaches on how the subtype discriminator is applied.
True
False
Q.5
An entity instance of a subtype represents the same entity instance of a supertype.
True
False
Q.6
Action assertions have traditionally been implemented within an application program.
True
False
Q.7
An entity cluster is a set of one or more entity types and associated relationships.
True
False
Q.8
A supertype is an entity type that shares common attributes or relationships distinct from other subgroupings.
True
False
Q.9
An ERD that has had the entities clustered will display more entities.
True
False
Q.10
Total specialization is represented by double lines between the supertype and subtype on an EER.
True
False
Q.11
Packaged data models are meant to be exactly right straight out of the box.
True
False
Q.12
An action assertion is a statement that expresses some aspect of the static structure of the organization.
True
False
Q.13
A supertype can only have only one subtype.
True
False
Q.14
A subtype discriminator is which of the following?
An attribute of the supertype whose values determine the subtype
An attribute of the subtype whose values determine the supertype
An attribute of the supertype whose values determine the supertype
An attribute of the subtype whose values determine the subtype
Q.15
When an entity instance may be a member of multiple subtypes or it does not have to be a member of a subtype, it is which of the following?
Disjoint with total specialization
Disjoint with partial specialization
Overlap with total specialization
Overlap with partial specialization
Q.16
There is cardinality on an EER between the supertype and subtype.
True
False
Q.17
A subtype discriminator of the supertype is an attribute whose values determine the target subtype(s).
True
False
Q.18
A rectangle represents which of the following in an EER?
Attribute
Entity
Optional One
Relationship
Q.19
Which one of the following symbols is not used in an ERD?
Rectangle
Oval
Diamond
Circle
Q.20
A subtype entity name should be which of the following?
A singular noun
Specific to the organization
Concise
All of the above
0 h : 0 m : 1 s
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Report Question
×
What's an issue?
Question is wrong
Answer is wrong
Other Reason
Want to elaborate a bit more? (optional)
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page