Correct Answer: The package specification is required, but the package body is optional
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
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?
In which type of trigger can the OLD and NEW qualifiers can be used?
Which of the following are identified by the 'INSTEAD OF' clause in a trigger?
What happens when rows are found using a FETCH statement?
An internal LOB is _____.
When the procedure or function is invoked, the Oracle engine loads the compiled procedure or function in the memory area called:
Which package construct must be declared and defined within the packages body?
Which of the following statements is true regarding stored procedures?
What type of trigger is created on the EMP table that monitors every row that is changed, and places this information into the AUDIT_TABLE?
Which table and column can be queried to see all procedures and functions that have been marked invalid?