Question

Which of the followings is applied in PSM

Select one:
a. Queries that return a single value can be used as the right sides of assignment statements
b. All of the others
c. Cursors can be used for embedded SQL
d. Subqueries can be used in every place, where a subquery is legal in SQL

Answer 1

The correct answer is option b, "All of the others." PSM in SQL allows for various functionalities such as returning single values as assignment statements, using cursors for embedded SQL, and utilizing subqueries in any legal place in SQL.

Step-by-step explanation:

Option b, "All of the others," is the correct answer.

PSM, or Persistent Stored Modules, is an extension to SQL that allows procedural programming within a database. It provides various features such as the ability to return single values as the right side of assignment statements, the use of cursors for embedded SQL, and the use of subqueries in any legal place in SQL. These features allow for greater flexibility and functionality in developing complex database applications.