Oracle - Functions Procedures Procedures and Cursors MCQ

Oracle – Functions Procedures Procedures and Cursors

1 / 27

1. What is the primary purpose of an Oracle stored function?

To return a single value

To create database tables

To print messages to the screen

To perform DML operations

2 / 27

2. In Oracle, which keyword is used to declare a procedure?

CREATE

PROCEDURE

DECLARE

FUNCTION

3 / 27

3. What is the primary difference between a stored function and a stored procedure in Oracle?

Functions can return values, while procedures cannot.

Functions can execute DML statements, while procedures cannot.

Procedures can be called from SQL statements, while functions cannot.

Procedures can have OUT parameters, while functions cannot.

4 / 27

4. Which of the following is true about cursors in Oracle?

Cursors are used to create tables.

Cursors are used to manage transactions.

Cursors are used to create functions.

Cursors are used to process query results one row at a time.

5 / 27

5. What is the purpose of the “RETURN” statement in a stored function in Oracle?

To specify the data type of the function's return value.

To exit the function immediately.

To declare a local variable.

To return a value to the caller.

6 / 27

6. Which of the following is an OUT parameter in Oracle procedures and functions?

A parameter that can only be used inside the procedure or function.

A parameter that must be passed when calling the procedure or function.

A parameter that can be used for input values only.

A parameter that is used to return a value to the caller.

7 / 27

7. In Oracle, what is the main purpose of a stored procedure?

To print messages to the screen.

To create database tables.

To return a single value.

To perform DML operations.

8 / 27

8. What is the purpose of the “IS NULL” condition in Oracle procedures and functions?

To assign a null value to a variable.

To check if a variable contains a null value.

To terminate the procedure or function.

To check if a table is empty.

9 / 27

9. Which Oracle statement is used to handle exceptions in a stored procedure or function?

TRY…CATCH

RAISE

EXCEPTION_INIT

EXCEPTION

10 / 27

10. What is the maximum number of parameters that can be passed to a procedure or function in Oracle?

There is no maximum limit.

100

11 / 27

11. Which statement is used to raise a user-defined exception in Oracle PL/SQL?

THROW_EXCEPTION

RAISE_USER

RAISE_CUSTOM

RAISE_APPLICATION_ERROR

12 / 27

12. What is the purpose of the “EXCEPTION_INIT” pragma in Oracle procedures and functions?

To define a custom exception message.

To specify the data type of an exception.

To initialize a user-defined exception.

To declare a local variable.

13 / 27

13. In Oracle, what is the main purpose of a stored function?

To return a single value.

To print messages to the screen.

To create database tables.

To perform DML operations.

14 / 27

14. What is an IN OUT parameter in Oracle procedures and functions?

A parameter that can be used for input and output values.

A parameter that can only be used inside the procedure or function.

A parameter that must be passed when calling the procedure or function.

A parameter that is used to return a value to the caller.

15 / 27

15. Which of the following is a valid way to call a stored procedure in Oracle?

BEGIN my_procedure;

CALL my_procedure();

EXEC my_procedure;

RUN my_procedure;

16 / 27

16. What is the purpose of the “EXCEPTION” section in Oracle procedures and functions?

To define custom exceptions.

To declare local variables.

To handle errors and exceptions.

To specify the data type of parameters.

17 / 27

17. What is the purpose of the “OUT” parameter in Oracle procedures and functions?

To return a value to the caller.

To assign a null value to a variable.

To exit the procedure or function immediately.

To check if a variable contains a null value.

18 / 27

18. In Oracle, which keyword is used to declare a cursor in a stored procedure or function?

CURSOR

FETCH

OPEN

DECLARE

19 / 27

19. What is the purpose of the “IS NOT NULL” condition in Oracle procedures and functions?

To check if a variable contains a null value.

To check if a table is not empty.

To assign a null value to a variable.

To terminate the procedure or function.

20 / 27

20. What happens when an unhandled exception occurs in an Oracle procedure or function?

The exception is automatically handled by the system.

An error message is displayed, and the program terminates abnormally.

The program crashes and terminates.

The program continues executing normally.

21 / 27

21. Which of the following is true about Oracle triggers?

Triggers can be defined to automatically perform actions in response to SQL statements.

Triggers are always executed before the triggering statement.

Triggers cannot be used to enforce data integrity constraints.

Triggers are only fired on DELETE operations.

22 / 27

22. What is the purpose of the “PRAGMA AUTONOMOUS_TRANSACTION” in Oracle procedures and functions?

To specify the data type of parameters.

To create an autonomous transaction within the procedure or function.

To declare a local variable.

To handle exceptions.

23 / 27

23. In Oracle, what is the primary use of a stored function?

To print messages to the screen.

To return a single value.

To create database tables.

To perform DML operations.

24 / 27

24. Which SQL statement is used to call a stored function in Oracle?

SELECT

FUNCTION

CALL

EXECUTE

25 / 27

25. What is the purpose of the “AUTHID DEFINER” clause in Oracle procedures and functions?

To declare local variables.

To specify the data type of parameters.

To specify whether the procedure runs with the privileges of the invoker or the definer.

To handle exceptions.

26 / 27

26. Which statement is used to raise a predefined exception in Oracle?

RAISE_USER

THROW_EXCEPTION

RAISE_APPLICATION_ERROR

RAISE_CUSTOM

27 / 27

27. What is the purpose of the “SAVEPOINT” statement in Oracle procedures and functions?

To specify the data type of an exception.

To declare a local variable.

To create a savepoint in a transaction.

To define a custom exception message.

Your score is

Oracle – Functions Procedures Procedures and Cursors MCQ