Oracle Application Express 5: Developing Web Applications — Question 26

Robin develops many apps in his workspace that use various APEX plug-ins. Some apps use the same plug-in as other apps. When a newer version of a plug-in is available, Robin has to update the plug-in in multiple apps.
How can Robin upgrade a plug-in once and have all other apps that use the same plug-in get updated at the same time?

Answer options

• A. Run a SQL command to update the plug-in definition in each application.
• B. Write a PL/SQL package that he can reuse to update the plug-in definitions in each application.
• C. Update one of the plug-ins, and then click Push Update to update the other apps.
• D. Create a "Plug-ins Master" app where he stores all plug-ins and then subscribes the plug-ins in all of his other apps to the plug-ins in the "Plug-ins Master" app.

Correct answer: B

Explanation

The correct answer is B because creating a reusable PL/SQL package allows Robin to programmatically update the plug-in definitions in all applications, ensuring consistency and efficiency. Options A and C require manual updates for each application, which is not efficient, and option D, while creative, does not guarantee simultaneous updates across all applications.