Which term describes a fast-access structure that holds copies of original values and is not part of the SQL standard?

• A. Index
• B. Cache
• C. View
• D. Snapshot

Answer: (B)

Caching is a fast-access storage layer that holds copies of original values and is not part of the SQL standard. This setup speeds data retrieval by serving repeated requests from the cache instead of re-reading from the underlying tables. An index speeds lookups and is a standard database structure; it doesn’t typically store full copies of data values. A view is a saved query and, unless materialized, doesn’t store data copies. A snapshot captures data at a specific moment and isn’t designed as a general fast-access layer.