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
11. Which of the following is a DBMS software?
- MySQL
- Microsoft Word
- Adobe Photoshop
- Google Chrome
12. What does ACID stand for in database transactions?
- Atomicity, Consistency, Isolation, Durability
- Accuracy, Completeness, Integrity, Durability
- Automation, Control, Integration, Design
- Analysis, Calculation, Interpretation, Data
13. What is the role of DDL in database systems?
- Define database structure
- Manipulate data
- Control user access
- Backup database
14. Which constraint ensures column cannot have NULL values?
- NOT NULL
- UNIQUE
- PRIMARY KEY
- CHECK
15. What is an ER diagram used for?
- Visual database design
- Data encryption
- Query optimization
- User authentication
16. Which normal form deals with multivalued dependencies?
- Fourth Normal Form
- Third Normal Form
- Second Normal Form
- First Normal Form
17. What is data integrity?
- Data accuracy and consistency
- Data storage size
- Data transmission speed
- Data encryption level
19. What is database normalization?
- Reduce redundancy
- Increase storage
- Speed up queries
- Enhance security
20. Which key can have NULL values?
- Foreign key
- Primary key
- Candidate key
- Super key