What actions can be performed on an explicit cursor? Give an example of each statement’s use.

What will be an ideal response?

Declare – CURSOR department_cursor IS SELECT * FROM dept;
Open – OPEN department_cursor;
Fetch data – FETCH department_cursor INTO dept_rec;
Close – CLOSE department_cursor;