Multiple choice technology databases

Statistics cannot be collected on this table

  1. Permanent Table

  2. Set Table

  3. Multiset Table

  4. Volatile Table
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Volatile tables are temporary tables that exist only for the duration of a session or transaction. Since they don't persist data and their contents can be deleted at any time, the database cannot reliably collect or maintain statistics on them. Permanent tables, set tables, and multiset tables all persist data and can have statistics collected.

Keep practicing — related questions