Home › BBA › Information Systems › Database Management › Queries on a large table run slowly, so the team…
Queries on a large table run slowly, so the team builds a structure that speeds retrieval. That structure is an:
AAvatar
BAnchor
CIndex
DApplet
Answer & Solution
Correct answer: C. Index
1. It is built on the table.
2. Retrieval gets faster.
3. It is an index.
_Source: OpenStax Foundations of Information Systems, Chapter 3, Database Management Systems._
Related questions
In a table of employees, entering the employee ID gives you the name and address. That relA cloud provider copies data to several geographic locations so a hardware failure cannot Routine database work includes performance tuning, security enforcement and, above all, reSensitive records must be protected both while stored and while moving across the network.A manager asks what data integrity actually means. It refers to the accuracy and:A record still points at another record that has been deleted. That dangling record is calTransactions protect consistency and integrity through four properties: atomicity, consistAnother store keeps huge volumes of raw data in their original format until somebody needs