Computer ScienceDBMSmixed

DBMS Quiz

Practice quiz on DBMS (Computer Science). 10 exam-style questions with explanations.

10
Minutes
10
Marks
FREE
Access

About This Quiz

Practice quiz on DBMS (Computer Science). 10 exam-style questions with explanations. DBMS Quiz is a free, 10-minute, 10-mark practice quiz on AajExam rated at mixed difficulty, designed to help candidates preparing for SSC, UPSC, Banking, Railway and State PSC government competitive exams sharpen their command of DBMS (Computer Science). Every question on this quiz ships with a detailed step-by-step solution so you don't just learn the right answer — you learn the reasoning and shortcuts top scorers use to crack similar questions faster on the actual exam day. Why DBMS Quiz matters in your preparation: government exam-conducting bodies repeatedly draw questions from the same chapters and the same skill-clusters across recruitment cycles. By attempting focused topic-wise quizzes like this one, you build pattern recognition — the ability to spot which formula, rule or trick applies the moment you see a question. Toppers consistently report that 5-10 quizzes on a single topic delivers more exam-day score gain than 20+ unfocused full-length mocks, because targeted drilling exposes your specific sub-topic weaknesses with surgical precision. How to use this quiz effectively: attempt it in one sitting under the 10-minute timer, without referring to notes or external resources — simulate exam-day conditions exactly. After submission, review the auto-generated analytics to see your accuracy, time per question and section-wise performance. Then go through every wrong and skipped question with the explanation, mentally tagging the underlying concept rather than just memorising the answer. Revisit this quiz after 7-10 days; your second attempt should be 15-20% faster with noticeably better accuracy. After mastering this quiz, explore the 2 related quizzes linked below to broaden your topic coverage. AajExam quiz design principles: every quiz on the platform is curated by subject experts using the actual question formats, difficulty distributions and time pressures of the target government exams. We deliberately avoid generic "textbook" questions in favour of exam-replicating ones. Solutions are written in plain English (and Hindi where source material was bilingual), with step-by-step working for quantitative problems, grammar rules for English questions, and direct reference statements for general awareness items. Performance analytics after each attempt include accuracy, attempt rate, time spent per question, and an estimated all-India percentile so you know exactly where you stand against other candidates. This quiz is completely free to attempt. You only need a free AajExam account to track your performance across attempts, view detailed solutions and unlock the platform-wide analytics dashboard. The platform is mobile-friendly and works seamlessly on smartphones, tablets and desktops — so you can sharpen your DBMS (Computer Science) skills in any spare 15-minute window.
Loading quiz preview…

DBMS Quiz — Questions with Solutions

All 10 questions from this quiz with the correct answer and explanation. Attempt them yourself first, then open each solution to check your reasoning.

  1. Q1.DBMS stands for

    • A.Data Backup Management System
    • B.Data Base Mapping System
    • C.Database Management System
    • D.Digital Base Management Software
    Show answer

    Answer: C. Database Management System

    DBMS manages databases.

  2. Q2.Which language is used to query a relational database?

    • A.C
    • B.CSS
    • C.SQL
    • D.HTML
    Show answer

    Answer: C. SQL

    SQL is Structured Query Language.

  3. Q3.A primary key

    • A.Links two databases
    • B.Can have duplicate values
    • C.Can be null always
    • D.Uniquely identifies each record in a table
    Show answer

    Answer: D. Uniquely identifies each record in a table

    A primary key is unique and not null.

  4. Q4.Which SQL command is used to retrieve data?

    • A.INSERT
    • B.SELECT
    • C.UPDATE
    • D.DELETE
    Show answer

    Answer: B. SELECT

    SELECT retrieves rows from a table.

  5. Q5.In a relational database, a row is also called a

    • A.Tuple
    • B.Domain
    • C.Attribute
    • D.Schema
    Show answer

    Answer: A. Tuple

    A row is a tuple; a column is an attribute.

  6. Q6.Which normal form removes partial dependency?

    • A.First normal form
    • B.BCNF
    • C.Second normal form
    • D.Third normal form
    Show answer

    Answer: C. Second normal form

    2NF removes partial dependency on a candidate key.

  7. Q7.ACID properties are related to

    • A.Programming
    • B.Hardware
    • C.Transactions
    • D.Networking
    Show answer

    Answer: C. Transactions

    ACID: Atomicity, Consistency, Isolation, Durability.

  8. Q8.A foreign key is used to

    • A.Delete a table
    • B.Encrypt data
    • C.Sort data
    • D.Link two tables
    Show answer

    Answer: D. Link two tables

    A foreign key references the primary key of another table.

  9. Q9.Which SQL command removes a table completely?

    • A.DROP TABLE
    • B.REMOVE
    • C.DELETE
    • D.CLEAR
    Show answer

    Answer: A. DROP TABLE

    DROP TABLE removes the table structure and data.

  10. Q10.The E-R model was proposed by

    • A.Dennis Ritchie
    • B.Peter Chen
    • C.E.F. Codd
    • D.Charles Babbage
    Show answer

    Answer: B. Peter Chen

    Peter Chen introduced the Entity-Relationship model.

Frequently Asked Questions

Is DBMS Quiz free to attempt on AajExam?

Yes. DBMS Quiz is completely free. You only need a free AajExam account to track your score, view detailed solutions and unlock cross-attempt analytics.

How long does it take to complete DBMS Quiz?

DBMS Quiz runs on a 10-minute timer in real exam-style conditions. The clock starts the moment you click Start, mirroring the time pressure of the actual exam.

Are detailed solutions provided?

Yes. Every question on DBMS Quiz ships with a complete step-by-step solution, the underlying concept, and (where applicable) shortcut tricks. You can also discuss any question with the AajExam community.

Can I attempt DBMS Quiz multiple times?

Yes. You can attempt this quiz as many times as you like. Each attempt is recorded separately so you can track improvement in score, accuracy and time-management.

Which government exams does this quiz prepare me for?

DBMS questions appear regularly in SSC CGL, CHSL, MTS, GD; IBPS PO, Clerk; SBI PO, Clerk; RRB NTPC, Group D; UPSC prelims and most State PSC exams. The specific weightage varies by exam — check the exam pattern on the corresponding AajExam exam page for details.

Related DBMS Quizzes

Database Basics Quiz 2
Database Basics Quiz