When does the compiler implicitly convert the data type of the actual parameter to the data type of the formal parameter?
When does the compiler implicitly convert the data type of the actual parameter to the data type of the formal parameter?
Where are functions normally used?
Where are functions normally used?
What does an unhandled exception do?
What does an unhandled exception do?
Which of the following subprogram is stored in the database?
Which of the following subprogram is stored in the database?
Where can a subprogram be created?
Where can a subprogram be created?
Which of the following differentiates a declaration part of a subprogram from an anonymous block?
Which of the following differentiates a declaration part of a subprogram from an anonymous block?
What happens if a subprogram which has OUT and IN OUT formal parameter exits with an unhandled exception?
What happens if a subprogram which has OUT and IN OUT formal parameter exits with an unhandled exception?
When should forward declaration be used in procedures?
When should forward declaration be used in procedures?
What does PL/SQL do with an unhandled exception?
What does PL/SQL do with an unhandled exception?
What happens when we specify parameters using named notations in wrong order?
What happens when we specify parameters using named notations in wrong order?
What happens when the data type of the actual parameter is not the same as the data type of the formal parameter?
What happens when the data type of the actual parameter is not the same as the data type of the formal parameter?
Which of the following is incorrect about functions?
Which of the following is incorrect about functions?
Which of the following is incorrect about actual parameters in a procedure?
Which of the following is incorrect about actual parameters in a procedure?
What should be done to change the definition of an existing function?
What should be done to change the definition of an existing function?
Which of the following is not a subprogram?
Which of the following is not a subprogram?
Which of the following is incorrect about a RETURN statement?
Which of the following is incorrect about a RETURN statement?
What does a return statement in a function do?
What does a return statement in a function do?
What is an unhandled exception?
What is an unhandled exception?
Which of the following subprograms can use parameters?
Which of the following subprograms can use parameters?
Which part of a subprogram heading is optional?
Which part of a subprogram heading is optional?