Which two statements are true about the usage of the cursor for loops? (Choose two.)
A.
The cursor needs to be closed after the iteration is complete.
B.
The implicit open, fetch, exit, and close of the cursor happen.
C.
The record type must be explicitly declared to control the loop.
D.
The PL/SQL creates a record variable with the fields corresponding to the columns of the
cursor result set.
B, D
B, D
b,d
BD
The CURSOR FOR LOOP will end when all of the records in the cursor have been fetched.
For select_statement, PL/SQL declares, opens, fetches from, and closes an implicit cursor.
With each iteration, the cursor FOR LOOP statement fetches a row from the result set into the record. When there are no more rows to fetch, the cursor FOR LOOP statement closes the cursor.
For each column value returned by the query associated with the cursor or cursor variable, there must be a corresponding, type-compatible field in the record.
B,D