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

Index

Cache

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.

View

Snapshot

Want more questions?

All options are one-time payments.

$25.99

30 day pass for new members

All the basics to get you started

  • Ad-free experience
  • View your previous attempt history
  • Mobile app access
  • In-depth explanations
  • 30 day premium pass access
$59.99$171.99 usd

6 month DELUXE pass (most popular)

Full access FOR 6 MONTHS! & the ultimate digital PDF study guide (BONUS)

  • $171.99 usd value for $59.99! You save $106!
  • Ad-free experience
  • View your previous attempt history
  • Mobile app access
  • In-depth explanations
  • 6 months of full access
  • Ultimate digital PDF study guide included
  • Priority support
$15.99 $24.99

Ultimate digital PDF study guide

For those that prefer a more traditional form of learning

  • Available for instant download
  • Available offline
  • Hundreds of practice multiple choice questions
  • Comprehensive content
  • Detailed explanations
Image Description
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy