Free Oracle Database Program with PL/SQLPractice Test

Which of the following is a valid PL/SQL block structure?

What is the maximum number of characters that can be stored in a VARCHAR2 variable in PL/SQL?

A developer writes the following code: DECLARE v_count NUMBER := 0; BEGIN v_count := v_count + 5; v_count := v_count * 2; END; What is the final value of v_count?

Which statement about the %TYPE attribute in PL/SQL is TRUE?

What happens when you use the NOCOPY hint with an OUT or IN OUT parameter in a PL/SQL procedure?

A developer needs to process all employees in the EMPLOYEES table with a salary greater than 5000. Which cursor declaration is correct?

What is the correct sequence of operations when working with an explicit cursor?

A procedure contains the following code: BEGIN UPDATE employees SET salary = salary * 1.1 WHERE employee_id = 999; IF SQL%NOTFOUND THEN RAISE_APPLICATION_ERROR(-20001, 'Employee not found'); END IF; END; What is the purpose of SQL%NOTFOUND in this code?

Which exception will be raised if a SELECT INTO statement returns more than one row?

A developer creates a cursor FOR loop. What is automatically handled by the FOR loop that would need to be done manually with explicit cursor operations?

What is the difference between a procedure and a function in PL/SQL?

Which keyword is used to specify that a procedure parameter should not be modified within the procedure?

A developer creates a package with the following specification: CREATE OR REPLACE PACKAGE emp_pkg IS g_bonus NUMBER := 1000; PROCEDURE calc_bonus(p_emp_id NUMBER); END emp_pkg; What is true about the variable g_bonus?

What happens when you try to call a procedure that is declared in a package specification but not defined in the package body?

A company needs to create a function that can be called from SQL statements. Which restriction must the function follow?

Which component of a package is optional?

What is the primary advantage of using forward declarations in a package body?

A database administrator needs to create a trigger that fires before INSERT or UPDATE on the EMPLOYEES table. Which trigger timing and type should be used?

In a row-level trigger on the EMPLOYEES table, what is the correct way to reference the new salary value being inserted or updated?

A developer writes a compound trigger on the ORDERS table. What is the main advantage of using a compound trigger instead of multiple separate triggers?

What happens if a BEFORE DELETE trigger raises an exception?

A developer needs to implement a solution where data from multiple tables can be modified through a single view. What type of trigger should be created?