Which two statements among the following, regarding oracle database 10g PL/SQL support for LOB migration, are true?

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?

Examine the following code: CREATE OR REPLACE TRIGGER secure_emp BEFORE LOGON ON employees BEGIN IF (TO_CHAR(SYSDATE, 'DY') IN ('SAT', 'SUN')) OR (TO_CHAR(SYSDATE, 'HH24:MI') NOT BETWEEN '08:00' AND '18:00') THEN RAISE_APPLICATION_ERROR (-20500, 'You may insert into the EMPLOYEES table only during business hours.'); END IF; END; / What type of trigger is it?

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?