When referencing a package procedure or function from

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: anges and the package specification does not change, the stand-alone procedure referencing a package construct becomes invalid D. When referencing a package procedure or function from a stand-alone procedure or function, If the package specification changes, the stand-alone procedure referencing a package construct as well as the package body become invalid Answer: B, D Explanation: B. One of the advantages with packages is the improved handling of dependencies. The package structure separates the program unit code (body) from the program unit header (specification). If modifications are made to the code in the package body and the package specification remains unchanged, the status of dependent objects are not changed to INVALID, as is the case with stand-alone program units. D. If you change the package specification any objects including stand-alone procedures or functions that reference the package are invalidated. When you change the Package specification the status of the package body is set to invalid. Incorrect Answers A. When you change the package specification the package body becomes invalid and the stand-alone procedures become invalid. C. If modifications are made to the code in the package body and the package specification remains unchanged, the status of dependent objects are not changed to INVALID. QUESTION 107: You need to create a trigger to ensure that information in the EMP table is only modified during business hours, Monday to Friday from 9:00am to 500pm Which types of trigger do you create? (Choose two.) A. row level AFTER INSERT OR UPDATE OR DELETE ON EMP B. row level BEFORE INSERT OR UPDATE OR DELETE ON EMP C. statement level AFTER INSERT OR UPDATE OR DELETE ON EMP D. statement level BEFORE INSERT OR UPDATE OR DELETE ON EMP Actualtests.com - The Power of Knowing 1Z0-147 Answer: B, D Explanation: B. You would want to create a trigger that fires BEFORE the DML Statement. A row level BEFORE INSERT OR UPDATE OR DELETE ON EMP trigger would satisfy the requirement....
View Full Document

Ask a homework question - tutors are online