The ____ option specifies the number of rows to process as a group.
A) FORALL
B) NUMROWS
C) BULK COLLECT
D) LIMIT

Question

Quizplus · Accepted Answer

The LIMIT option is used with the FORALL statement to specify the number of rows to process as a group. This improves performance by reducing context switches between the PL/SQL and SQL engines. The other options (A, B, and C) are not related to specifying the number of rows to process as a group.

The ____ Option Specifies the Number of Rows to Process