GATE CS DBMS MCQ Questions | Schoolabe

Q1easy

What does ACID stand for in database transactions?

A)Atomicity, Consistency, Isolation, Durability

B)Accuracy, Consistency, Integrity, Durability

C)Atomicity, Correctness, Isolation, Durability

D)Accuracy, Correctness, Integrity, Durability

Q2easy

What is the minimum normal form that requires all attributes to be atomic?

A)2NF

B)3NF

C)1NF

D)BCNF

Q3easy

What is a functional dependency?

A)X determines Y uniquely

B)Y determines X uniquely

C)X and Y are equal

D)X and Y are independent

Q4easy

What is the main purpose of normalization?

A)Increase redundancy

B)Reduce redundancy and eliminate anomalies

C)Increase storage

D)Simplify queries

Q5easy

What is a candidate key?

A)Any set of attributes

B)Minimal superkey

C)Foreign key

D)Primary key only

Q6medium

What is the result of R1 ⋈ R2 (natural join)?

A)Cartesian product

B)Union

C)Join on common attributes

D)Intersection

Q7easy

What is a foreign key?

A)Primary key of same table

B)Attribute that references primary key of another table

C)Unique key

D)Composite key

Q8medium

What is the main advantage of B+ tree over B-tree for database indexing?

A)Less memory

B)Better for range queries

C)Faster insert

D)Simpler structure

Q9medium

What is a lost update problem?

A)Transaction fails

B)One transaction overwrites another's update

C)Read uncommitted data

D)Deadlock occurs

Q10easy

What is the main purpose of a shared lock?

A)Prevent all access

B)Allow multiple reads, prevent writes

C)Allow writes

D)Lock entire database

GATE CS - Databases (DBMS)