Oracle - Introduction to PL/SQL MCQ

Oracle – Introduction to PL/SQL

1 / 25

1. What does PL/SQL stand for in Oracle Database?

Procedural Logic/Structured Query Language

Programmatic Language for SQL

Procedural Language/Structured Query Language

Persistent Language for SQL

2 / 25

2. Which type of PL/SQL block is executed automatically when a triggering event occurs in the database?

Stored Procedure

Anonymous Block

Function

Trigger

3 / 25

3. What is the primary purpose of a PL/SQL cursor?

To fetch and process data

To declare variables

To handle exceptions

To define triggers

4 / 25

4. Which PL/SQL construct is used for error handling and exception propagation?

GOTO statement

LOOP construct

EXCEPTION block

CASE statement

5 / 25

5. Which data type is commonly used to store date and time values in PL/SQL?

VARCHAR2

NUMBER

BOOLEAN

DATE

6 / 25

6. What is the purpose of a PL/SQL package?

To group related procedures and functions

To define a user interface

To execute dynamic SQL

To create database triggers

7 / 25

7. Which PL/SQL construct is used for looping through a set of records returned by a SELECT statement?

CASE statement

IF statement

FOR loop

WHILE loop

8 / 25

8. In PL/SQL, what is the role of a stored procedure?

To declare exceptions

To perform a specific task

To define variables

To fetch data from tables

9 / 25

9. Which keyword is used to declare a PL/SQL variable?

BEGIN

VARIABLE

DECLARE

VAR

10 / 25

10. What is the purpose of the RAISE statement in PL/SQL?

To fetch data

To declare a variable

To handle exceptions

To define a cursor

11 / 25

11. Which type of PL/SQL block allows you to execute a set of SQL statements without a name?

Stored Procedure

Anonymous Block

Function

Package

12 / 25

12. What is the maximum number of exceptions that can be handled in a single EXCEPTION block in PL/SQL?

Unlimited

13 / 25

13. In PL/SQL, what is the purpose of a trigger?

To perform an action in response to a specific event

To execute dynamic SQL

To handle exceptions

To declare variables

14 / 25

14. Which PL/SQL construct is used to test multiple conditions and execute different code blocks based on the condition met?

IF statement

GOTO statement

CASE statement

EXCEPTION block

15 / 25

15. What is the primary use of dynamic SQL in PL/SQL?

To fetch and process data

To handle exceptions

To define triggers

To declare variables

16 / 25

16. Which data type is used to store true or false values in PL/SQL?

VARCHAR2

BOOLEAN

NUMBER

DATE

17 / 25

17. In PL/SQL, what is the purpose of the COMMIT statement?

To end a transaction and make changes permanent

To declare variables

To fetch data

To handle exceptions

18 / 25

18. Which PL/SQL construct is used to define and execute anonymous blocks of code?

Anonymous Block

Function

Procedure

Trigger

19 / 25

19. What is the purpose of the %TYPE attribute in PL/SQL variable declarations?

To declare a cursor

To specify the data type of the variable

To inherit the data type from a column

To fetch data from tables

20 / 25

20. What is the purpose of the SQL%ROWCOUNT attribute in PL/SQL?

To handle exceptions

To define triggers

To store the number of rows affected by SQL statements

To declare variables

21 / 25

21. Which PL/SQL construct is used to explicitly raise a user-defined exception?

CASE statement

GOTO statement

RAISE statement

DECLARE statement

22 / 25

22. What is the role of the INTO clause in a PL/SQL SELECT statement?

To specify the columns to be selected

To fetch data into variables

To specify the table to be updated

To declare a cursor

23 / 25

23. Which PL/SQL construct is used to iterate through elements of a collection?

IF statement

CASE statement

FOR loop

WHILE loop

24 / 25

24. In PL/SQL, what is the purpose of the ROLLBACK statement?

To undo changes made in a transaction

To declare variables

To fetch data

To handle exceptions

25 / 25

25. What is the primary advantage of using PL/SQL over SQL for database programming tasks?

PL/SQL is used only for data definition

PL/SQL provides procedural capabilities for complex tasks

PL/SQL is more efficient for data retrieval

PL/SQL is better for querying data

Your score is

Oracle – Introduction to PL/SQL MCQ