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 code is stored in the database when a procedure or function is created in SQL*PLUS?

What can be done with the DBMS_LOB package?

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?

Examine the following code: CREATE OR REPLACE PACKAGE comm_package IS g_comm NUMBER := 10; PROCEDURE reset_comm(p_comm IN NUMBER); END comm_package; User MILLER executes the following code at 9:01am: EXECUTE comm_package.g_comm := 15 User Smith executes the following code at 9:05am: EXECUTE comm_package.g_comm := 20 Which of the following statement is true?

The oracle server implicitly opens a cursor to process:

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

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

Which of the following statements is true?

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

Which of the following is a benefit of using procedures and functions?