Question
Indexes improve query performance but can degrade performance of:
More IT DBMS Questions
- Which normal form eliminates transitive dependency?
- T1 updates a row but has not committed; T2 reads that updated value; T1 then rolls back. What anomaly did T2 experience?
- What is a 'foreign key' in a relational database?
- What is the output of the following pseudo-code? ``` count = 0 for i from 1 to 3: for j from 1 to i: count = count + 1 ...
- In DBMS concurrency control, a 'wait-for graph' is constructed with transactions as nodes and directed edges representing which transaction is waiting for ...
- A transaction that reads a value then later sees a different value because another transaction updated and committed in between experiences which anomaly?
- What does the ‘’ element in HTML5 allow you to do?
- Which transaction isolation level permits non-repeatable reads and phantom reads while still guaranteeing that dirty reads never occur?
- A designer wants to remove a transitive dependency of a non-key attribute on a candidate key. Which normal form directly addresses this?
- Which SQL isolation level allows phantom reads but prevents dirty reads and non-repeatable reads?
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)