Explore topic-wise MCQs in Technical MCQs.

This section includes 10 Mcqs, each offering curated multiple-choice questions to sharpen your Technical MCQs knowledge and support exam preparation. Choose a topic below to get started.

1.

A function is same as a procedure except that it returns a value.

A. TRUE
B. FALSE
C. Can be true or false
D. Can not say
E.
Answer» B. FALSE
Discussion
2.

We can demonstrate which of the following in a PL/SQL function?

A. Declare
B. Define
C. Invoke
D. All of the above
Answer» E.
Discussion
3.

PL/SQL function must contain a

A. Follow Statement
B. GOTO Statement
C. Return Statement
D. NULL Statement
Answer» D. NULL Statement
Discussion
4.

Which of the following is NOT present in the syntax of PL/SQL function?

A. Function_name
B. [OR REPLACE]
C. Optional Parameter List
D. None of the above
Answer» E.
Discussion
5.

_______ represents the value that will be passed from outside.

A. IN
B. OUT
C. IN OUT
D. All of the above
Answer» B. OUT
Discussion
6.

The optional parameter contains _______ parameters.

A. name
B. mode
C. types
D. All of the above
Answer» E.
Discussion
7.

The _____________ clause specifies the data type you are going to return from the function.

A. EXIT
B. CONTINUE
C. REPEAT
D. RETURN
Answer» E.
Discussion
8.

The _____ keyword is used instead of the _____ keyword for creating a standalone function.

A. AS, AS
B. IS, IS
C. AS, IS
D. IS, AS
Answer» D. IS, AS
Discussion
9.

The function must contain areturnstatement.

A. TRUE
B. FALSE
C. Can be true or false
D. Can not say
Answer» B. FALSE
Discussion
10.

A standalone function is created using the _________ statement.

A. ALTER FUNCTION
B. CREATE FUNCTION
C. REPEAT FUNCTION
D. INSERT FUNCTION
Answer» C. REPEAT FUNCTION
Discussion