Oracle APEX Interview Questions and Answers

Ques 21. Does APEX work with non-Oracle databases?

No. It will work only with Oracle database.

Ques 22. What are the skills required for APEX Developers?

SQL, PL/SQL is essential. HTML, CSS, and JavaScript are good to have skills to understand and customize look and feel (themes, templates, …. ).

Ques 23. How do I separate development from production environment?

• Depending on requirements for the availability of the application, the size of the user population, and other factors you can decide how to divide the development environment from the production environment.
• For certain applications, it is acceptable to combine the development server with the deployment server, as long as the end users understand that sometimes the application is not available.
• Other applications may require two (development and production) or even three (development, test, and production) servers.
• In Application Express applications can be moved from environment to environment using an export and import facility for application definitions.
• With one server available to run the database and Application Express, you can still separate the development version of an application from its production version by using two workspaces accessing separate schemas.
• In this case, one workspace will be used by developers and the other will be the workspace in which the application is deployed in production. We will add a few more Oracle Apex Interview Questions soon.