Bird
0
0

Why might a database designer choose to use views instead of giving users direct access to base tables?

hard📝 Conceptual Q10 of 15
SQL - Views
Why might a database designer choose to use views instead of giving users direct access to base tables?
ATo automatically backup data without extra tools
BTo improve query performance by storing data physically
CTo allow users to modify table structures easily
DTo provide a consistent interface while hiding table complexity
Step-by-Step Solution
Solution:

  1. Step 1: Consider the role of views in abstraction

    Views hide the complexity of underlying tables and present a simple, consistent interface.

  2. Step 2: Understand why direct access is limited

    Restricting direct access protects data integrity and simplifies user interaction.

  3. Final Answer:

    To provide a consistent interface while hiding table complexity -> Option D

  4. Quick Check:

    Views abstract complexity and improve usability [OK]
Quick Trick: Views hide complexity and simplify user access [OK]
Common Mistakes:
MISTAKES
  • Thinking views store data physically
  • Assuming views allow easy table structure changes
  • Believing views handle backups automatically

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More SQL Quizzes
Advanced Joins - Non-equi joins - Quiz 1easy GROUP BY and HAVING - GROUP BY with NULL values behavior - Quiz 7medium GROUP BY and HAVING - GROUP BY with NULL values behavior - Quiz 3easy INNER JOIN - INNER JOIN with multiple conditions - Quiz 4medium LEFT and RIGHT JOIN - Why outer joins are needed - Quiz 4medium Subqueries - Why subqueries are needed - Quiz 2easy Subqueries - Why subqueries are needed - Quiz 13medium Subqueries - Correlated subquery execution model - Quiz 1easy Subqueries - Scalar subquery in SELECT - Quiz 3easy Table Constraints - Composite primary keys - Quiz 10hard