Database multiple choice questions with answers, database management system multiple choice questions with answers set 5. A database is the back end of an software. A DBMS receives instruction from a database administrator (DBA) and therefore instructs the system to make the essential modifications. these commands can be to load, retrieve or alter existing data from the system. A DBMS always provides records independence. Any change in storage mechanism and formats are carried out without modifying the entire software.
DBMS mcqs questions with answers set 5 contains the mcqs which covers the topics such as introduction to E-R model, entity relationship model, components of E-R model, types of entities, associative entities, types of entity relationships, types of attributes, single-values attributes, multi-valued attributes, composite attributes, types of identifiers, composite identifiers, degree of relationships, recursive relationship, ternary relationship, cardinality relationship, one-to-one relationship, one-to-many relationship, many-to-many relationship and so on..
DBMS MCQ Questions With Answers Set 5
1. In an E-R diagram rectangle with rounded corners represents _______?A). Entity class
B). Weak entity
C). Relationship
D). Attribute
View Answer
A). IS-A relationships
B). Recursive relationships
C). HAS-A relationships
D). None
View Answer
3. In an E-R diagram a relationship is represented by________?
A). Ellipse
B). Rectangle
C). Rectangle with rounded corners
D). Diamond
View Answer
4. An attribute which consists of a group of attributes is called ______?
A). Composite attributes
B). Multi-valued attributes
C). Composite identifiers
D). Identifiers
View Answer
5. Identifiers that consists of two or more attributes are called_______?
A). Composite identifiers
B). Multi-valued attributes
C). Composite attributes
D). Identifiers
View Answer
6. Which refers to connecting entities of different types when identifiers are different?
A). HAS-A relationships
B). IS-A relationships
C). Binary relationship
D). None
View Answer
7. In an E-R diagram a ellipse represents________?
A). Weak entity
B). Relationship
C). Attribute
D). Entity class
View Answer
8. A meaningful association between entity types is _______?
A). Relationship type
B). Entity identifier
C). Relationship instance
D). Associative entity
View Answer
9. Which is not an example of a strong entity type?
A). Course
B). Department
C). Student_Id
D). Student
View Answer
10. If employee is the entity type then Michael, smith is the entity_______?
A). Characteristics
B). Field
C). Identifier
D). Instance
View Answer
A). Person
B). Object
C). Concept
D). Action
View Answer
12. An entity type whose existence depends on another entity type is called _________ entity?
A). Strong
B). Weak
C). Dependent
D). Variant
View Answer
13. An entity that Associates the instances of one or more entity types and contains attributes specific to the relationships is called ________?
A). Associative entity
B). Connecting entity
C). Intersectional entity
D). All
View Answer
14. A person name, birthday and social security number are all examples of _______?
A). Entities
B). Attributes
C). Relationships
D). Descriptors
View Answer
15. The most common type of relationship encountered in data modelling is __________ relationship?
A). Unary
B). Binary
C). Ternary
D). Associative
View Answer
16. Which is not a basic construct of an E-R model?
A). Relationships
B). Entity types
C). Identifiers
D). Attributes
View Answer
A). Student_Address
B). College_Degree
C). Student_GPA
D). ID_Number
View Answer
18. _________ specifies the number of instances of one entity that can or must be associated with each instance of another?
A). Cardinality constraint
B). Entity instance
C). Associative entity
D). Multi-valued attribute
View Answer
19. An entity class?
A). Contains structure or format of entity
B). Contains one instance of a particular entity
C). Represents something that the users want to track
D). b and c
View Answer
20. All instances of a given entity?
A). Have the same values for the attributes
B). Belong to the same entity class
C). Have the same attributes
D). b and c
View Answer
21. ______ express the number of entities to which another entity can be associated via a relationship set.
A). Relational Cardinality
B). Mapping Cardinality
C). Participation Constraints
D). None of these
View Answer
22. An entity in A is associated with at most one entity in B, and an entity in B is associated with at most one entity in A. This is called as _____?
A). Many-to-many
B). One-to-many
C). One-to-one
D). Many-to-one
View Answer
23. An entity in A is associated with at most one entity in B. An entity in B, however can be associated with any number (zero or more) of entities in A. This is called as _____?
A). Many-to-one
B). Many-to-many
C). One-to-one
D). One-to-many
View Answer
24. Every weak entity set can be converted into a strong entity set by _____?
A). Using generalization
B). Using aggregation
C). Adding appropriate attributes
D). None of the above
View Answer
25. In E-R model the details of the entities are hidden from the user. This process is called _____?
A). Generalization
B). Abstraction
C). Specialization
D). None of these
View Answer
Read also>->>Database MCQs With Answers Set 4
Read also>->>Database MCQs With Answers Set 6
Read also>->>Database MCQs With Answers Set 7
Read also>->>Database MCQs With Answers Set 8
