Login / Signup

Question

What is the purpose of 'indexing' in a database?

A To encrypt table columns for security

B To create a backup copy of important tables so as to minimize data loss

C To create a data structure that speeds up data retrieval operations

D To normalize table data to reduce redundancy and increase efficiency

E To partition a large table across multiple servers

Practice Next

More IT DBMS Questions

You have a Python list of fruits and want to extract a specific sub-list using slicing. Complete the missing part of the code to obtain the sub-list `['b...
A relation is in 2NF if:
What is a table joined with itself called?
What is context switching?
Given a relation R(A, B, C, D, E) and functional dependencies {A -> B, BC -> D, D -> E}. Which of the following is a candidate key for R?
Which of the following is a property of a relational database?
An RDBMS provides mechanisms for data integrity, such as primary keys and foreign keys, which are generally lacking in:
In indexing, which tree is most commonly used for disk-based indexing because it minimizes disk seeks and keeps nodes dense?
In relational algebra, the operation that combines tuples from two relations using common attribute values is:
Distributed 2-Phase Commit (2PC) can suffer from:

Relevant for Exams:

Central Bank of India SO

Hey! Ask a query

ask-question

🎓

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)

Download Now 100% Free PDF