DBMS MCQ Questions With Answers Set 5

A database is an essential component of any software, serving as the back-end system where data is stored, managed, and retrieved. A Database Management System (DBMS) acts as an intermediary between the database and the user, often receiving commands from a Database Administrator (DBA). These commands can instruct the system to load, retrieve, or modify existing data, ensuring smooth and efficient operations. One key feature of a DBMS is data independence, which allows changes in storage mechanisms or formats without requiring modifications to the entire software system.

The DBMS MCQs questions with answers set 5 provide a comprehensive review of core database concepts. This set covers topics like the introduction to the E-R (Entity-Relationship) model, its components, and types of entities. Understanding the various types of entity relationships, such as one-to-one, one-to-many, and many-to-many relationships, is crucial for database design. The set also explores different types of attributes, including single-valued, multi-valued, and composite attributes, along with types of identifiers, such as composite identifiers.

Additionally, the set delves into more advanced topics, such as the degree of relationships, recursive relationships, ternary relationships, and cardinality. By covering these topics, the MCQs offer a thorough understanding of DBMS fundamentals, preparing users for exams and practical applications in database management. Whether you're new to databases or looking to deepen your knowledge, these questions provide valuable insights into how a DBMS handles data storage, retrieval, and relationships within a system. Let's start the quiz..

DBMS MCQs 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

2. Relationships among entities of a single class are called _______?
A). IS-A relationships
B). Recursive relationships
C). HAS-A relationships
D). None of the above

3. In an E-R diagram a relationship is represented by ________?
A). Ellipse
B). Rectangle
C). Rectangle with rounded corners
D). Diamond

4. An attribute which consists of a group of attributes is called ______?
A). Composite attributes
B). Multi-valued attributes
C). Composite identifiers
D). Identifiers

5. Identifiers that consists of two or more attributes are called _______?
A). Composite identifiers
B). Multi-valued attributes
C). Composite attributes
D). Identifiers

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 of the above

7. In an E-R diagram an ellipse represents ________?
A). Weak entity
B). Relationship
C). Attribute
D). Entity class

8. A meaningful association between entity types is _______?
A). Relationship type
B). Entity identifier
C). Relationship instance
D). Associative entity

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

10. If employee is the entity type, then Michael, Smith is the entity _______?
A). Characteristics
B). Field
C). Identifier
D). Instance

11. Which is not included in the definition of an entity?
A). Person
B). Object
C). Concept
D). Action

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

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

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

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

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

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

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

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

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

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

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

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

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

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

26. A collection of related data items, organized for convenient access, is known as _____?
A). Database
B). Schema
C). Table
D). Record

27. A relationship where an entity is related to itself is called _____?
A). Recursive relationship
B). Reflexive relationship
C). Self-relationship
D). Hierarchical relationship

28. In an ER diagram, the primary key is usually represented by _____?
A). A bold underline
B). A dashed line
C). A rectangle
D). An ellipse