DBMS Mock Test (Full-Length Test with Answers)
DBMS Mock Test (Full-Length Test with Answers)
A DBMS mock test helps you evaluate your understanding of database concepts, SQL queries, and real-world scenarios. This full-length test is designed to simulate exam and interview conditions, allowing you to assess your preparation level.
In this lesson, you will attempt a mixed set of MCQs and SQL-based questions followed by answers for self-evaluation.
Section 1: MCQs (Concept-Based)
1. Which of the following is not a type of database model?
A. Relational
B. Hierarchical
C. Network
D. Linear
Correct Answer: D
2. What does ACID stand for?
A. Atomicity, Consistency, Isolation, Durability
B. Accuracy, Consistency, Integrity, Durability
C. Atomicity, Control, Isolation, Data
D. None
Correct Answer: A
3. Which key is used to uniquely identify a record?
A. Foreign Key
B. Primary Key
C. Candidate Key
D. Composite Key
Correct Answer: B
4. What is normalization?
A. Increasing redundancy
B. Organizing data to reduce redundancy
C. Deleting data
D. None
Correct Answer: B
5. Which SQL clause is used to filter records?
A. SELECT
B. ORDER BY
C. WHERE
D. GROUP BY
Correct Answer: C
Section 2: SQL-Based Questions
1. Write a query to find students with marks above average
SELECT * FROM Students
WHERE Marks > (SELECT AVG(Marks) FROM Students);
2. Write a query to count total orders
SELECT COUNT(*) FROM Orders;
3. Write a query to group students by course
SELECT Course_ID, COUNT(*)
FROM Students
GROUP BY Course_ID;
4. Write a query to find highest salary
SELECT MAX(Salary) FROM Employees;
5. Write a query to join two tables
SELECT Students.Name, Courses.Course_Name
FROM Students
INNER JOIN Courses
ON Students.Course_ID = Courses.Course_ID;
Section 3: Scenario-Based Questions
Problem 1
Find users who placed more than 5 orders
SELECT User_ID, COUNT()
FROM Orders
GROUP BY User_ID
HAVING COUNT() > 5;
Problem 2
Find products with price greater than average
SELECT * FROM Products
WHERE Price > (SELECT AVG(Price) FROM Products);
How to Use This Mock Test
- Attempt all questions without looking at answers
- Check answers after completion
- Identify weak areas
- Revise concepts accordingly
Why Mock Tests are Important
Mock tests help you:
- Evaluate your preparation level
- Improve speed and accuracy
- Identify weak topics
- Build confidence for exams and interviews
FAQs
What is a DBMS mock test?
It is a practice test designed to evaluate your DBMS knowledge.
How many mock tests should I take?
Take at least 2–3 mock tests before exams or interviews.
Are mock tests useful for interviews?
Yes, they help in quick revision and confidence building.
What should I do after a mock test?
Analyze mistakes and revise weak topics.
Where can I learn more courses like this?
Click here for more free courses