Q1. Are views updatable?
**Some views are updatable, but under strict structural criteria**: ### Conditions for a View to Be Updatable: 1. Must reference **only one base table** in the `FROM` cla...
Technical Question Bank · Peer-Reviewed
Job Interview Questions and Answers Directory
Search and filter frequently asked interview questions across technical, programming, and behavioral domains. Tailor your interview preparation by difficulty for freshers or experienced developers (4 available).
Active:
Tag: views ×
Q2. Advantages of views?
1. **Simplify complex queries** — hide JOINs and aggregations 2. **Security** — expose only specific columns/rows 3. **Logical independence** — shield apps from schema ch...
Q3. Does a view contain data?
**Standard SQL views do NOT contain data**. - **Standard Views (Virtual)**: Contain only a stored SQL query definition in the data dictionary. Every query against the vie...
Q4. Can a view be based on another view?
**Yes**, a view can be defined on top of another existing view (known as a **nested view**): ```sql CREATE VIEW us_customers AS SELECT * FROM Customers WHERE country = 'U...