Oracle - Creating and Running PL/SQL Code MCQ

Oracle – Creating and Running PL/SQL Code

1 / 25

1. What is the primary purpose of PL/SQL in Oracle Database?

Procedural programming

Data retrieval

Data modeling

Data storage

2 / 25

2. Which type of PL/SQL block is executed directly from a SQL*Plus prompt or within an application program?

Stored Procedure

Anonymous Block

Trigger

Function

3 / 25

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

Functions return values; procedures do not.

Procedures can have parameters; functions cannot.

Procedures return values; functions do not.

Functions can have parameters; procedures cannot.

4 / 25

4. What are PL/SQL blocks composed of?

Variables and loops

Declarations, executable statements, and exception handlers

Procedures and functions

Data types and triggers

5 / 25

5. Which Oracle tool provides an integrated development environment (IDE) for PL/SQL development?

SQL*Plus

Oracle SQL Developer

SQL Server Management Studio

TOAD

6 / 25

6. What is the primary role of exception handling in PL/SQL?

Error management

Data storage

Data modeling

Data retrieval

7 / 25

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

Unlimited

8 / 25

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

GOTO statement

CASE statement

IF statement

EXCEPTION block

9 / 25

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

To declare variables

To define triggers

To fetch and process data

To handle exceptions

10 / 25

10. In PL/SQL, what is the primary use of dynamic SQL?

To define triggers

To fetch and process data

To declare variables

To handle exceptions

11 / 25

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

DECLARE statement

RAISE statement

GOTO statement

CASE statement

12 / 25

12. 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 is better for querying data

PL/SQL is more efficient for data retrieval

PL/SQL provides procedural capabilities for complex tasks

13 / 25

13. What does the COMMIT statement do in PL/SQL?

Ends a transaction and makes changes permanent

Declares variables

Fetches data

Handles exceptions

14 / 25

14. In PL/SQL, what is the purpose of the INTO clause in a SELECT statement?

Specifies the columns to be selected

Fetches data into variables

Specifies the table to be updated

Declares a cursor

15 / 25

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

VARCHAR2

NUMBER

BOOLEAN

DATE

16 / 25

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

WHILE loop

CASE statement

FOR loop

IF statement

17 / 25

17. What is the role of the %TYPE attribute in PL/SQL variable declarations?

Declares a cursor

Inherits the data type from a column

Specifies the data type of the variable

Fetches data from tables

18 / 25

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

Trigger

Procedure

Function

Anonymous Block

19 / 25

19. Which PL/SQL construct is used to undo changes made in a transaction?

FETCH statement

CASE statement

DECLARE statement

ROLLBACK statement

20 / 25

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

Stores the number of rows affected by SQL statements

Declares variables

Handles exceptions

Defines triggers

21 / 25

21. How can you call a PL/SQL function from a SQL statement in Oracle?

Using the EXECUTE statement

Using the RUN statement

Using the SELECT statement

Using the CALL statement

22 / 25

22. Which PL/SQL construct is used to perform a specific task and can have input and output parameters?

Anonymous Block

Procedure

Function

Trigger

23 / 25

23. In PL/SQL, what is the purpose of the SAVEPOINT statement?

To save the current date and time

To define a cursor

To save a specific record

To set a point in a transaction for later rollback

24 / 25

24. Which Oracle tool is commonly used for debugging PL/SQL code?

SQL Server Management Studio

SQL*Plus

TOAD

Oracle SQL Developer

25 / 25

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

Simplicity

Performance and scalability

Data modeling

Portability

Your score is

Oracle – Creating and Running PL/SQL Code MCQ