Which of the following describes a precompiled collection of SQL statements stored on the database server that can be executed repeatedly by name? MCQ with Answer and Explanation
Which of the following describes a precompiled collection of SQL statements stored on the database server that can be executed repeatedly by name?
A. Trigger
B. View
C. Cursor
D. Stored Procedure
Answer: Option D
Solution (By JKSSB Mock Tests)
A Stored Procedure is a precompiled group of SQL statements and optional control-of-flow code stored in the database server, enhancing execution speed and security.
Explanation:
An Index is a performance optimization structure created on table columns to search and locate matching rows quickly without performing a full table scan.
Explanation:
A Common Table Expression (CTE) provides a temporary named result set that can be used within a SELECT, INSERT, UPDATE, or DELETE statement.
No comments yet. Be the first to start the discussion!