Final answer:
The incorrect statement about Persistent Stored Modules (PSM) is that 'Subqueries can be used in every place, where a subquery is legal in SQL' as subqueries have some restrictions within PSM contexts.
Step-by-step explanation:
The student has asked which of the following is not applied in PSM (Persistent Stored Modules in SQL). The options provided are:
- None of the others
- Subqueries can be used in every place, where a subquery is legal in SQL
- Cursors are used to handle the result of queries
- Queries that return a single value can be used as the right sides of assignment statements
The correct answer here is that 'Subqueries can be used in every place, where a subquery is legal in SQL' is not applied in PSM. While subqueries can often be used in SQL, they are not always legal to use in every context within PSM, such as within certain clauses or in a setting where they may cause ambiguity or other issues.
PSM does indeed allow the use of cursors to handle the results of queries, and it also permits queries that return a single value to be used as the right side of assignment statements, which are common operations in procedural SQL extensions.