Exploring PL/SQL Fundamentals

What is the primary purpose of PL/SQL?

• To create graphical user interfaces for databases.

• The primary purpose of PL/SQL is to provide a procedural extension to SQL for managing and manipulating data in Oracle databases.

• To serve as a data visualization tool.

• To perform data analysis using machine learning algorithms.

Describe the block structure in PL/SQL.

• PL/SQL block structure consists of Variables, Functions, and Procedures sections.

• PL/SQL block structure includes only the Execution section.

• PL/SQL block structure consists of Declaration, Execution, and Exception Handling sections.

• PL/SQL block structure is limited to a single section without Exception Handling.

What are bind variables and how are they used?

• Bind variables are used to store static values in SQL statements.

• Bind variables are placeholders in SQL statements used for dynamic value substitution, improving performance and security.

• Bind variables are only applicable in NoSQL databases.

• Bind variables are used to create new database tables.

Explain the difference between implicit and explicit cursors.

• Explicit cursors are automatically created by the database.

• Implicit cursors can only be used in stored procedures.

• Implicit cursors are automatically managed by the database, while explicit cursors are defined and controlled by the programmer.

• Implicit cursors require manual management by the programmer.

What is a cursor FOR loop in PL/SQL?

• A cursor FOR loop is used to create database tables in PL/SQL.

• A cursor FOR loop in PL/SQL is a control structure that iterates over the result set of a query, automatically handling the opening, fetching, and closing of the cursor.

• A cursor FOR loop is a method to execute stored procedures in PL/SQL.

• A cursor FOR loop is a way to define triggers in PL/SQL.

How do you handle exceptions in PL/SQL?

• Use the EXCEPTION block to handle exceptions in PL/SQL.

• Use the TRY block to handle exceptions in PL/SQL.

• Ignore exceptions and continue execution.

• Log exceptions to a file without handling them.

What are the types of data types available in PL/SQL?

• Integer types

• Boolean types

• Scalar types, Composite types, Reference types, LOB types

• String types

What is the significance of the WHERE CURRENT OF clause?

• The WHERE CURRENT OF clause retrieves all rows from a table.

• The WHERE CURRENT OF clause is only applicable in stored procedures.

• The WHERE CURRENT OF clause is used to define a new cursor.

• The WHERE CURRENT OF clause allows for updates or deletes on the current row of a cursor.

Define transaction control statements in PL/SQL.

• Transaction control statements in PL/SQL include COMMIT, ROLLBACK, and SAVEPOINT.

• INSERT, UPDATE, DELETE

• BEGIN, END, EXECUTE

• SELECT, FROM, WHERE

How do you perform data manipulation using SQL in PL/SQL?

• Data manipulation is not possible in PL/SQL.

• Use only SELECT statements for data manipulation.

• Use PL/SQL functions exclusively for data retrieval.

• Use SQL statements like INSERT, UPDATE, DELETE in PL/SQL blocks for data manipulation.