DBMS Practice Questions (MCQs + SQL Queries for Revision)
DBMS Practice Questions (MCQs + SQL Queries for Revision)
Practice is essential to master DBMS concepts and perform well in exams and interviews. In this lesson, you will solve important DBMS multiple-choice questions (MCQs) and SQL-based problems to strengthen your understanding.
These questions are designed for revision and help you test your knowledge of database concepts, SQL queries, and real-world scenarios.
DBMS MCQs (Concept-Based)
1. What is the main purpose of DBMS?
A. Store data randomly
B. Manage and organize data efficiently
C. Delete data permanently
D. None
Correct Answer: B
2. Which of the following is a type of DBMS?
A. Hierarchical
B. Relational
C. Network
D. All of the above
Correct Answer: D
3. What is a primary key?
A. Duplicate value
B. Unique identifier
C. Optional field
D. None
Correct Answer: B
4. Which normal form removes transitive dependency?
A. 1NF
B. 2NF
C. 3NF
D. BCNF
Correct Answer: C
5. What does SQL stand for?
A. Structured Query Language
B. Simple Query Language
C. Sequential Query Language
D. None
Correct Answer: A
SQL Practice Questions
1. Write a query to find all students with marks greater than 80
SELECT * FROM Students WHERE Marks > 80;
2. Find total number of students
SELECT COUNT(*) FROM Students;
3. Get average marks of students
SELECT AVG(Marks) FROM Students;
4. Find duplicate names
SELECT Name, COUNT()
FROM Students
GROUP BY Name
HAVING COUNT() > 1;
5. Get second highest salary
SELECT MAX(Salary)
FROM Employees
WHERE Salary < (SELECT MAX(Salary) FROM Employees);
Scenario-Based Practice
Problem 1
Find all students enrolled in a specific course
SELECT Students.Name
FROM Students
INNER JOIN Enrollment ON Students.Student_ID = Enrollment.Student_ID
WHERE Enrollment.Course_ID = 101;
Problem 2
Find total orders per user
SELECT User_ID, COUNT(*)
FROM Orders
GROUP BY User_ID;
Why Practice Questions are Important
They help you:
- Test your DBMS knowledge
- Improve SQL query skills
- Prepare for exams and interviews
- Build confidence in concepts
FAQs
What are DBMS practice questions?
They include MCQs and SQL queries used for revision and interview preparation.
How to practice DBMS effectively?
Solve MCQs, write SQL queries, and work on real-world projects.
Are SQL queries important for exams?
Yes, SQL queries are important for both exams and interviews.
How many questions should I practice daily?
Practice at least 10–15 questions daily for better understanding.
Where can I learn more courses like this?
Click here for more free courses