PLSQL and Cursor Quiz

PL SQL Stands for

Name 4 attributes of explicit cursors

The name given for Implicit cursor is?

Is the Syntax right using the EMP Table in the DECLARE block

DECLARE

CURSOR C1(DNO OUT EMP.DEPTNO%TYPE) IS SELECT * FROM EMP

WHERE DEPTNO=DNO FOR UPDATE NOWAIT 5;

________ provide a way for your program to select multiple rows of data from the database and then process each row individually.

_____cursor is declared by ORACLE for each UPDATE, DELETE and INSERT SQL commands.

_______ is used to recreate if trigger already exists

What will be the output of the following code snippet?