placd.in

Views & Programmability interview questions

18 real Views & Programmability questions from the SQL bank, as asked in Indian campus drives and tech interviews. Every question has a verified answer and an AI-tutor explanation on placd — free to start.

1. What is view?

Junior
  1. A.a server-side control structure that fetches query results one row (or batch) at a time for procedural iteration
  2. B.a routine the database fires automatically before or after an insert, update, or delete event on a table
  3. C.a named stored query that behaves like a virtual table and re-runs its definition each time it is referenced, storing no data itself
  4. D.a callable routine that takes arguments and returns a value or table, usable directly inside SELECT expressions
Reveal the answer + AI explanation — free account

2. Which term means: "a named stored query that behaves like a virtual table and re-runs its definition each time it is referenced, storing no data itself"?

Junior
  1. A.stored procedure
  2. B.user-defined function
  3. C.view
  4. D.materialized view
Reveal the answer + AI explanation — free account

3. Which statement is correct?

Junior
  1. A.view — a named stored query that behaves like a virtual table and re-runs its definition each time it is referenced, storing no data itself
  2. B.view — a routine the database fires automatically before or after an insert, update, or delete event on a table
  3. C.view — a precompiled named routine of SQL statements invoked with CALL that can perform actions and manage transactions but need not return a value
  4. D.view — a callable routine that takes arguments and returns a value or table, usable directly inside SELECT expressions
Reveal the answer + AI explanation — free account

4. What is materialized view?

Mid
  1. A.a precompiled named routine of SQL statements invoked with CALL that can perform actions and manage transactions but need not return a value
  2. B.a routine the database fires automatically before or after an insert, update, or delete event on a table
  3. C.a view whose query result is physically stored on disk for fast reads and must be explicitly refreshed to reflect underlying data changes
  4. D.a callable routine that takes arguments and returns a value or table, usable directly inside SELECT expressions
Reveal the answer + AI explanation — free account

5. Which term means: "a view whose query result is physically stored on disk for fast reads and must be explicitly refreshed to reflect underlying data changes"?

Mid
  1. A.user-defined function
  2. B.materialized view
  3. C.trigger
  4. D.view
Reveal the answer + AI explanation — free account

6. Which statement is correct?

Mid
  1. A.materialized view — a callable routine that takes arguments and returns a value or table, usable directly inside SELECT expressions
  2. B.materialized view — a server-side control structure that fetches query results one row (or batch) at a time for procedural iteration
  3. C.materialized view — a view whose query result is physically stored on disk for fast reads and must be explicitly refreshed to reflect underlying data changes
  4. D.materialized view — a precompiled named routine of SQL statements invoked with CALL that can perform actions and manage transactions but need not return a value
Reveal the answer + AI explanation — free account

7. What is stored procedure?

Mid
  1. A.a view whose query result is physically stored on disk for fast reads and must be explicitly refreshed to reflect underlying data changes
  2. B.a server-side control structure that fetches query results one row (or batch) at a time for procedural iteration
  3. C.a precompiled named routine of SQL statements invoked with CALL that can perform actions and manage transactions but need not return a value
  4. D.a callable routine that takes arguments and returns a value or table, usable directly inside SELECT expressions
Reveal the answer + AI explanation — free account

8. Which term means: "a precompiled named routine of SQL statements invoked with CALL that can perform actions and manage transactions but need not return a value"?

Mid
  1. A.user-defined function
  2. B.trigger
  3. C.stored procedure
  4. D.view
Reveal the answer + AI explanation — free account

9. Which statement is correct?

Mid
  1. A.stored procedure — a precompiled named routine of SQL statements invoked with CALL that can perform actions and manage transactions but need not return a value
  2. B.stored procedure — a named stored query that behaves like a virtual table and re-runs its definition each time it is referenced, storing no data itself
  3. C.stored procedure — a routine the database fires automatically before or after an insert, update, or delete event on a table
  4. D.stored procedure — a server-side control structure that fetches query results one row (or batch) at a time for procedural iteration
Reveal the answer + AI explanation — free account

10. What is trigger?

Mid
  1. A.a named stored query that behaves like a virtual table and re-runs its definition each time it is referenced, storing no data itself
  2. B.a callable routine that takes arguments and returns a value or table, usable directly inside SELECT expressions
  3. C.a view whose query result is physically stored on disk for fast reads and must be explicitly refreshed to reflect underlying data changes
  4. D.a routine the database fires automatically before or after an insert, update, or delete event on a table
Reveal the answer + AI explanation — free account

12. Which statement is correct?

Mid
  1. A.trigger — a view whose query result is physically stored on disk for fast reads and must be explicitly refreshed to reflect underlying data changes
  2. B.trigger — a named stored query that behaves like a virtual table and re-runs its definition each time it is referenced, storing no data itself
  3. C.trigger — a callable routine that takes arguments and returns a value or table, usable directly inside SELECT expressions
  4. D.trigger — a routine the database fires automatically before or after an insert, update, or delete event on a table
Reveal the answer + AI explanation — free account

13. What is user-defined function?

Mid
  1. A.a callable routine that takes arguments and returns a value or table, usable directly inside SELECT expressions
  2. B.a server-side control structure that fetches query results one row (or batch) at a time for procedural iteration
  3. C.a named stored query that behaves like a virtual table and re-runs its definition each time it is referenced, storing no data itself
  4. D.a routine the database fires automatically before or after an insert, update, or delete event on a table
Reveal the answer + AI explanation — free account

15. Which statement is correct?

Mid
  1. A.user-defined function — a callable routine that takes arguments and returns a value or table, usable directly inside SELECT expressions
  2. B.user-defined function — a precompiled named routine of SQL statements invoked with CALL that can perform actions and manage transactions but need not return a value
  3. C.user-defined function — a server-side control structure that fetches query results one row (or batch) at a time for procedural iteration
  4. D.user-defined function — a view whose query result is physically stored on disk for fast reads and must be explicitly refreshed to reflect underlying data changes
Reveal the answer + AI explanation — free account

16. What is cursor?

Senior
  1. A.a view whose query result is physically stored on disk for fast reads and must be explicitly refreshed to reflect underlying data changes
  2. B.a precompiled named routine of SQL statements invoked with CALL that can perform actions and manage transactions but need not return a value
  3. C.a named stored query that behaves like a virtual table and re-runs its definition each time it is referenced, storing no data itself
  4. D.a server-side control structure that fetches query results one row (or batch) at a time for procedural iteration
Reveal the answer + AI explanation — free account

18. Which statement is correct?

Senior
  1. A.cursor — a view whose query result is physically stored on disk for fast reads and must be explicitly refreshed to reflect underlying data changes
  2. B.cursor — a named stored query that behaves like a virtual table and re-runs its definition each time it is referenced, storing no data itself
  3. C.cursor — a callable routine that takes arguments and returns a value or table, usable directly inside SELECT expressions
  4. D.cursor — a server-side control structure that fetches query results one row (or batch) at a time for procedural iteration
Reveal the answer + AI explanation — free account

Free to start

Answers, AI explanations, and a scored voice mock interview

Sign up free to check your answers with explanations, ask the AI tutor anything on any question, and take one full AI mock interview — scored like a real panel.

Practice Views & Programmability free

More SQL topics

Querying Basics (18)Joins (18)Aggregation & Grouping (18)Subqueries & CTEs (18)Window Functions (18)Indexes & Transactions (18)Set Operations (18)Data Modification (18)Schema & DDL (27)Data Types (27)NULL Handling (24)Advanced Querying (21)