Test Difficulty Level: Easy

Syllabus of Test

Accessing the Database - Queries, Other DML Statements, Transaction Control Statements. Explicit Cursors - Using Cursors, Cursors with Parameters, Cursor FOR Loops, Subqueries in a Cursor, Updating and Deleting in a Cursor.

Sample Question from this online test:

Question: What is wrong with the following cursor declaration ?

CURSOR c1 (pempno IN NUMBER (4)) IS
SELECT EMPNO, ENAME
FROM EMP
WHERE EMPNO = pempno;

Option A: The INTO clause is missing.

Option B: Inside the cursor definition, the variable should be preceded with a colon (:pempno).

Option C: IN cannot be specified in the cursor definition.

Option D: The size of the datatype should not be specified in the cursor definition.

To answer, click the "Start This Test" button below.

Start this Test