A table used to determine the location of rows in a file that satisfy some condition best describes:
A)relation
B)structure chart
C)index
D)domain table

Question

Quizplus · Accepted Answer

An index is used to determine the location of rows in a file that satisfy some condition. It is a data structure that improves the speed of data retrieval operations on a database table. Option A (relation) refers to a table in a relational database. Option B (structure chart) refers to a diagram that shows the structure of a computer program. Option D (domain table) is not a commonly used term in database management.

A Table Used to Determine the Location of Rows in a File