Entity Relationship Model

Open its course - Database Systems

Entity Relationship Model

Topic Questions: 92
MCQs	T/F	FiB	SQ
36 25 11	21 4 17	28 3 25	7 1 6

Question Type Legends
	Easy		Medium		Difficult

MCQs T/F FiB Short Qs

Open its course - Database Systems

Multiple Choice Questions for Entity Relationship Model

×
Hidden Questions!

Some MCQs are not visible. Usually teachers hides their visibility if they are few in number. We recommends them to have more than 70+ questions against the topic and make them public.
1 Order of attributes has ________ in a table.
1. no significance
2. significance
3. may be significance
4. none of them
- View Answer
2 _________ uniquely identifies each tuple in a relation.
1. Relational Schema
2. DBMS
3. Relational keys
4. All of the above
- View Answer
3 An attribute that holds a single value for each occurrence of an entity type is called
1. Single-valued attribute
2. Multi-valued attribute
3. both them
4. non of them
- View Answer
4 An attribute that holds multiple values for each occurrence of an entity type is called
1. Single-valued attribute
2. Multi-valued attribute
3. both them
4. non of them
- View Answer
5 An attribute composed of multiple components, each with an independent existence is called?:
1. Simple attribute
2. Composite attribute
3. Derived attribute
4. non of them
- View Answer
6 An attribute composed of a single component with an independent existence is called:
1. Derived attribute
2. Composite attribute
3. Simple attribute
4. non of them
- View Answer
7 In entity diagrams, Considering binary relationships, possible cardinality ratios are:
1. one : one
2. 1:N
3. M:N
4. All of above
- View Answer
8 Type of diagram in which operations are specified on objects is considered as:
1. functional diagrams
2. class diagrams
3. attribute diagrams
4. entity diagrams
- View Answer
9 The attribute AGE is calculated from DATE_OF_BIRTH . The attribute AGE is:
1. single valued
2. multi valued
3. composite
4. derived
- View Answer
10 An _____ is a set of entities of the same type that share the same properties, or attributes.
1. entity set
2. attribute set
3. relation set
4. entity model
- View Answer
11 ______have state and behavior
1. entities
2. objects
3. methods
- View Answer
12 Set of meaningful associations among the entity types is:
1. degree of the relationship
2. relationship type
3. degree
4. entity
- View Answer
13 If a member of Staff can manage maximum one Branch, but each branch can have exactly one member of staff, what will be the participation constraint of the Branch entity type?
1. Mandatory
2. Optional
3. None of above
4. Both a & b
- View Answer
14 “A department may offer number of projects, but a project must belong to at least one department” what is the cardinality ratio from department to project?
1. One-to-one
2. One-to-many
3. Many-to-one
4. Many-to-many
- View Answer
15 Synonym and Homonym are problems that can arise while
1. Enterprise key
2. Normalizing
3. Integrating relations
4. all of the above
- View Answer
16 The number of participating entity types in a relationship is called:
1. Degree
2. Degree of Relationship Type
3. Cardinality
4. Cardinality of Relationship Type
- View Answer
17 An entity type that is not existence-dependent on some other entity type is:
1. strong
2. weak
3. both
4. none
- View Answer
18 Which of the following integrity constraint apply to all instances of the database.
1. Domain
2. Multiplicity
3. General
4. Entity
- View Answer
19 One goal to eliminate various anomalies in relational database is to:
1. reduce attributes
2. increase data
3. reduce table
4. reduce storage space
- View Answer
20 Value of the primary key can be:
1. Null
2. Repeating
3. Zero
4. None
- View Answer
21 A recursive relationship is a relationship between an entity and with which of the following?
1. itself
2. sub-type entity
3. super-type entity
4. weak entity
- View Answer
22 Generally the type of relationship between entities TEACHER and STUDENT is:
1. One-to-Many
2. Many-to-One
3. Many-to-Many
4. None
- View Answer
23 An entity type that is not existence dependent on some other entity type is:
1. Weak Entity
2. Strong Entity
3. Associative entity
4. Relationship type
- View Answer
24 Which of the following is a top down database design technique?
1. Entity Relationship Modeling
2. Functional Dependencies
3. Specialization
4. None
- View Answer
25 Which of the following is not a perspective to determine the quality of the ER diagram can be found?
1. Conceptual Correctness
2. Logical Correctness
3. Conceptual completeness
4. Enterprise awareness
- View Answer

Programs

Entity Relationship Model

Multiple Choice Questions for Entity Relationship Model

Hidden Questions!

Subject Expert

Learning Experience Platform