Question : In generalization, the resulting higher-level entity is called:
Solution :
Correct Answer : Superclass
Description -
Question : What is the primary advantage of generalization in database design?
Solution :
Correct Answer : Reduces data duplication and improves structure
Description -
Question : Which of the following is a correct example of generalization?
Solution :
Correct Answer : Student, Faculty → Person
Description -
Question : Generalization in DBMS follows which type of approach?
Solution :
Correct Answer : Bottom-up
Description -
Question : Which of the following best describes generalization in DBMS?
Solution :
Correct Answer : Combining lower-level entities into a higher-level entity based on common attributes
Description -
Question : Which scenario best represents DBMS specialization?
Solution :
Correct Answer : Dividing PRODUCT into ELECTRONICS, BOOKS, and CLOTHES
Description -
Question : Which step in specialization ensures data integrity by linking general and specialized entities?
Solution :
Correct Answer : Establishing relationships
Description -
Question : Which of the following is NOT a characteristic of specialization?
Solution :
Correct Answer : Bottom-up technique
Description -
Question : In specialization, subclasses inherit attributes from:
Solution :
Correct Answer : Superclass
Description -
Question : Which of the following correctly describes specialization in DBMS?
Solution :
Correct Answer : Breaking a higher-level entity into lower-level entities
Description -
Question : Aggregation in DBMS is most useful when:
Solution :
Correct Answer : Data needs to be summarized or analyzed
Description -
Question : Which of the following aggregate functions works with both numeric and non-numeric data?
Solution :
Correct Answer : COUNT()
Description -
Question : Which SQL clause is specifically used to filter aggregated results?
Solution :
Correct Answer : HAVING
Description -
Question : Which of the following best describes aggregation in an ER model?
Solution :
Correct Answer : Representing a relationship as an entity for another relationship
Description -
Question : In DBMS, aggregation is primarily used to:
Solution :
Correct Answer : Treat a relationship as a higher-level entity
Description -
Question : Why are higher-degree relationships sometimes not preferred in implementation?
Solution :
Correct Answer : They are complex to convert into relational tables
Description -
Question : In an n-ary relationship, the degree of the relationship is:
Solution :
Correct Answer : Number of participating entity types
Description -
Question : Which statement is TRUE about higher-degree relationships?
Solution :
Correct Answer : They simplify modeling when multiple entities are interdependent
Description -
Question : A relationship involving entities Teacher, Course, and Class is an example of:
Solution :
Correct Answer : Ternary relationship
Description -
Question : Which of the following correctly defines a higher-degree (n-ary) relationship in DBMS?
Solution :
Correct Answer : Relationship involving three or more entities
Description -