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
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.
Related Online Tests:
No comment yet. Be the first to post a comment.