How can migration be done from a LONG to a LOB data type for a column?

Which of the following statements is true?

Which Section deals with handling of errors that arise during execution of the data manipulation statements, which makeup the PL/SQL Block?

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 ?

Examine the following code: CREATE OR REPLACE TRIGGER UPD_SALARY FOR EACH ROW BEGIN UPDATE TEAM SET SALARY=SALARY+:NEW.SALARY WHERE ID=:NEW.TEAM_ID END; Which statement must be added to make this trigger executable after updating the SALARY column of the PLAYER table?

What can be done with the DBMS_LOB package?

Which code is stored in the database when a procedure or function is created in SQL*PLUS?

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?