Question
An ER diagram has entity sets A, B and C. A and B are related by a 1:N relationship (B on the N side, with total participation of
- B , and B and C are related by an M:N relationship. What is the minimum number of relational tables needed?
More IT DBMS Questions
- A table contains 1,000,000 records, and a B+ tree index built on it has a fan-out (branching order) of exactly 100 at each internal node. What is the appro...
- Transaction T1 holds a lock on Row A and requests a lock on Row B. Transaction T2 holds a lock on Row B and requests a lock on Row A. Both use strict Two-P...
- A table contains 50,000,000 records, and a B+ tree index built on it has a fan-out (branching order) of exactly 60 at each internal node. What is the minim...
- T1 updates a row but has not committed; T2 reads that updated value; T1 then rolls back. What anomaly did T2 experience?
- In database normalization theory, which anomaly specifically refers to the unintended loss of information when a record is removed, because that record hap...
- MVCC (Multi-Version Concurrency Control) ensures:
- In a 'clustered' index on a database table, what distinguishes it from a non-clustered index?
- Which normal form in relational database design specifically eliminates transitive dependency of non-key attributes on the primary key?
- A relation R(A, B, C, D) has the functional dependencies AB → C, C → D and D → A. What is the highest normal form that R satisfies?
- A transaction T1 updates a row and then waits for a lock held by T2. T2 is waiting for a lock held by T1. What condition has occurred?
Hey! Ask a query
Please enter email id
The email must be a valid email address.
Please enter Mobile Number
Please enter valid Mobile Number
Please enter your Doubt
Think You're Ready for RBI Grade B?
RBI Grade B 2026 Phase 1 Memory Based Paper
- 200 Questions with Detailed Solutions
- Section-wise Coverage (GA, English, Quant & Reasoning)