MCQ Guru LogoMCQ Guru

DBMS MCQs

Database Management Systems MCQs covering ER modeling, relational algebra, normal forms, and transaction ACID properties.

24 MCQs1 subtopicsComputer ScienceAll Levels
Key Concept Overview & Exam Context

Review core principles of DBMS before answering questions. These questions simulate placement technical assessments (TCS, Infosys, Amazon), university exams (CS/IT), and technical certifications.

Target Readiness
Placements & Job Interviews
Question Format
Multiple-Choice with Explanations
Verified Solutions
Step-by-step Output Traces

Browse by Subtopic

All TopicsNormalization

DBMS MCQ Questions

Page 2 of 2 (24 total)
Q1

Which ACID property guarantees that all operations within a transaction either succeed completely or are rolled back?

easy
Correct Answer: Atomicity
Explanation:
Atomicity (the "A" in ACID) ensures the all-or-nothing execution of a database transaction.
Q2

A relation is in 2NF if it is in 1NF and contains no:

medium
Q3

What does the "I" in the ACID properties of database transactions stand for?

easy
Q4

A relation is in Second Normal Form (2NF) if it is in 1NF and contains no:

medium
Showing 21 to 24 of 24 questions