In recent years, Data Modeling in DBMS (Database Management System) has emerged as a crucial topic for candidates preparing for competitive and officer-level examinations, including banking, SSC, and technical recruitment tests. Experts suggest that a strong understanding of data modeling concepts can significantly improve problem-solving accuracy and overall scores.
Data modeling refers to the process of structuring and organizing data using models such as the Entity-Relationship (ER) Model, Relational Model, and Hierarchical Model. Among these, the Relational Model remains the most widely tested concept, focusing on tables, keys, constraints, and relationships between data.
Examination trends indicate that questions are increasingly designed to test not only theoretical knowledge but also practical understanding. Topics like primary key, foreign key, normalization, entity relationships, and constraints are frequently asked in moderate to high-difficulty levels. Candidates are often required to analyze scenarios, identify relationships, and apply normalization rules.
Total Questions : 20
Timer : sec
Question : Why is “Address” usually not preferred as a primary key?
Question : Which key is NOT necessarily minimal?
Question : Which of the following best describes a super key?
Question : If a table has multiple candidate keys, then:
Question : A composite key is:
Question : Which key is used to maintain referential integrity between tables?
Question : If a relation has 5 attributes, the maximum number of possible super keys is:
Question : Which of the following can contain NULL values?
Question : Which statement is FALSE regarding keys?
Question : A super key from which no attribute can be removed without losing uniqueness is called:
Question : In a relationship, if both participating entity sets can have multiple associations with each other, which constraint applies?
Question : The structure of the primary key of a relationship set in ER modeling depends primarily on:
Question : Which of the following statements is TRUE regarding mapping cardinalities?
Question : Consider two entity sets A and B with a relationship R. If each entity in A can be associated with multiple entities in B, but each entity in B is associated with at most one entity in A, the mapping is:
Question : Which of the following best defines a mapping constraint in DBMS?
Question : Which of the following is NOT a type of attribute in an ER model?
Question : Which statement best defines cardinality in an ER model?
Question : What is the degree of a relationship if three entities participate in it?
Question : In an ER diagram, a derived attribute is represented by:
Question : Which of the following correctly describes a weak entity in an ER model?