CoreHRx Jobs

Apply in one click, save jobs and take free mock tests.

Register free Log in
Hiring? Post jobs with CoreHRx
My account
user

View & update profile

DBMS mock test: free online practice

15 to 30 random questions in 15 to 30 minutes, by the level you choose: er, keys, sql, joins, normalization, transactions and indexing. After you submit you get your score, your strong and weak topics, and the right answer with an explanation for every question.

Want to revise first? Read the DBMS interview questions and answers.

Choose your level

Free with a CoreHRx Jobs account: you will be asked to sign in or create one first.

What does the DBMS mock test cover?

The test covers 12 topics across three levels. Each attempt picks 15 to 30 questions at random, by the level you choose, so every attempt is different.

  • SQL Queries
  • Normalization
  • Concurrency Control
  • Indexing and Hashing
  • ER Model
  • Transactions and ACID
  • Functional Dependencies
  • Joins
  • Keys and Relational Model
  • Relational Algebra
  • Recovery
  • Query Processing

Sample DBMS mock test questions

One question from each level, the way they appear in the test. A new set comes on the 1st of every month. Try it, then open the answer.

  1. EasyKeys and Relational Model

    In R(A, B, C), the only candidate key is A. How many superkeys does R have?

    • 1
    • 4
    • 3
    • 7
    Show the answer

    Answer: 4. A superkey is any set that contains a candidate key. With A fixed in, B and C can each be in or out, so there are 2 x 2 = 4: A, AB, AC and ABC. Counting by brute force over all 7 non-empty subsets gives the same 4.

  2. MediumSQL Queries

    What value does this query return? (Ignore how many decimal places each database prints.)

    fees:
    student  paid
    Asha     60
    Bilal    80
    Chitra   NULL
    Dev      100
    
    SELECT AVG(paid)
    FROM fees;
    • 60
    • 80
    • NULL
    • 240
    Show the answer

    Answer: 80. AVG skips NULLs, so it adds 60 + 80 + 100 = 240 and divides by the 3 non-NULL values, giving 80. If the missing fee should count as 0, write AVG(COALESCE(paid, 0)), which divides by 4 and returns 60.

  3. HardRecovery

    In ARIES, in what order are the recovery phases run after a crash?

    • Undo, redo, analysis
    • Analysis, redo, undo
    • Analysis, undo, redo
    • Redo, analysis, undo
    Show the answer

    Answer: Analysis, redo, undo. Analysis scans from the last checkpoint to rebuild the dirty page and transaction tables. Redo repeats history from the earliest needed LSN so the database is as it was at the crash. Undo then rolls back the losers, newest change first.

Take the full DBMS mock test: 15 to 30 questions and 15 to 30 minutes, by level.

How is the DBMS mock test scored?

A question counts as right only when you pick exactly the right option, or all the right options where it says so; a question left blank counts as wrong. Your score is the share of the test's questions you got right (15 to 30, by level). The result also scores every topic, so you know what to revise before the interview.

  • 75% or more in a topica strength
  • 50% to 74%worth a revision
  • Under 50%a topic to work on

DBMS mock test: questions people ask

Is the DBMS mock test free?

Yes. The DBMS mock test is free. You need a free CoreHRx Jobs account to start it, so your score and the topics to work on are saved.

How many questions are in the DBMS mock test?

It depends on the level: Easy has 15 questions in 15 minutes, Medium has 20 questions in 20 minutes, Hard has 30 questions in 30 minutes. They are multiple-choice questions picked at random from a larger bank of DBMS questions at your level, so every attempt is different.

Which DBMS topics does the test cover?

The questions cover SQL Queries, Normalization, Concurrency Control, Indexing and Hashing, ER Model, Transactions and ACID, Functional Dependencies, Joins, Keys and Relational Model, Relational Algebra, Recovery, Query Processing. Your result shows how you did in each topic.

Which level should I choose?

Easy: Keys, ER basics, normal forms and simple SQL queries. Medium: Joins, normalization, transactions and indexing. Hard: Concurrency control, recovery, query plans and tricky normal-form cases. Start with Easy and move up.

Can employers see my DBMS score?

Only your best DBMS score, and only when it is 60% or more. It shows on the job applications you send on CoreHRx. Lower scores stay private.

Can I take the DBMS mock test again?

Yes, up to 10 tests a day. Each attempt picks questions you have not seen recently first.

All mock tests