Quiz # 2 (Chapter 3 & 4)

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Inciit
I
Inciit
Community Contributor
Quizzes Created: 1 | Total Attempts: 171
Questions: 12 | Attempts: 171

SettingsSettingsSettings
Quiz # 2 (Chapter 3 & 4) - Quiz

Spring 2010, Database System Quiz # 2


Questions and Answers
  • 1. 

    If an attribute has different number of values for each entity, it will be modeled as:

    • A.

      Atomic

    • B.

      Composite

    • C.

      Derived

    • D.

      Multivalued

    Correct Answer
    D. Multivalued
    Explanation
    If an attribute has different number of values for each entity, it will be modeled as multivalued. This means that the attribute can have multiple values for a single entity. For example, if we have an attribute called "phone number" and some entities have one phone number while others have multiple phone numbers, then this attribute would be considered multivalued.

    Rate this question:

  • 2. 

    Each simple attribute of an entity type is associated with a value set, which specified the set of values that may be assigned to that attribute for each individual entity. This value set is called

    • A.

      Attribute

    • B.

      Entity

    • C.

      Domain

    • D.

      Constraint

    Correct Answer
    C. Domain
    Explanation
    The correct answer is "Domain". In the context of entity types, each simple attribute is associated with a value set, which specifies the set of values that can be assigned to that attribute for each individual entity. This value set is called the domain. The domain defines the range of valid values for an attribute and helps enforce data integrity by restricting the values that can be assigned to the attribute.

    Rate this question:

  • 3. 

    The key attribute is chosen after carefully studying the

    • A.

      ER Diagram

    • B.

      Text Book

    • C.

      User Requirements

    • D.

      DBMS

    Correct Answer
    C. User Requirements
    Explanation
    The key attribute is chosen after carefully studying the user requirements. This implies that the selection of the key attribute is based on the specific needs and preferences of the users. By analyzing the user requirements, one can identify the essential attributes that are crucial for the functioning and effectiveness of the system. Therefore, the user requirements serve as a guide in determining the key attribute for the system.

    Rate this question:

  • 4. 

    The basic object that the ER model represents is 

    • A.

      Entity

    • B.

      Cardinality

    • C.

      Participation

    • D.

      Relationship

    Correct Answer
    A. Entity
    Explanation
    The ER model represents the basic object as an entity. In the ER model, an entity is a real-world object or concept that has attributes and can be uniquely identified. Entities are used to represent the main objects of interest in a database, such as customers, employees, or products. They are depicted as rectangles in an ER diagram and are connected through relationships to other entities. The entity is the fundamental building block of the ER model and is used to define the structure and organization of a database.

    Rate this question:

  • 5. 

    The attribute which is not divisible and has only one meaning is called a

    • A.

      Derived Attribute

    • B.

      Atomic Attribute

    • C.

      Composite Attribute

    • D.

      Single Attribute

    Correct Answer
    B. Atomic Attribute
    Explanation
    An atomic attribute is a single attribute that cannot be divided further and has only one meaning. It represents a single piece of information about an entity or a relationship. Unlike composite attributes, which are made up of multiple sub-attributes, atomic attributes are indivisible and cannot be broken down into smaller components. Therefore, the correct answer is atomic attribute.

    Rate this question:

  • 6. 

    Entity types which can not exists independently are called

    • A.

      1:1

    • B.

      Strong

    • C.

      Weak

    • D.

      Derived

    Correct Answer
    C. Weak
    Explanation
    Weak entity types are entity types that cannot exist independently and depend on another entity for their existence. They have a partial or total dependency on the identifying entity, known as the owner entity. Weak entities are identified by their relationship with the owner entity, and they typically have a weak key that includes the owner entity's primary key as part of their own primary key. Without the owner entity, a weak entity cannot be uniquely identified or exist on its own. Therefore, the correct answer is "Weak."

    Rate this question:

  • 7. 

    A collection of entities that have the same attributes is called

    • A.

      ER Diagram

    • B.

      Entity Type

    • C.

      Entity Set

    • D.

      ER Schema

    Correct Answer
    B. Entity Type
    Explanation
    An entity type refers to a collection of entities that share the same attributes. In an entity-relationship (ER) diagram, an entity type represents a category or class of objects that have similar characteristics. It serves as a template or blueprint for creating individual entities within that category. An entity type helps in organizing and structuring data by grouping related entities together based on their common attributes.

    Rate this question:

  • 8. 

    An entity type usually has an attribute whose values are distinct for each individual entity in the entity set. Such an attribute is called a 

    • A.

      Global Attribute

    • B.

      Underlined Attribute

    • C.

      Key Attribute

    • D.

      Derived Attribute

    Correct Answer
    C. Key Attribute
    Explanation
    A key attribute is an attribute that has distinct values for each individual entity in the entity set. It is used to uniquely identify each entity in the set.

    Rate this question:

  • 9. 

    Each simple attribute of an entity type is associated with a _______________ , which specified the set of values that may be assigned to that attribute for each individual entity.

    Correct Answer
    domain
    value set
    Explanation
    Each simple attribute of an entity type is associated with a domain, which specifies the set of values that may be assigned to that attribute for each individual entity. The domain defines the range or type of values that are allowed for a particular attribute. The value set refers to the actual set of values that are valid for the attribute within the defined domain.

    Rate this question:

  • 10. 

    The degree of a relationship is the number of ________ in it.

    Correct Answer
    entities
    Explanation
    The degree of a relationship refers to the number of entities involved in it. In other words, it indicates the number of entities that participate in a particular relationship. The more entities involved, the higher the degree of the relationship.

    Rate this question:

  • 11. 

    The participation constraint is defined as the:

    • A.

      Min # of relationships possible

    • B.

      Mix # of relationships possible

    • C.

      Min # of relationships required

    • D.

      Mix # of relationships required

    Correct Answer
    C. Min # of relationships required
    Explanation
    The participation constraint refers to the minimum number of relationships that are required for an entity to participate in. It specifies the minimum number of occurrences of one entity that must be associated with occurrences of another entity in a relationship. Therefore, the correct answer is "min # of relationships required."

    Rate this question:

  • 12. 

    In addition to the all the modeling concepts of ER model, the EER includes the concepts of

    • A.

      Subclass \ superclass & specialization \ generalization

    • B.

      Specialization \ generalization & relationship

    • C.

      Subclass \ superclass & specialization

    • D.

      Superclass & specialization \ generalization

    Correct Answer
    A. Subclass \ superclass & specialization \ generalization
    Explanation
    The correct answer is subclass/superclass & specialization/generalization. The EER model extends the ER model by including the concepts of subclass/superclass and specialization/generalization. Subclass/superclass allows for the creation of specialized entities that inherit properties from a more general entity. Specialization/generalization allows for the creation of new entities by specializing or generalizing existing entities. These concepts enhance the modeling capabilities of the EER model and provide more flexibility in representing complex relationships and hierarchies in a database system.

    Rate this question:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 17, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • May 19, 2010
    Quiz Created by
    Inciit
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.