PL/SQL Procedure MCQs

by karimhani25
111
8

pl/sql

questions

Title
PL/SQL Procedure consists of – PL/SQL Procedure consists of – Header and Footer Body and Footer Header and Body None of the above discuss The answer is: C. Header and Body
What is TRUE about header? What is TRUE about header? Parameters and variables are contained in the header of the procedure. Similar to a general PL/SQL block, the header contains declarations, executions, and exceptions. Both A. and B. None of the above discuss The answer is: A. Parameters and variables are contained in the header of the procedure.
How much number of ways is there to pass the parameters in procedure? How much number of ways is there to pass the parameters in procedure? 1 2 3 4 discuss The answer is: C. 3
Which of the following are the pass parameters in procedure? Which of the following are the pass parameters in procedure? IN OUT INOUT All of the above discuss The answer is: D. All of the above
Which of the following pass parameters can be referenced by procedure? Which of the following pass parameters can be referenced by procedure? IN, OUT OUT, INOUT IN, INOUT None of the above discuss The answer is: C. IN, INOUT
Which of the following cannot be overwritten by procedure? Which of the following cannot be overwritten by procedure? IN OUT INOUT None of the above discuss The answer is: A. IN
Which of the following can be performed in PL/SQL Procedure? Which of the following can be performed in PL/SQL Procedure? Create Call Drop All of the above discuss The answer is: D. All of the above
In the contexts created by Oracle, a cursor represents a ____ In the contexts created by Oracle, a cursor represents a ____. Function Table Pointer None of the above discuss The answer is: C. Pointer

total MCQs: 8

MCQs

8

Views

111

Best Answers

299

Points

5