Can you tell what a view in SQL is?
1Times asked
May 2026Last seen
May 2026First seen
💡 Model Answer
A view is a virtual table defined by a SELECT query. It does not store data physically but presents data from one or more tables as if it were a single table. Views can simplify complex queries, provide a level of abstraction, and enforce security by exposing only specific columns or rows. For example, a view called ActiveCustomers might select only customers with status='Active' from the Customers table.
This answer was generated by AI for study purposes. Use it as a starting point — personalize it with your own experience.
🎤 Get questions like this answered in real-time
Assisting AI listens to your interview, captures questions live, and gives you instant AI-powered answers — invisible to screen sharing.
Get Assisting AI — Starts at ₹500