Oracle APEX Interview Questions and Answers

Ques 1. What is Oracle Application Express?

Oracle Application Express (APEX) is a low-code development platform that enables you to build scalable, secure enterprise apps, with world-class features, that can be deployed anywhere.

Ques 2. How do you create a new application in Oracle Application Express?

You can create a new application in Oracle Application Express by going to the "Application Builder" section and clicking on the "Create" button.

Ques 3. Can you explain how to install Oracle Application Express(APEX) on an existing database?

There are two ways: On-Premise and Cloud.

On-Premise: The first thing you need to do is download the Oracle Application Express installer from the Oracle website. Once you have the installer, you will need to unzip it and then run the setup.exe file. After accepting the terms and conditions, you will need to choose the installation type. There are two options: using the Oracle Database Express Edition or using an existing Oracle database. If you choose to use an existing database, you will need to provide the hostname, port, and SID of the database. After the installation is complete, you will need to run the configuration script. This will create the necessary tables and users for Oracle Application Express.

Cloud: Open the existing autonomous database in Oracle Cloud Infrastructure. Open 'All Database Actions' where you can see the 'APEX' option. Click on 'APEX' where it will first ask to login as admin. Once you login, it will ask to create an workspace. Under that workspace, you can create users. Then logout from admin and login as developer user with the created workspace. Once you are logged-in, you can create applications.

Ques 4. Can you explain the difference between shared and local workspaces in Oracle Application Express?

Shared workspaces are those that are accessible to all users of the application, while local workspaces are only accessible to the user who created them. In a shared workspace, all users have the same privileges, while in a local workspace, the creator of the workspace has full control over who can access it and what they can do.

Ques 5. Can you give me some examples of real-world applications that use Oracle Application Express?

There are a number of real-world applications that use Oracle Application Express. Some examples include the United States Department of Veterans Affairs, NASA, and the National Weather Service and Oracle's own multiple products.

Ques 6. What are the main features offered by Oracle Application Express?

• Oracle Application Express (APEX) is a low-code development platform that enables you to build scalable, secure enterprise apps, with world-class features, that can be deployed anywhere.
• Oracle Apex is a powerful and user-friendly tool that allows developers to create web-based applications quickly and easily. Its integration with Oracle Database, built-in security features, and customizable themes make it a cost-effective and scalable option for businesses looking to create custom applications.
• Oracle APEX is designed to build web apps that are highly secure out of the box. In a world of constantly changing web standards and increasingly resourceful attackers finding new ways to hack sites, our focus on security means that your applications stay protected.
• APEX eliminates mapping between relational and application objects.
• APEX eliminates remote procedure call complexity.
• APEX eliminates proliferation of database connections.
• APEX eliminates middle-tier application logic.

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

No. It will work only with Oracle database.

Ques 8. 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, …. ).