Oracle - Procedures Functions and Parameters MCQ

Oracle – Procedures Functions and Parameters

1 / 25

1. What is the primary purpose of using procedures and functions in Oracle?

To modularize code

To insert data into tables

To define tables

To perform calculations

2 / 25

2. In Oracle PL/SQL, which modular code unit allows you to perform a specific task and does not return a value?

Package

Function

Trigger

Procedure

3 / 25

3. When calling a procedure in Oracle, which keyword is used to pass values to the procedure?

USING

IN

OUT

RETURN

4 / 25

4. In Oracle PL/SQL, what is the primary purpose of the procedure header?

To declare the procedure's parameters

To specify the procedure name

To write the procedure's executable code

To define the procedure's local variables

5 / 25

5. What statement is used to explicitly exit a procedure in Oracle PL/SQL?

GOTO

EXIT

RETURN

BREAK

6 / 25

6. In Oracle PL/SQL, which modular code unit is used when you want to return a single value?

Function

Package

Trigger

Procedure

7 / 25

7. What is the primary difference between procedures and functions in Oracle?

Functions are used for data manipulation, while procedures are used for control flow

Functions return a value, while procedures do not

Procedures can have parameters, while functions cannot

Procedures can be called from SQL statements, while functions cannot

8 / 25

8. In Oracle PL/SQL, which statement is used to explicitly exit a function and return a value?

BREAK

RETURN

EXIT

GOTO

9 / 25

9. What is the purpose of the RETURN datatype in Oracle functions?

It declares the function's local variables

It specifies the number of parameters a function can accept

It indicates the function's execution status

It defines the data type of the value returned by the function

10 / 25

10. In Oracle PL/SQL, what is the primary purpose of the function header?

To write the function's executable code

To declare the function's parameters

To define the function's local variables

To specify the function name

11 / 25

11. When calling a function in Oracle, which keyword is used to pass values into the function?

RETURN

OUT

IN

USING

12 / 25

12. In Oracle PL/SQL, which keyword is used to declare parameters that are used to pass values into and out of a subprogram?

PARAM

DECLARE

PARAMETER

IN

13 / 25

13. What is the primary purpose of the NOCOPY parameter mode qualifier in Oracle PL/SQL?

To enforce strict parameter typing

To prevent the copying of parameter values

To allow for dynamic parameter binding

To specify default parameter values

14 / 25

14. In Oracle PL/SQL, what are the primary parameter modes for formal parameters?

IN and OUT

INPUT and OUTPUT

BIND and RETURN

DEFAULT and OVERRIDE

15 / 25

15. In Oracle PL/SQL, what is the primary advantage of local modularization?

It enables code reuse

It improves code performance

It simplifies the code structure

It allows for better error handling

16 / 25

16. In Oracle PL/SQL, what is the scope of local modules defined within a larger program unit?

Module scope

Session scope

Local scope

Global scope

17 / 25

17. What is the primary benefit of using nested subprograms in Oracle PL/SQL?

Improved code readability

Enhanced code performance

Reduced code redundancy

Simplified error handling

18 / 25

18. In Oracle PL/SQL, what does subprogram overloading allow you to do?

Use dynamic parameters in subprograms

Assign different names to subprograms with the same functionality

Execute multiple subprograms simultaneously

Create subprograms with unlimited parameters

19 / 25

19. What is a restriction when overloading subprograms in Oracle PL/SQL?

Overloaded subprograms cannot return values

Overloaded subprograms cannot be used with SQL

Overloaded subprograms cannot have different parameter lists

All overloaded subprograms must have the same name

20 / 25

20. In Oracle PL/SQL, which statement is used to make a forward declaration of a subprogram before its actual definition?

FUNCTION

DECLARE

PACKAGE

FORWARD

21 / 25

21. In Oracle PL/SQL, what is the primary advantage of using table functions?

They allow for recursive subprograms

They simplify code structure

They improve code performance

They return a result set that can be queried

22 / 25

22. What is a deterministic function in Oracle PL/SQL?

A function that always returns the same output for the same input

A function that performs database operations

A function that returns a random value

A function that cannot have parameters

23 / 25

23. In Oracle PL/SQL, what is the primary purpose of implicit cursor results?

To define local variables

To fetch data from a cursor

To return query results from a function

To display error messages

24 / 25

24. When should you use the RETURNING clause in Oracle DML statements?

To specify the number of rows affected

To retrieve data modified by DML operations

To declare parameters

To return values from a function

25 / 25

25. What is the primary purpose of the SAVEPOINT statement in Oracle PL/SQL?

To execute DML statements

To commit changes to the database

To define local variables

To roll back transactions to a specific point

Your score is

0%

Oracle – Procedures Functions and Parameters MCQ