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: 1475 | Last updated: Mar 21, 2022
-
Sample QuestionHow to deploy the script?
Questions: 20 | Attempts: 607 | Last updated: Mar 21, 2022
-
Sample QuestionWhat is an Attribute?
Questions: 10 | Attempts: 224546 | Last updated: Apr 18, 2022
-
Sample QuestionWhen you see no icons on the desktop, how can you open programs such as Microsoft Word?
- Binary Code Quizzes
- Computer Concept Quizzes
- Computer Essential Quizzes
- Computer Forensics Quizzes
- Computer Hardware Quizzes
- Computer Networking Quizzes
- Computer Parts Quizzes
- Computer Programming Quizzes
- Computer Science Quizzes
- Computer Security Quizzes
- Computer Shortcut Key Quizzes
- Computer Skills Quizzes
- Computer Virus Quizzes
- Cyber Security Quizzes
- Data Quizzes
- Data Security Quizzes
- Hacking Quizzes
- Hci Quizzes
- Internet Quizzes
- It Security Quizzes
- Malware Quizzes
- Microprocessor Quizzes
- Network Quizzes
- Operating System Quizzes
- Phishing Quizzes
- Programming Language Quizzes
- Server Quizzes
- Software Quizzes
Back to top