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 test.now 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.......



Legend

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