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

Which property of a transaction ensures that either all operations within the transaction are completed successfully, or none of them are?
Which of the following is NOT a common type of error encountered during software development?
Which of the following is a common technique for concurrency control in databases?
Which of the following is a type of database index?
Which join should be used when you want to list all customers and any orders they may have placed, including customers who haven’t placed any orders?
Which OOP concept directly influences control flow by allowing different implementations of a method to be called based on the type of the object at runtim...
Which SQL command is used to add new rows of data into a table?
What is a page fault?
In two-phase locking, a transaction releases its locks:
When debugging a recursive function that processes a `Tree` data structure, what is a common strategy to identify infinite recursion or incorrect base case...

Relevant for Exams:

Central Bank of India SO

Hey! Ask a query

ask-question