Which precomplied word is called, which when encountered, immediately binds the numbered exception handler to a name?

Examine the following code: CREATE OR REPLACE TRIGGER update_emp AFTER UPDATE ON emp BEGIN INSERT INTO audit_table (who, dated) VALUES (USER, SYSDATE); END; / An UPDATE command is issued in the EMP table that results in changing 10 rows How many rows are inserted into the AUDIT_TABLE ?

If user defined error condition exists, Which of the following statements made a call to that exception?

Which table should be queried to determine when the procedure was last compiled?

Examine the following procedure: PROCEDURE emp_salary (v_bonus BOOLEAN, V_raise BOOLEAN, V_issue_check in out BOOEAN) is BEGIN v_issue_check:=v_bonus or v_raise; END; If v_bonus=TRUE and v_raise=NULL,which value is assigned to v_issue_check?

A table has to be dropped from within a stored procedure. How can this be implemented?

Which part of a database trigger determines the number of times the trigger body executes?

Examine the following package specification: CREATE OR REPLACE PACKAGE combine_all IS v_string VARCHAR2(100); PROCEDURE combine (p_num_val NUMBER); PROCEDURE combine (p_date_val DATE); PROCEDURE combine (p_char_val VARCHAR2, p_num_val NUMBER); END combine_all; / Which overloaded COMBINE procedure declaration can be added to this package specification?

What happens during the execute phase with dynamic SQL for INSERT, UPDATE, and DELETE operations?

Which cursor dynamically allows passing values to a cursor while opening another cursor?

Which procedure is called after a row has been fetched to transfer the value, from the select list of the cursor into a local variable?