DBMS-Introduction to Database Design Questions and Answers
DBMS – Introduction to Database Design is a foundational topic in computer science and is often featured in programming interview questions with answers and campus placement papers. Understanding how to design efficient databases is essential for roles involving software development and data management. Concepts like ER models, normalization, schema design, and relationships form the core of this section. Practicing DBMS questions with answers will help you excel in company-wise technical rounds of Infosys, Cognizant, and Wipro. Strengthen your fundamentals with these Database Design interview questions and answers to prepare effectively for technical interviews.
DBMS-Introduction to Database Design
Showing 10 of
50 questions
21. What is a composite key?
- Multiple column key
- Single column key
- Encrypted key
- Temporary key
23. What is the purpose of an index?
- Faster data retrieval
- Data encryption
- Data compression
- Data backup
24. Which database model uses parent-child relationships?
- Hierarchical model
- Relational model
- Network model
- Object model
25. What is data dictionary?
- Database metadata
- User data
- Backup data
- Temporary data
26. Which constraint maintains referential integrity?
- Foreign key
- Primary key
- Unique key
- Check constraint
27. What is a weak entity?
- Depends on another entity
- Strong independent entity
- Temporary entity
- Virtual entity
29. What is database schema?
- Logical database structure
- Physical storage
- User interface
- Network configuration
30. Which normal form requires elimination of partial dependencies?
- Second Normal Form
- First Normal Form
- Third Normal Form
- Fourth Normal Form