18 Views & Programmability questions from the SQL bank, written for Indian campus drives and tech interviews. Every question has a verified answer and an AI-tutor explanation on placd.
Free to start: the 2-minute IT readiness check — six questions and a result.
A.a server-side control structure that fetches query results one row (or batch) at a time for procedural iteration
B.a routine the database fires automatically before or after an insert, update, or delete event on a table
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
D.a callable routine that takes arguments and returns a value or table, usable directly inside SELECT expressions
Answer + AI explanation with Pro
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
A.stored procedure
B.user-defined function
C.view
D.materialized view
Answer + AI explanation with Pro
3. Which statement is correct?
Junior
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
B.view — a routine the database fires automatically before or after an insert, update, or delete event on a table
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
D.view — a callable routine that takes arguments and returns a value or table, usable directly inside SELECT expressions
Answer + AI explanation with Pro
4. What is materialized view?
Mid
A.a precompiled named routine of SQL statements invoked with CALL that can perform actions and manage transactions but need not return a value
B.a routine the database fires automatically before or after an insert, update, or delete event on a table
C.a view whose query result is physically stored on disk for fast reads and must be explicitly refreshed to reflect underlying data changes
D.a callable routine that takes arguments and returns a value or table, usable directly inside SELECT expressions
Answer + AI explanation with Pro
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
A.user-defined function
B.materialized view
C.trigger
D.view
Answer + AI explanation with Pro
6. Which statement is correct?
Mid
A.materialized view — a callable routine that takes arguments and returns a value or table, usable directly inside SELECT expressions
B.materialized view — a server-side control structure that fetches query results one row (or batch) at a time for procedural iteration
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
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
Answer + AI explanation with Pro
7. What is stored procedure?
Mid
A.a view whose query result is physically stored on disk for fast reads and must be explicitly refreshed to reflect underlying data changes
B.a server-side control structure that fetches query results one row (or batch) at a time for procedural iteration
C.a precompiled named routine of SQL statements invoked with CALL that can perform actions and manage transactions but need not return a value
D.a callable routine that takes arguments and returns a value or table, usable directly inside SELECT expressions
Answer + AI explanation with Pro
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
A.user-defined function
B.trigger
C.stored procedure
D.view
Answer + AI explanation with Pro
9. Which statement is correct?
Mid
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
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
C.stored procedure — a routine the database fires automatically before or after an insert, update, or delete event on a table
D.stored procedure — a server-side control structure that fetches query results one row (or batch) at a time for procedural iteration
Answer + AI explanation with Pro
10. What is trigger?
Mid
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
B.a callable routine that takes arguments and returns a value or table, usable directly inside SELECT expressions
C.a view whose query result is physically stored on disk for fast reads and must be explicitly refreshed to reflect underlying data changes
D.a routine the database fires automatically before or after an insert, update, or delete event on a table
Answer + AI explanation with Pro
11. Which term means: "a routine the database fires automatically before or after an insert, update, or delete event on a table"?
Mid
A.stored procedure
B.cursor
C.trigger
D.materialized view
Answer + AI explanation with Pro
12. Which statement is correct?
Mid
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
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
C.trigger — a callable routine that takes arguments and returns a value or table, usable directly inside SELECT expressions
D.trigger — a routine the database fires automatically before or after an insert, update, or delete event on a table
Answer + AI explanation with Pro
13. What is user-defined function?
Mid
A.a callable routine that takes arguments and returns a value or table, usable directly inside SELECT expressions
B.a server-side control structure that fetches query results one row (or batch) at a time for procedural iteration
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
D.a routine the database fires automatically before or after an insert, update, or delete event on a table
Answer + AI explanation with Pro
14. Which term means: "a callable routine that takes arguments and returns a value or table, usable directly inside SELECT expressions"?
Mid
A.trigger
B.materialized view
C.user-defined function
D.cursor
Answer + AI explanation with Pro
15. Which statement is correct?
Mid
A.user-defined function — a callable routine that takes arguments and returns a value or table, usable directly inside SELECT expressions
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
C.user-defined function — a server-side control structure that fetches query results one row (or batch) at a time for procedural iteration
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
Answer + AI explanation with Pro
16. What is cursor?
Senior
A.a view whose query result is physically stored on disk for fast reads and must be explicitly refreshed to reflect underlying data changes
B.a precompiled named routine of SQL statements invoked with CALL that can perform actions and manage transactions but need not return a value
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
D.a server-side control structure that fetches query results one row (or batch) at a time for procedural iteration
Answer + AI explanation with Pro
17. Which term means: "a server-side control structure that fetches query results one row (or batch) at a time for procedural iteration"?
Senior
A.trigger
B.cursor
C.materialized view
D.user-defined function
Answer + AI explanation with Pro
18. Which statement is correct?
Senior
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
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
C.cursor — a callable routine that takes arguments and returns a value or table, usable directly inside SELECT expressions
D.cursor — a server-side control structure that fetches query results one row (or batch) at a time for procedural iteration
Answer + AI explanation with Pro
Free to start
Start with a free readiness check
Sign up free for the 2-minute IT readiness check and a scored result. Answers, explanations and the AI tutor on every Views & Programmability question come with Pro.