Question
A relational database management system needs to store millions of employee records on disk and support fast search, insertion, deletion, and range queries. Which data structure is most suitable as the underlying index structure?
More IT DBMS Questions
- A view is created by joining two tables using an INNER JOIN and includes a GROUP BY with an aggregate function. Which statement about this view is correct?
- In database management, what is a 'foreign key'?
- ACID properties in DBMS ensure:
- A relational database management system needs to store millions of employee records on disk and support fast search, insertion, deletion, and range queries...
- Which of the following is a non-relational database?
- A relation R(A, B, C, D, E) has candidate key {A, C}, with functional dependencies A -> B, BC -> D, and D -> E holding. What is the highest normal form tha...
- A company needs to schedule a maximum number of meetings in a single conference room. Each meeting `i` has a start time `s_i` and an finish time `f_i`. Onc...
- A relation R(A, B, C, D) has functional dependencies A -> B, A -> C, and C -> D, with A as the only candidate key. What is the highest normal form satisfie...
- A file of 10,000 fixed-length records of 128 bytes each is stored sorted on its key in disk blocks of 1024 bytes (unspanned). How many block accesses are n...
- Which query correctly finds department IDs where the average salary exceeds the overall average salary across all employees?
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)