DBMS MCQ Questions With Answers Set 5

database multiple choice questions with answers set 5

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
Correct: B


2. In an E-R diagram a ellipse represents________?
A). Weak entity
B). Relationship
C). Attribute
D). Entity class
View Answer
Correct: C


3. In an E-R diagram a relationship is represented by________?
A). Ellipse
B). Rectangle
C). Rectangle with rounded corners
D). Diamond
View Answer
Correct: D


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
Correct: B


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
Correct: A


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
Correct: A


7. Relationships among entities of a single class are called_______?
A). IS-A relationships
B). Recursive relationships
C). HAS-A relationships
D). None
View Answer
Correct: B


8. Which is not included in the definition of an entity?
A). Person
B). Object
C). Concept
D). Action
View Answer
Correct: D


9. Which is not an example of a strong entity type?
A). Course
B). Department
C). Student_Id
D). Student
View Answer
Correct: C


10. If employee is the entity type then Michael, smith is the entity_______?
A). Characteristics
B). Field
C). Identifier
D). Instance
View Answer
Correct: D


11. A meaningful association between entity types is _______?
A). Relationship type
B). Entity identifier
C). Relationship instance
D). Associative entity
View Answer
Correct: A


12. An entity type whose existence depends on another entity type is called _________ entity?
A). Strong
B). Weak
C). Dependent
D). Variant
View Answer
Correct: B


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
Correct: A


14. A person name, birthday and social security number are all examples of _______?
A). Entities
B). Attributes
C). Relationships
D). Descriptors
View Answer
Correct: B


15. The most common type of relationship encountered in data modelling is __________ relationship?
A). Unary
B). Binary
C). Ternary
D). Associative
View Answer
Correct: B


16. Which is not a basic construct of an E-R model?
A). Relationships
B). Entity types
C). Identifiers
D). Attributes
View Answer
Correct: C


17. An example of a multi-valued attribute might be ______?
A). Student_Address
B). College_Degree
C). Student_GPA
D). ID_Number
View Answer
Correct: B


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
Correct: A


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
Correct: D


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
Correct: D


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
Correct: B


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
Correct: C


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
Correct: A


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
Correct: C


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
Correct: B




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

Next Post Previous Post
1 Comments
  • Unknown
    Unknown 21 September 2020 at 04:27

    great sir!

Add Comment
comment url