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
31. What is the purpose of GROUP BY clause?
- Group rows with same values
- Sort data alphabetically
- Filter records
- Join tables
33. What is a candidate key?
- Potential primary key
- Foreign key reference
- Temporary key
- Encryption key
34. Which SQL command removes a table?
- DROP TABLE
- DELETE TABLE
- REMOVE TABLE
- ERASE TABLE
35. What is data warehousing?
- Business intelligence data collection
- Real-time transaction processing
- Data encryption
- User authentication
36. Which join returns all records from both tables?
- FULL OUTER JOIN
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
37. What is database cursor?
- Row-by-row result processing
- Database backup tool
- User authentication method
- Data encryption technique
38. Which constraint ensures unique values?
- UNIQUE
- PRIMARY KEY
- FOREIGN KEY
- NOT NULL
39. What is deadlock in databases?
- Mutual blocking of transactions
- Fast data retrieval
- Data encryption process
- Backup procedure