Interacting With Database - Online Test

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






Comments

No comment yet. Be the first to post a comment.