SQL - Views
Why might a database administrator prefer using views instead of granting direct table access to users?
Why might a database administrator prefer using views instead of granting direct table access to users?
hard📝 Conceptual Q10 of 15
Step-by-Step Solution
Solution:
Step 1: Understand security advantages of views
Views can limit user access to only certain columns or rows, protecting sensitive data.Step 2: Evaluate other options
Options B, C, and D describe features not provided by views.Final Answer:
Views provide controlled access by exposing only specific data, enhancing security. -> Option BQuick Check:
Views enhance security by controlling data exposure [OK]
Quick Trick: Use views to limit user data access for security [OK]
Common Mistakes:
MISTAKES- Thinking views improve write speed
- Assuming views backup data
- Believing views allow schema changes
Master "Views" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes