📝 Question
#1103
A ________ on an attribute of a relation is a data structure that allows the database system to find those tuples in the relation that have a specified value for that attribute efficiently, without scanning through all the tuples of the relation.
✓
Correct Answer
A. Index
💡
Explanation
Index is the reference to the tuples in a relation. 3. Create index studentID_index on student(ID); a) StudentID_index b) ID c) StudentID d) Student The statement creates an index named studentID index on the attribute ID of the relation student.
⌨️ Press
A
B
C
D
to select