NEW
Font size
WorksheetsPLSQL and Cursor Quiz
Total questions: 10
Worksheet time: 5mins
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
