Database Management Ultimate Quiz!
Do you know what is database management? Database management allows the user to organize, store and retrieve information from a computer. It can also describe the data storage, operations, and security practices of a database administrator. This quiz will require you to know things like how entity subtypes and supertypes are organized in a specialization hierarchy and important inheritance characteristics. This quiz will teach you about database management and what it entails.
- 1.Entity supertypes and subtypes are organized in a specialization hierarchy.
- A.
True
- B.
False
- 2.Within a specialization hierarchy, a supertype can exist only within the context of a subtype.
- A.
True
- B.
False
- 3.The entity supertype contains the common characteristics and the entity subtypes contain the unique characteristics of each entity subtype.
- A.
True
- B.
False
- 4.The property of the subtype discriminator enables an entity supertype to inherit the attributes and relationships of the subtype.
- A.
True
- B.
False
- 5.One important inheritance characteristic is that all entity subtypes inherit their primary key attribute from their supertype.
- A.
True
- B.
False
- 6.At the implementation level, the supertype and its subtype(s) depicted in the specialization hierarchy maintain a 1:1 relationship.
- A.
True
- B.
False
- 7.Entity subtypes do not inherit the relationships in which the supertype entity participates.
- A.
True
- B.
False
- 8.In specialization hierarchies with multiple levels of supertype/subtypes, a lower-level supertype inherits all of the attributes and relationships from all of its upper-level subtypes.
- A.
True
- B.
False
- 9.An entity supertype can have disjoint or overlapping entity subtypes.
- A.
True
- B.
False
- 10.Overlapping subtypes are subtypes that contain a unique subset of the supertype entity set.
- A.
True
- B.
False
- 11.Disjoint subtypes are subtypes that contain nonunique subsets of the supertype entity set.
- A.
True
- B.
False
- 12.Implementing non-overlapping subtypes requires the use of one discriminator attribute for each subtype.
- A.
True
- B.
False
- 13.The completeness constraint can be partial or total.
- A.
True
- B.
False
- 14.Generalization is based on grouping unique characteristics and relationships of the subtypes.
- A.
True
- B.
False
- 15.Specialization is the top-down process of identifying lower-level, more specific entity subtypes from a higher-level entity supertype.
- A.
True
- B.
False
- 16.An entity cluster is a "virtual" entity type used to represent multiple entities and relationships in the ERD.
- A.
True
- B.
False
- 17.To model time-variant data, you must create a new entity in an M:N relationship with the original entity.
- A.
True
- B.
False
- 18.A design trap occurs when a relationship is improperly or incompletely identified and, therefore, is represented in a way that is not consistent with the real world.
- A.
True
- B.
False
- 19.Some designs use redundant relationships as a way to simplify the design.
- A.
True
- B.
False
- 20.The extended entity relationship model (EERM) is sometimes referred to as the ____.
- A.
Entity relationship model
- B.
Enhanced entity relationship model
- C.
Entity clustering relationship model
- D.
Extended entity relationship diagram
- 21.____ is a generic entity type that is related to one or more entity subtypes.
- A.
A subtype discriminator
- B.
Inheritance
- C.
A specialization hierarchy
- D.
An entity supertype
- 22.The ____ depicts the arrangement of higher-level entity supertypes (parent entities) and lower-level entity subtypes (child entities).
- A.
Subtype discriminator
- B.
Inheritance
- C.
Specialization hierarchy
- D.
Entity supertype
- 23.The relationships depicted within the ____ are sometimes described in terms of "is-a" relationships.
- A.
Subtype discriminator
- B.
Inheritance
- C.
Specialization hierarchy
- D.
Entity supertype
- 24.Every subtype can have ____ supertype(s) to which it is directly related.
- A.
Zero
- B.
Only one
- C.
One or many
- D.
Many
- 25.A specialization hierarchy can have ____ level(s) of supertype/subtype relationships.
- A.
Zero
- B.
Only one
- C.
One or many
- D.
Many
Questions: 30 | Attempts: 1446 | Last updated: Oct 17, 2013
-
Sample QuestionHow to deploy the script?
Questions: 15 | Attempts: 39427 | Last updated: Jun 11, 2020
-
Sample QuestionLet's start with an easy one. What does CPU stand for?
Questions: 10 | Attempts: 30983 | Last updated: Jan 13, 2021
-
Sample QuestionThe acronym PC stands for:
Back to top