SQL Roadmap from Zero to Advance

Take this DBMS MCQ Test to check your database knowledge for interviews and job preparation.

DBMS MCQ Test

Procedure executed automatically on events

Which of the following is a basic relational algebra operation?

Two transactions wait indefinitely for each other

What is the main purpose of normalization in databases?

What does the ROLLBACK command do in SQL?

WHERE works on groups, HAVING works on rows

HAVING filters groups, WHERE filters rows

What is the difference between WHERE and HAVING in SQL?

Which of the following is an aggregate function in SQL?

Atomicity, Consistency, Isolation, Durability

What do the ACID properties stand for in a database system?

Improves read performance at the cost of redundancy

What is the purpose of denormalization in a database?

What is the purpose of a primary key in a database?

What is the purpose of using an index in SQL?

Rollback of one transaction leads to others being rolled back

Only committed transactions are rolled back

What is the condition for Boyce-Codd Normal Form (BCNF)?

What does Third Normal Form (3NF) remove?