Which of the following statements is true?

Options
- Implicit cursors are not named
- Implicit cursors must be developed by the database developers
- Explicit cursors can handle tables with only 16 rows
- Explicit cursors does not occupy Oracle’s memory space

CORRECT ANSWER : Implicit cursors are not named

Discussion Board
Implicit Cursor

Implicit cursors are automatically created by Oracle whenever an SQL statement is executed, when there is no explicit cursor for the statement. Implicit cursors are not named. Implicit cursors are used by Oracle every time you issue a Select statement in PL/SQL. If you use an implicit cursor, Oracle will perform the open, fetches, and close for you automatically. Implicit cursors are used in statements that return only one row.

Prajakta Pandit 02-9-2017 04:23 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲