This discussion is archived
1 Reply Latest reply: Jun 12, 2013 6:35 AM by Marwim RSS

Need help to clarify PL/SQL concepts

Abbas85 Explorer
Currently Being Moderated

Hi All,


I have given a test for certification of PL/SQL but I have failed in that....

I have copy all questions from that I want know correct answers to prepare for next test..  


Following are the some questions and remaining question I will ask in replies..


1-which statement about formal parameters is true ?


  a-You can assign a default value to an OUT formal parameter.

  b- The OUT or IN formal parameter defines the value used in the executable section of a pl/sql block.

  c-You cannot assign a value to an IN formal parameters inside the procedure in which it is being used.

  d-An IN OUT formal parameters does not require a value before returning to the calling environment.

Kindly tell me the correct answer with brief description.



Thanks in Advance.......


  • Correct Answers - 10 points
  • Helpful Answers - 5 points