What important inheritance characteristic that all entity subtypes inherit from their supertype?

49 Questions  |  By Sonfackjoyce677 | Last updated: Mar 21, 2022 | Total Attempts: 157

Feedback

During the Quiz End of Quiz

Difficulty

Sequential Easy First Hard First

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

This is your description.

Questions: 30  |  Attempts: 1487   |  Last updated: Mar 21, 2022

• Sample Question

  How to deploy the script?
  

  GDE

  

  COMMAND LINE

  

  AIR COMMAND

  

  NONE

20 Questions each carries 1 mark and the time limit is 20mins

Questions: 20  |  Attempts: 611   |  Last updated: Mar 21, 2022

• Sample Question

  What is an Attribute?
  

  It is the charecteristics of a relation

  

  It is the charecteristics of entity

  

  It is the charecteristics of the table

  

  None

If you are very new to computers, or just want to test your knowledge, then it's a very basic computer skills test is for you. Even if you are applying for a job, and they have required you to take the basic computer skills...

Questions: 10  |  Attempts: 236959   |  Last updated: Apr 18, 2022

• Sample Question

  When you see no icons on the desktop, how can you open programs such as Microsoft Word?
  

  Right-click to reveal all icons

  

  Restart the computer

  

  It is not possible to open the program if no icons are on the desktop

  

  Click the start button and select program from the menu

More Database Management System Quizzes

• 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

+ Show more

What defines the relationship between a supertype entity and the subtype entities?

Are subtypes that contain a unique subset of the supertype entity set?

Do subtypes inherit relationships?

Is the process of defining one or more subtypes of the supertype and forming Supertype subtype relationships?