File Organization/Indexing In Database For Gate Exam
File Organization / Indexing In Database Q1 A block size is 4096 bytes. Each record is 128 bytes. Blocking factor
Continue reading
Category: IT
Deadlock in Database MCQs For Gate Exam
We’ll cover: 🧩 Deadlock in Database Systems — MCQs Q1. Transaction T1 holds lock on item A and requests lock
Continue reading
Timestamp Ordering Protocol MCQs For Gate Exam
Timestamp Ordering Protocol MCQs Q1 T1 has timestamp TS(T1) = 5, T2 has TS(T2) = 8.T1 requests W(A), R(A) was
Continue reading
Locking Protocols MCQs for database systems (GATE level)
Locking Protocol MCQs The topics will cover: Locking Protocol MCQs Q1 Schedule: T1: r(A) w(B) , T2: r(B) w(A) with
Continue reading
Recoverability MCQs For Gate Exam
Recoverability MCQs — Q1–Q100 Q1 Schedule: r1(A) w2(A) c2 r1(B) c1Which of the following is true?A. Schedule is recoverableB. Schedule
Continue reading
Serializability MCQs for Gate Exam
Conflict Serializability MCWs for Gate Exam Q1 Schedule: r1(A) r2(B) r1(B) w2(B) w1(A) c1 c2Is this schedule conflict-serializable?A. Yes; equivalent
Continue reading
Relational Calculus MCQs for Gate Exam
Relational Calculus MCQs (Q1–Q100) Q1. Consider relation Student(SID, Name, Age, Marks).Which of the following Tuple Relational Calculus (TRC) expressions retrieves
Continue reading
Structural Query Language(SQL) MCQs for Gate exam
SQL (Structural / Advanced) MCQs — GATE level Each question: 4 options (A–D). Correct answer shown with a short, clear
Continue reading
RELATIONAL ALGEBRA MCQs for Gate Exam
Relational Algebra MCQs (for GATE DBMS) — Each question includes 4 options (A–D) and a complete solution. RELATIONAL ALGEBRA (Concepts
Continue reading
Lossless Decomposition and Dependency-Preserving Decompositions For Gate Exam
lossless decomposition and dependency-preserving decompositions in relational schemas (DBMS / GATE style).Each question has four options (A–D), the correct answer,
Continue reading