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:

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?

In Pl/Sql, if the where clause evaluates to a set of data, which lock is used?