Correct Answer: Raise
Explanation:
Note: This Question is unanswered, help us to find answer for this one
Oracle PL/Sql 10g Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More Oracle PL/Sql 10g MCQ Questions
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?
A table has to be dropped from within a stored procedure. How can this be implemented?
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?
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?
Which procedure is called after a row has been fetched to transfer the value, from the select list of the cursor into a local variable?
CREATE OR REPLACE PACKAGE manage_emp IS tax_rate CONSTANT NUMBER(5,2) := .28; v_id NUMBER; PROCEDURE insert_emp (p_deptno NUMBER, p_sal NUMBER); PROCEDURE delete_emp; PROCEDURE update_emp; FUNCTION cal_tax (p_sal NUMBER) RETURN NUMBER; END manage_emp; / CREATE OR REPLACE PACKAGE BODY manage_emp IS PROCEDURE update_sal (p_raise_amt NUMBER) IS BEGIN UPDATE emp SET sal = (sal * p_raise_emt) + sal WHERE empno = v_id; END; PROCEDURE insert_emp (p_deptno NUMBER, p_sal NUMBER) IS BEGIN INSERT INTO emp(empno, deptno, sal) VALUES (v_id, p_depntno, p_sal); END insert_emp; PROCEDURE delete_emp IS BEGIN DELETE FROM emp WHERE empno = v_id; END delete_emp; PROCEDURE update_emp IS v_sal NUMBER(10,2); v_raise NUMBER(10, 2); BEGIN SELECT sal INTO v_sal FROM emp WHERE empno = v_id; IF v_sal < 500 THEN v_raise := .05; ELSIP v_sal < 1000 THEN v_raise := .07; ELSE v_raise := .04; END IF; update_sal(v_raise); END update_emp; FUNCTION cal_tax (p_sal NUMBER)RETURN NUMBER IS BEGIN RETURN p_sal * tax_rate; END cal_tax; END manage_emp; / What is the name of the private procedure in this package?
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?