34 + Mcqs in Data Modeling With Er Model in Database Page 1 McqOptions

1.	A recursive relationship is a relationship between an archetype and an instance of that archetype.%!
A.	True
B.	False
Answer» C.

Discussion

2.	A maximum cardinality is the maximum number of entity instances that can participate in a relationship instance.%!
A.	True
B.	False
Answer» B. False

Discussion

3.	A subtype entity is a special case of another entity called a supertype entity.%!
A.	True
B.	False
Answer» B. False

Discussion

4.	An attribute describes the entity's characteristics.%!
A.	True
B.	False
Answer» B. False

Discussion

5.	An identifier determines the type of relationship that an entity has.%!
A.	True
B.	False
Answer» C.

Discussion

6.	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.%!
A.	True
B.	False
Answer» B. False

Discussion

7.	When designing a database, first identify the entities, then determine the attributes, and finally establish the relationships.%!
A.	True
B.	False
Answer» C.

Discussion

8.	A minimum cardinality is the minimum number of entity instances that may participate in a relationship instance.%!
A.	True
B.	False
Answer» C.

Discussion

9.	An identifier typically uses more than one attribute.%!
A.	True
B.	False
Answer» C.

Discussion

10.	1:1, 1:N and N:M relationships are also known as HAS-A relationships.%!
A.	True
B.	False
Answer» B. False

Discussion

11.	Composite identifiers consist of two or more attributes.%!
A.	True
B.	False
Answer» B. False

Discussion

12.	All instances of an entity class have the same attributes.%!
A.	True
B.	False
Answer» B. False

Discussion

13.	Relationship classes are associations between entity classes.%!
A.	True
B.	False
Answer» B. False

Discussion

14.	Entity instances are associated by relationship classes.%!
A.	True
B.	False
Answer» C.

Discussion

15.	Entities use identifiers while tables use keys.%!
A.	True
B.	False
Answer» B. False

Discussion

16.	A ternary relationship is so called because in contains two entities and one association between them.%!
A.	True
B.	False
Answer» C.

Discussion

17.	An entity class is a collection of entities and is described by the structure of the entities in that class.%!
A.	True
B.	False
Answer» B. False

Discussion

18.	An entity is something that can be identified in the user's work environment; something that the users want to track.%!
A.	True
B.	False
Answer» B. False

Discussion

19.	The degree of a relationship refers to the number of entity classes in the relationship.%!
A.	True
B.	False
Answer» B. False

Discussion

20.	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.%!
A.	True
B.	False
Answer» C.

Discussion

21.	*$_A recursive relationship is a relationship between an entity and ________ .?
A.	itself
B.	a subtype entity
C.	an archetype entity
D.	an instance entity
Answer» B. a subtype entity

Discussion

22.	/_In a one-to-many relationship, the entity that is on the many side of the relationship is called a(n) ________ entity.?
A.	parent
B.	child
C.	instance
D.	subtype
Answer» C. instance

Discussion

23.	/_Which of the following is NOT a basic element of all versions of the E-R model??
A.	Entities
B.	Attributes
C.	Relationships
D.	Primary keys
Answer» E.

Discussion

24.	/_Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity??
A.	Supertype entity
B.	Subtype entity
C.	Archetype entity
D.	Instance entity
Answer» B. Subtype entity

Discussion

25.	%_Which type of entity represents an actual occurrence of an associated generalized entity?_%
A.	Supertype entity
B.	Subtype entity
C.	Archetype entity
D.	Instance entity
Answer» E.

Discussion

26.	_ Which type of entity represents a logical generalization whose actual occurrence is represented by a second, associated entity?$?
A.	Supertype entity
B.	Subtype entity
C.	Archetype entity
D.	Instance entity
Answer» D. Instance entity

Discussion

27.	_ Entities of a given type are grouped into a(n):$?
A.	database.
B.	entity class.
C.	attribute.
D.	ERD.
Answer» C. attribute.

Discussion

28.	_ Which of the following refers to an entity in which the identifier of one entity includes the identifier of another entity?$?
A.	Weak entity
B.	Strong entity
C.	ID-dependent entity
D.	ID-independent entity
Answer» D. ID-independent entity

Discussion

29.	__In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) ________ entity.__
A.	parent
B.	child
C.	instance
D.	subtype
Answer» B. child

Discussion

30.	Which type of entity has its relationship to another entity determined by an attribute in that other entity called a discriminator?$?
A.	Supertype entity
B.	Subtype entity
C.	Archetype entity
D.	Instance entity
Answer» C. Archetype entity

Discussion

31.	In which of the following can many entity instances of one type be related to many entity instances of another type?$?
A.	One-to-One Relationship
B.	One-to-Many Relationship
C.	Many-to-Many Relationship
D.	Composite Relationship
Answer» D. Composite Relationship

Discussion

32.	In which of the following is a single-entity instance of one type related to many entity instances of another type?$?
A.	One-to-One Relationship
B.	One-to-Many Relationship
C.	Many-to-Many Relationship
D.	Composite Relationship
Answer» C. Many-to-Many Relationship

Discussion

33.	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?$?
A.	Weak entity
B.	Strong entity
C.	ID-dependent entity
D.	ID- independent entity
Answer» B. Strong entity

Discussion

34.	Which of the following refers to something that can be identified in the user's work environment, something that the users want to track?
A.	Entity
B.	Attribute
C.	Identifier
D.	Relationship
Answer» B. Attribute

Discussion

Explore topic-wise MCQs in Database.

A recursive relationship is a relationship between an archetype and an instance of that archetype.%!

A maximum cardinality is the maximum number of entity instances that can participate in a relationship instance.%!

A subtype entity is a special case of another entity called a supertype entity.%!

An attribute describes the entity's characteristics.%!

An identifier determines the type of relationship that an entity has.%!

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.%!

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

A minimum cardinality is the minimum number of entity instances that may participate in a relationship instance.%!

An identifier typically uses more than one attribute.%!

1:1, 1:N and N:M relationships are also known as HAS-A relationships.%!

Composite identifiers consist of two or more attributes.%!

All instances of an entity class have the same attributes.%!

Relationship classes are associations between entity classes.%!

Entity instances are associated by relationship classes.%!

Entities use identifiers while tables use keys.%!

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

An entity class is a collection of entities and is described by the structure of the entities in that class.%!

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

The degree of a relationship refers to the number of entity classes in the relationship.%!

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.%!

*$_A recursive relationship is a relationship between an entity and ________ .?

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

/_Which of the following is NOT a basic element of all versions of the E-R model??

/_Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity??

%_Which type of entity represents an actual occurrence of an associated generalized entity?_%

_ Which type of entity represents a logical generalization whose actual occurrence is represented by a second, associated entity?$?

_ Entities of a given type are grouped into a(n):$?

_ Which of the following refers to an entity in which the identifier of one entity includes the identifier of another entity?$?

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

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

In which of the following can many entity instances of one type be related to many entity instances of another type?$?

In which of the following is a single-entity instance of one type related to many entity instances of another type?$?

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?$?

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

Explore topic-wise MCQs in Database.

A recursive relationship is a relationship between an archetype and an instance of that archetype.%!

A maximum cardinality is the maximum number of entity instances that can participate in a relationship instance.%!

A subtype entity is a special case of another entity called a supertype entity.%!

An attribute describes the entity's characteristics.%!

An identifier determines the type of relationship that an entity has.%!

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.%!

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

A minimum cardinality is the minimum number of entity instances that may participate in a relationship instance.%!

An identifier typically uses more than one attribute.%!

1:1, 1:N and N:M relationships are also known as HAS-A relationships.%!

Composite identifiers consist of two or more attributes.%!

All instances of an entity class have the same attributes.%!

Relationship classes are associations between entity classes.%!

Entity instances are associated by relationship classes.%!

Entities use identifiers while tables use keys.%!

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

An entity class is a collection of entities and is described by the structure of the entities in that class.%!

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

The degree of a relationship refers to the number of entity classes in the relationship.%!

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.%!

*$_A recursive relationship is a relationship between an entity and ________ .?

*/*_In a one-to-many relationship, the entity that is on the many side of the relationship is called a(n) ________ entity.?

*/*_Which of the following is NOT a basic element of all versions of the E-R model??

*/*_Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity??

%_Which type of entity represents an actual occurrence of an associated generalized entity?_%

_ Which type of entity represents a logical generalization whose actual occurrence is represented by a second, associated entity?$?

_ Entities of a given type are grouped into a(n):$?

_ Which of the following refers to an entity in which the identifier of one entity includes the identifier of another entity?$?

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

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

In which of the following can many entity instances of one type be related to many entity instances of another type?$?

In which of the following is a single-entity instance of one type related to many entity instances of another type?$?

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?$?

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

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

/_Which of the following is NOT a basic element of all versions of the E-R model??

/_Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity??

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