callicon +1 210-504-8191
whatsAppIcon +1 210-504-8191
emailIcon info@koenig-solutions.com
koenig-logo
logo-30-years
Login
koenig-logo
+1 210-504-8191
+1 210-504-8191

Oracle Database 12c R2: Program with PL/SQL Ed 2 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.