Correct Answer: Private Procedure
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
When the procedure or function is invoked, the Oracle engine loads the compiled procedure or function in the memory area called:
Evaluate the following PL/SQL block: DECLARE v_low NUMBER:=2; v_upp NUMBER:=100; v_count NUMBER:=1; BEGIN FOR i IN v_low..v_low LOOP INSERT INTO test(results) VALUES (v_count) v_count:=v_count+1; END LOOP; END; How many times will the executable statements inside the FOR LOOP execute?
Which table should be queried to check the status of a function?
The technique employed by the Oracle engine to protect table data, when several people are accessing it is called:
Which two statements out of the following regarding packages are true?
Evaluate the following PL/SQL block: DECLARE result BOOLEAN; BEGIN DELETE FROM EMPloyee WHERE dept_id IN (10,40,50); result:=SQL%ISOPEN; COMMIT: END; What will be the value of RESULT if three rows are deleted?