A _____ is a block of code containing standard SQL statements and procedural extensions that is stored and executed at the DBMS server.
A) cursor-style process
B) statement-level trigger
C) base table
D) persistent storage module (PSM)

Question

Quizplus · Accepted Answer

A persistent storage module (PSM) is a block of code that is stored and executed on the DBMS server. It contains both standard SQL statements and procedural language extensions, allowing for more complex data manipulation and processing. Examples of PSM languages include PL/SQL for Oracle databases and Transact-SQL for Microsoft SQL Server.

A _____ Is a Block of Code Containing Standard SQL