Which datatype does the cursor attribute '%ISOPEN' return?

The CHECK_SAL procedure calls the UPD_SAL procedure. Both procedures are INVALID.Which command can be issued to recompile both procedures?

Which command is used to disable all triggers on the EMPLOYEES table?

Which two among the following programming constructs can be grouped within a package?

What is the maximum number of handlers processed before the PL/SQL block is exited, when an exception occurs?

All packages can be recompiled by using an Oracle utility called:

Examine the following code: CREATE OR REPLACE FUNCTION gen_email (first_name VARCHAR2, last_name VARCHAR2, id NUMBER) RETURN VARCHAR2 IS email_name VARCHAR2(19); BEGIN email_name := SUBSTR(first_name, 1, 1) || SUBSTR(last_name, 1, 7) ||[email protected] .; UPDATE employees SET email = email_name WHERE employee_id = id; RETURN email_name; END; Which of the following statements removes the function?

Examine the following trigger: CREATE OR REPLACE TRIGGER Emp_count AFTER DELETE ON Employee FOR EACH ROW DECLARE n INTEGER; BEGIN SELECT COUNT(*) INTO n FROM employee; DMBS_OUTPUT.PUT_LINE( 'There are now' || n || 'employees'); END; This trigger results in an error after this SQL statement is entered: DELETE FROM Employee WHERE Empno = 7499; How should the error be corrected?

Which of the following is not a legal declaration?

Which of the following statements do Expression Trees fit best?

Which of the following do the advantages of Lambda Expressions over Anonymous methods include?