Which database structure is created to drastically speed up the retrieval of rows from a table at the expense of slower data updates? MCQ with Answer and Explanation
Which database structure is created to drastically speed up the retrieval of rows from a table at the expense of slower data updates?
A. Index
B. View
C. Constraint
D. Schema
Answer: Option A
Solution (By JKSSB Mock Tests)
An Index is a performance optimization structure created on table columns to search and locate matching rows quickly without performing a full table scan.
No comments yet. Be the first to start the discussion!