What is a view in SQL and why use it?
This question explores the concept of virtual tables and their utility in simplifying complex queries. It assesses security and abstraction skills.
Why Interviewers Ask This
Recruiters ask this to see if you understand database abstraction layers. They want to know if you can design solutions that hide complexity from end-users. It also checks your awareness of security practices, as views are often used to restrict access to sensitive columns.
How to Answer This Question
Define a view as a virtual table based on a query result. Explain that it does not store data physically. Highlight three main benefits: simplifying complex joins, improving code readability, and enhancing security by limiting column visibility. Provide a brief example scenario.
Key Points to Cover
- Virtual table definition
- No physical data storage
- Simplifies complex queries
- Enhances data security
Sample Answer
A view is a virtual table created by a SELECT query that does not store data itself but presents data from one or more tables. It simplifies complex queries by encapsulating logic, making them easier to read and maintain. Views also enhance security by allowing us to restrict access to specific rows or columns without altering the underlying table structure.
Common Mistakes to Avoid
- Claiming views store data physically
- Failing to mention security benefits
- Not explaining the query encapsulation aspect
Practice This Question with AI
Answer this question orally or via text and get instant AI-powered feedback on your response quality, structure, and delivery.
Related Interview Questions
Describe a PRIMARY KEY and how it differs from a UNIQUE key
Medium
What is ER model in the DBMS?
Medium
FlipkartWhat is the difference between LIKE and equals operators in SQL?
Easy
TCSWhat is the difference between UNION and UNION ALL?
Easy
What is Join and explain its types?
Medium
FlipkartWhat is the ER model in DBMS?
Easy
Flipkart