PLSQL and Cursor Quiz

PL SQL Stands for

• Programming Language for SQL

• Procedural Language for SQL

• Plain Language for SQL

• None of these

Name 4 attributes of explicit cursors

• %FOUND,%NOTFOUND,%ROWCOUNT,%ISOPEN

• %FOUND,%NOTFOUND,%ISCLOSE,%ISOPEN

• %FOUND,%OPEN,%ROWCOUNT,%ISOPEN

• None of these

The name given for Implicit cursor is?

• PLSQL

• SQL

• CURSOR

• All the above

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;

• Correct

• Incorrect

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

• Trigger

• Cursor

• Select

• Procedure

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

• Internal

• External

• Implicit

• Explicit

_______ is used to recreate if trigger already exists

• Create

• Cursor

• Procedure

• Replace

What is wrong in the following code snippet?

DECLARE

x number := 1;

BEGIN

LOOP

dbms_output.put_line(x);

x := x + 1;

IF x > 10 THEN

exit;

END IF;

dbms_output.put_line('After Exit x is: ' || x);

END;

• Code is correct.

• IF statement is not required.

• END LOOP is missing.

• Every IF must have ELSE statement.

Consider the following code snippet: what will be the output?

DECLARE

a number(2) ;

BEGIN

FOR a IN REVERSE 10 .. 20 LOOP

END LOOP;

dbms_output.put_line(a);

END;

• 20

• 29

• 10

• 30

What will be the output of the following code snippet?

• 21

• 21, 10

• 10

• error