Examine the following code: Which two statements are true about the above function? (Choose two.)

The correct answer is B. It can be used in both a parallelized query and a parallelized DML statement. D. It can have a separate copy run in each of the multiple processes when called from a SQL. A RESTRICT_REFERENCES pragma can appear ONLY IN A PACKAGE SPECIFICATION or object type specification. Typically, this pragma is specified for functions. If a function calls procedures, specify the pragma for those procedures also. The RESTRICT REFERENCES pragma is deprecated…

Creating Stored Procedures and Functions

Question

Examine the following code:

Which two statements are true about the above function? (Choose two.)

Exhibit

Options

AIt can be used only in a parallelized query.
BIt can be used in both a parallelized query and a parallelized DML statement.
CIt can be used only in a parallelized data manipulation language (DML) statement.
DIt can have a separate copy run in each of the multiple processes when called from a SQL
EIt requires a PRAGMA RESTRICT_REFERENCES declaration with RNDS, WNDS, RNPS, and

How the community answered

(61 responses)

A
3% (2)
B
74% (45)
C
15% (9)
E
8% (5)

Explanation

A RESTRICT_REFERENCES pragma can appear ONLY IN A PACKAGE SPECIFICATION or object type specification. Typically, this pragma is specified for functions. If a function calls procedures, specify the pragma for those procedures also. The RESTRICT REFERENCES pragma is deprecated. Oracle recommends using DETERMINISTIC and PARALLEL_ENABLE (described in Function Declaration and Definition) instead of RESTRICT REFERENCES.

Topics

#parallel query#parallel DML#PRAGMA RESTRICT_REFERENCES#parallel execution

Community Discussion

No community discussion yet for this question.

Full 1Z0-144 Practice