OCP SQL & PL/SQL Programming

Question 1

What is the function of a cursor in PL/SQL?

Accepted Answer

It points to the data being queried

Answer

In PL/SQL, a cursor is a pointer or a handle to a private SQL area in memory where a SQL statement is processed. When a SQL query is executed, a cursor is implicitly or explicitly declared to manage the rows returned by the query. It allows the program to fetch and process these rows one by one, providing control over the result set.

Question 2

Which PL/SQL block is used to handle exceptions?

Accepted Answer

EXCEPTION

Answer

In PL/SQL, the `EXCEPTION` keyword introduces the exception handling section of a block. This section is where you define specific actions to be taken when a runtime error occurs within the `BEGIN-END` block. It allows for graceful error management, preventing the program from terminating abruptly and ensuring robust application behavior.

Question 3

Which SQL clause is used to filter results based on specific conditions?

Accepted Answer

WHERE

Answer

The `WHERE` clause in SQL is fundamental for filtering rows returned by a query. It evaluates a specified condition for each row in the table(s) and includes only those rows for which the condition is true. This allows users to retrieve a subset of data that meets specific criteria, making queries more precise.

Question 4

What is the purpose of a trigger in PL/SQL?

Accepted Answer

To automatically perform actions based on certain events

Answer

A trigger in PL/SQL is a stored program that automatically executes or 'fires' in response to specific database events. These events can include DML operations (INSERT, UPDATE, DELETE) on a table, DDL operations, or database system events. Triggers are used to enforce complex business rules, audit data changes, or maintain data integrity automatically.

Question 5

Which command is used to exit from SQL*Plus?

Accepted Answer

EXIT

Answer

The `EXIT` command is the standard and most direct way to terminate a SQL*Plus session. When executed, it closes the connection to the Oracle database and exits the SQL*Plus command-line interface. This returns control to the operating system, effectively ending the interactive session.

(OCP) Oracle Certified Professional Practice Test

(OCP) Oracle Certified Professional Practice Test

OCP SQL & PL/SQL Programming