emailIcon info@koenig-solutions.com
koenig-logo
Login
whatsAppIcon
phoneIcon
koenig-logo
All Courses

11g: Program with PL/SQL Quiz Questions and Answers

Answer :
  • %FOUND

Explanation :

The %FOUND is a cursor attribute. The return value will be TRUE if the DML statements have an affect on atleast one row and the SELECT...INTO statement also returns atleast one row. The return value will be FALSE if the DML statements do not affect any row and the SELECT...INTO statement does not return any row.
Answer :
  • Using the IN mode

Explanation :

IN parameter is which helps us to pass a value to the subprogram. This parameter is a read-only parameter and it acts like a constant in a subprogram. No value can be assigned to it.
Answer :
  • TRUE

Explanation :

An exception handling block is used so that we can avoid the errors in the program. The exception message consists of 1. Type of exception 2. An error code 3. A message
Answer :
  • Associative arrays

Explanation :

The associative arrays helps us to look up to the elements using arbitary numbers and strings for subscript values. They are similar to hash tables.
Answer :
  • In and out

Explanation :

Create procedure dept count proc(in dept name varchar(20), out d count integer). Here in and out refers to input and result of procedure.
Answer :
  • No

Explanation :

he above statement is false. The correct statement is: The CLOSE statement disables the cursor, and the result set becomes undefined.
Answer :
  • If boolean expression then statement or compound statement elseif boolean expression then statement or compound statement else statement or compound statement end if

Explanation :

The conditional statements supported by SQL include if-then-else statements by using this syntax. elif and elsif are not allowed.
Answer :
  • OPEN-FOR

Explanation :

The query associated with a cursor variable executes using the OPEN-FOR statement. It helps in identifying the result set.