Multiple choice technology databases

Referring to the above scenario, what structure will you deploy?

  1. Cursor table

  2. Table filter

  3. Dynamic procedure

  4. View

  5. Summary table
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Without seeing the scenario, this appears to be about choosing between database structures for a reporting/analysis need. A View is the best choice when you need to query data from multiple tables without duplicating data. Views provide a logical abstraction layer. Table filter and dynamic procedure are not standard SQL structures, while a cursor table would be inefficient.

Keep practicing — related questions