Home »
MCQs »
Oracle MCQs
Oracle Procedure MCQs
Oracle Procedure MCQs: This section contains multiple-choice questions and answers on procedure in Oracle.
Submitted by Anushree Goswami, on June 13, 2022
1. There are PL/SQL statements within a ____ that can be referred to by name.
- Statement
- Query
- Procedure
- None
Answer: C) Procedure
Explanation:
There are PL/SQL statements within a procedure that can be referred to by name.
Discuss this Question
2. Call specifications specify java methods or third-generation language routines that can be called from ____.
- SQL
- PL/SQL
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
Call specifications specify java methods or third-generation language routines that can be called from SQL and SPL/SQL.
Discuss this Question
3. How many types of procedure are there?
- 1
- 2
- 3
- 4
Answer: C) 3
Explanation:
There are 3 types of procedure.
Discuss this Question
4. Which of the following is/are the type of procedure?
- IN
- OUT
- IN OUT
- All of the above
Answer: D) All of the above
Explanation:
The types of procedure are -
- IN
- OUT
- IN OUT
Discuss this Question
5. The value of ____ is passed to the subprogram as a default parameter.
- IN
- OUT
- IN OUT
- None
Answer: A) IN
Explanation:
The value of IN is passed to the subprogram as a default parameter.
Discuss this Question
6. A value is returned to the caller when ____ is specified.
- IN
- OUT
- IN OUT
- None
Answer: B) OUT
Explanation:
A value is returned to the caller when OUT is specified.
Discuss this Question
7. A subprogram receives an initial value from ____ and a value that has been updated from the caller.
- IN IN
- OUT OUT
- IN OUT
- None
Answer: C) IN OUT
Explanation:
A subprogram receives an initial value from IN OUT and a value that has been updated from the caller.
Discuss this Question
8. What is the syntax to Drop Procedure?
- DELETE PROCEDURE procedure_name;
- DROP PROCEDURE procedure_name;
- RETRIEVE PROCEDURE procedure_name;
- END PROCEDURE procedure_name;
Answer: B) DROP PROCEDURE procedure_name;
Explanation:
The syntax to Drop Procedure is DROP PROCEDURE procedure_name;.
Discuss this Question
9. Which of the following is not present in the syntax of Create Procedure?
- IS
- BEGIN
- END
- None
Answer: D) None
Explanation:
IS, BEGIN and END are all present in the syntax of Create Procedure.
Discuss this Question
10. Which of the following is present in Call Procedure?
- BEGIN
- END
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
BEGIN and END are both present in the Call Procedure.
Discuss this Question