Oracle - Oracle/PLSQL Functions MCQ

Oracle – Oracle/PLSQL Functions

1 / 25

1. What is the primary purpose of a PL/SQL function?

Execute stored procedures

Return a single value

Print output messages

Perform DML operations

2 / 25

2. Which keyword is used to define a PL/SQL function?

FUNCTION

PROCEDURE

VARIABLE

DECLARE

3 / 25

3. In PL/SQL, what type of values can a function return?

Single value

Conditional values

No values

Multiple values

4 / 25

4. What is the correct syntax for defining a PL/SQL function?

DECLARE function_name IS FUNCTION RETURN datatype

FUNCTION function_name datatype IS RETURN

FUNCTION function_name RETURN datatype IS

PROCEDURE function_name RETURN datatype IS

5 / 25

5. What is the purpose of the RETURN statement in a PL/SQL function?

To define parameters

To declare variables

To assign values

To return a result

6 / 25

6. In PL/SQL, can a function have input parameters?

Yes

Only if it's a procedure

No

Only if it's a trigger

7 / 25

7. Which data types are valid return types for PL/SQL functions?

All of the above

BOOLEAN, CLOB, BLOB

VARCHAR2, NUMBER, DATE

CURSOR, ROWID, BINARY_FLOAT

8 / 25

8. What keyword is used to declare input parameters in a PL/SQL function header?

OUT

IN

INOUT

PARAM

9 / 25

9. What happens when you call a PL/SQL function without assigning its result to a variable?

It executes a procedure

It enters an infinite loop

It raises an error

It returns NULL

10 / 25

10. In PL/SQL, what is the primary difference between a function and a procedure?

A function returns a value, while a procedure does not

They are identical in functionality

A procedure returns a value, while a function does not

A procedure can be called from a trigger

11 / 25

11. Which of the following is a valid way to call a PL/SQL function in SQL?

EXECUTE function_name;

CALL function_name();

RUN function_name();

SELECT function_name FROM dual;

12 / 25

12. In PL/SQL, can a function call another function?

No

Only if they have different names

Only if they are declared in separate schemas

Yes

13 / 25

13. What is the purpose of the DETERMINISTIC keyword in a PL/SQL function?

It specifies that the function returns a constant value

It defines the data type of the function

It ensures that the function has no side effects

It allows the function to accept multiple input parameters

14 / 25

14. Which keyword is used to define the data type of a function’s return value?

RESULT

VALUE

RETURNS

TYPE

15 / 25

15. What is the maximum number of parameters that a PL/SQL function can have?

10

There is no fixed limit

50

100

16 / 25

16. In PL/SQL, can a function modify the database?

Only if it's declared as READ ONLY

Only if it's declared as a trigger

Yes, by default

No, never

17 / 25

17. What is the primary use of the NOCOPY parameter mode in PL/SQL functions?

To force the function to return a constant value

To improve performance by avoiding unnecessary copying of data

To allow the function to modify the input parameters

To prevent the function from accepting any parameters

18 / 25

18. What is the purpose of the AGGREGATE keyword in PL/SQL functions?

It defines the function as an analytic function

It limits the number of input parameters

It indicates that the function has multiple return values

It specifies that the function performs aggregation operations

19 / 25

19. Which of the following is a built-in PL/SQL function used for string concatenation?

|| (Double pipe)

CONCATENATE

CONCAT

STRCAT

20 / 25

20. In PL/SQL, which function is used to find the square root of a number?

EXP

ROOT

POWER

SQRT

21 / 25

21. What is the purpose of the LEAST function in PL/SQL?

To find the lowest value among a set of values

To count the number of non-null values in a set

To find the highest value among a set of values

To calculate the average of a set of values

22 / 25

22. Which PL/SQL function is used to extract a substring from a string?

MID

SUBSTR

EXTRACT

SUBSTRING

23 / 25

23. In PL/SQL, what does the NVL function do?

Returns the absolute value of a number

Converts a value to uppercase

Returns NULL if the expression is NULL, otherwise returns the expression

Returns the current date and time

24 / 25

24. What is the primary purpose of the TO_DATE function in PL/SQL?

To extract the day of the week from a date

To calculate the difference between two dates

To convert a string to a date data type

To return the current date and time

25 / 25

25. Which PL/SQL function is used to round a numeric value to a specified number of decimal places?

ROUND

TRUNC

CEIL

FLOOR

Your score is

0%

Oracle – Oracle/PLSQL Functions MCQ