An ________ on an attribute of a relation is a data structure that allows the d

Question

An ________ 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.

Options:

A . Index

B . Reference

C . Assertion

D . Timestamp

Answer: Option A

IndexIndex is the reference to the tuples in a relation.

Was this answer helpful ?

Next Question

Submit Solution

More Questions on This Topic :

Question 1. The user defined data type can be created using ....

Question 2. Which of the following is used to store movie and image files ? ....

Question 3. Which of the following closely resembles Create view ? ....

Question 4. Which of the following statements creates a new table temp instructor that has the same schema as instructor. ....

Question 5. In contemporary databases the top level of the hierarchy consists of ______, each of which can contain _____. ....

Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)

Direction Sense Test Part 1 Reasoning (Hindi)

Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE

Cube & Cuboid Part 1 Reasoning (Hindi)

Data Interpretation (DI) Basic Concept Reasoning (Hindi)

Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)

Sail E0 free webinar Webinars

Real Numbers Part 7 Class 10 Maths

Real Numbers Part 1 Class 10 Maths

Polynomials Part 1 Class 10 Maths

Pie Chart - Test Paper 1 Data Interpretation Reasoning & DI

Tabulation - Test Paper 2 Data Interpretation Reasoning & DI

Test Paper 1 Direction Sense Test Reasoning & DI

ICA , RDIC,GFM Free Modal Test Paper - Non - Technical Branch Old Syllabus 2022 - SAIL Junior Officer E0

GFM Combined 1 Free Revision Test SAIL JO E-0

Submit Solution

More Questions on This Topic :

Latest Videos

Latest Test Papers