Home - Database - Data Modeling With Er Model

Data Modeling With Er Model Online Exam Quiz

Important questions about Data Modeling With Er Model. Data Modeling With Er Model MCQ questions with answers. Data Modeling With Er Model exam questions and answers for students and interviews.

1. Which type of entity cannot exist in the database unless another type of entity also exists in the database, but does not require that the identifier of that other entity be included as part of its own identifier?

Options

A : Weak entity

B : Strong entity

C : ID-dependent entity

D : ID- independent entity

2. An attribute that names or identifies entity instances is a(n):

Options

A : entity.

B : attribute.

C : identifier.

D : relationship.

3. Which of the following indicates the maximum number of entities that can be involved in a relationship?

Options

A : Minimum cardinality

B : Maximum cardinality

C : ERD

D : Greater Entity Count (GEC)

4. Which type of entity has its relationship to another entity determined by an attribute in that other entity called a discriminator?

Options

A : Supertype entity

B : Subtype entity

C : Archetype entity

D : Instance entity

5. Entities can be associated with one another in which of the following?

Options

A : Entities

B : Attributes

C : Identifiers

D : Relationships

6. Which of the following indicates the minimum number of entities that must be involved in a relationship?

Options

A : Minimum cardinality

B : Maximum cardinality

C : ERD

D : Greater Entity Count (GEC)

7. Which of the following refers to something that can be identified in the users' work environment, something that the users want to track?

Options

A : Entity

B : Attribute

C : Identifier

D : Relationship

8. In a one-to-many relationship, the entity that is on the many side of the relationship is called a(n) ________ entity.

Options

A : parent

B : child

C : instance

D : subtype

9. In which of the following is a single-entity instance of one type of related to a single-entity instance of another type?

Options

A : One-to-One Relationship

B : One-to-Many Relationship

C : Many-to-Many Relationship

D : Composite Relationship

10. Which of the following refers to an entity in which the identifier of one entity includes the identifier of another entity?

Options

A : Weak entity

B : Strong entity

C : ID-dependent entity

D : ID-independent entity

1. An ID-dependent entity is an entity whose identifier is a composite identifier where no portion of the composite identifier is an identifier of another entity.

Options

A : True

B : False

C :

D :

2. When designing a database, first identify the entities, then determine the attributes, and finally establish the relationships.

Options

A : True

B : False

C :

D :

3. A ternary relationship is so called because in contains two entities and one association between them.

Options

A : True

B : False

C :

D :

4. In a 1:N relationship, the parent is the entity on the one side of the relationship and the child is the entity on the N side of the relationship.

Options

A : True

B : False

C :

D :

5. An entity is something that can be identified in the user's work environment; something that the users want to track.

Options

A : True

B : False

C :

D :

6. An identifier typically uses more than one attribute.

Options

A : True

B : False

C :

D :

7. Relationship classes are associations between entity classes.

Options

A : True

B : False

C :

D :

8. Entity instances are associated by relationship classes.

Options

A : True

B : False

C :

D :

9. Composite identifiers consist of two or more attributes.

Options

A : True

B : False

C :

D :

10. All instances of an entity class have the same attributes.

Options

A : True

B : False

C :

D :

Database more Online Exam Quiz

Copyright © 2021
Exam-GK-MCQ-Questions.Com | Contact Us | Privacy Policy | Terms of Use | Sitemap | 0.019608020782471