• phone icon +44 7459 302492 email message icon info@uplatz.com
  • Register

3.9 (84 reviews)
( 469 Students )
5 Hours


Oracle APEX

Learn about main components and key features that are essential when building any APEX application.
( add to cart )
Preview Oracle APEX course
View Course Curriculum   Price Match Guarantee   Full Lifetime Access     Access on any Device   Technical Support    Secure Checkout   Course Completion Certificate
Instant access

Students also bought -

Completed the course? Request here for Certificate. ALL COURSES

Oracle APEX (Oracle Application Express) is a fully supported, rapid web and mobile application development framework included with the Oracle database at no additional cost.

Using just a web browser, you can build powerful and professional looking web and mobile applications that are robust, scalable, and secure, all with little programming experience.

As a growing number of organizations discover how simple and easy it is to build highly functional web and mobile applications with this powerful tool, hence the popularity of APEX has shot up in the last few years.


Some key features of Oracle APEX are:

a) Free (with Oracle database)

b) Easy to get started (all you need is a web browser)

c) You don’t need to be a programmer

d) Yan can focus on your problem (security, user management, access control, pagination and navigation all taken care within the APEX tool automatically)

e) You’ll be really productive (numerous wizards, templates, and built-in user interface components, popular icon and JavaScript libraries already integrated)

f) Your applications will look great (highly-configurable universal theme, responsive design templates, grid-layout for forms, and the ability to configure or choose from a number of pre-defined style and display options)

g) Great community support


Uplatz offers this extensive Oracle APEX training program through self-paced online videos.

The Oracle Apex course is designed to give attendees the practical experience required to develop applications within Oracle Application Express. This Oracle Apex ourse covers all of the main components and key features that are essential when building any APEX application. This is achieved with practical scenarios supported by instructor explanations and examples.

Course/Topic - Oracle APEX - all lectures

  • This video entails the terms Oracle Application Express (APEX) which is an easy to use platform for developing data-centric web-based applications. 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.

    • 13:06
  • In the lecture you will learn about the App Builder which is a low code, high productivity integrated development environment where you can develop applications on top of your data.

    • 02:37
  • This video shows Oracle Forms and Reports, there are several options available to you to modernize the web stack. Some of these options, place a facade on Oracle Forms, requiring customers to pay ongoing support and maintenance fees for Oracle Forms and Reports as well as the Web logic licensing to support these technologies.

    • 10:41
  • In this video you will learn about build pages in the Page which is Designer by dragging components from the Components palette and positioning them on the canvas to create business objects, design forms and to organize page elements.

    • 17:08
  • In this tutorial you will see master detail form which reflects a one to many relationships between two tables in a database. Typically, a master detail form displays a master row and multiple detail rows. When you create a master detail form using the Create Page or Create Application Wizards, you choose the tables on which to build the master form and the detail form.

    • 10:11
  • In this video you will learn about Column attributes enable developers to control the display, features, and column behavior. Developers edit Column attributes to alter nearly all aspects of column behavior, including altering the layout and appearance, defining column links, creating column filters, and adding support for export and printing.

    • 02:49
  • In this tutorial you will learn about an interactive grid presents users which is a set of data in a searchable, customizable report. In an editable interactive grid, users can also add to, modify, and refresh the data set directly on the page and the interactive reports enable the user to customize the appearance of the data through searching, filtering, sorting, column selection, highlighting, and other data manipulations.

    • 10:53
  • In this tutorial we will see Oracle Application Express (APEX) has integrated charting which is based on Oracle JavaScript Extension Toolkit (JET) Data Visualizations. For more information on Oracle JET and the Data Visualizations components, please refer to the Oracle JET Get Started documentation and oj Chart API guide.

    • 02:13
  • This Video Covers Menu in Oracle Apps Menu which is nothing but a logical or hierarchical listing of functions (forms) so that the user can easily navigate through the forms once he is in a responsibility. Every responsibility will be assigned only one main menu. Under that main menu, you can have either have other sub menus or functions.

    • 08:18
  • In this tutorial you will cover APEX Tree region is intentionally very simple. It is just for display of a hierarchy with simple single selection or navigation. The tree View widget can do much more but the “documentation” is only in the source file. Also it can be difficult to change some settings because you don’t have direct access to how the widget is created

    • 05:57
  • This Tutorial Video teach you about Oracle provides a number of authentication and authorization which is a mechanisms to meet user requirements, from simple locally based password authentication to centralized directory service integration to handle both authentication and authorization.

    • 08:00
  • In this video you will learn about the page which is the basic building block of a database application. Individual pages are organized using containers called regions.

    • 01:32
  • In this session you will learn about the A template has what you need to get started with a site, including the site code framework, a default site with sample pages and content, a theme with styling, resources such as images, and even custom components. A theme defines the general look-and-feel the overall style of a site, including color scheme, font size, font type, and page backgrounds.

    • 04:28
  • In this Video you will learn about the Dynamic actions which provide a way to define complex client-side behavior declaratively without the need for JavaScript. Using the Dynamic Action Create wizard, you specify an action that is performed when a defined set of conditions occur. You can also specify which elements are affected by the action, and when and how they are affected.

    • 06:10
  • This Video Tutorial will teach you about the validation which is an edit check. Validations specific to a single item are page item validations. Validations that apply to an entire page are page validations. Validations for tabular forms specific to a single column are column level validations. Validations for tabular forms that do not apply to a single column are tabular form row validations.

    • 06:19
  • This session will teach you about the page process which performs an action at a specified point during the rendering or submission of the page. For example, you can create a page process to execute logic or to make a call to the Application Express engine. A page process is a unit of logic that runs when a specific event occurs, such as loading or submitting a page.

    • 01:59
  • This video will teach you about the how to create a Branch Process to open another page after submitting the current page. Because a Branch process executes on the page submit. Using the Branch Process in Oracle Apex, you can open a dialog page or a normal page

    • 01:28
  • This video will teach you about the Shared components which are common elements that can be display or be applied on any page within an application. You can use the tools and wizards on the Shared Components page either at the application-level or on specific pages.

    • 03:09
  • This video will teach you about the a list of values (LOV) which is a static or dynamic set of values used to display a specific type of page item, such as popup lists of values, a select list, a check box, a radio group, or multiple select lists.

    • 04:46
  • This tutorial will teach you about the use of Performance Management Architect to create Essbase (ASO) and Essbase (BSO) applications, providing reporting based on the dimensionality of Essbase as well as other applications, such as Planning or Profitability and Cost Management.

    • 01:28
  • This video will teach you about the Global Page which is a special page. Unlike all other pages it has no processes, validations or branches. It functions as a master page in that APEX renders all the components you add to this page onto every page within your application

    • 02:12
  • This tutorial will teach you about the export an application and which is related files, you must import them into the target Oracle Application Express instance and then install them.

    • 02:34
Objectives Back to Top

Learn how to use JavaScript in Oracle APEX

Learn the importance of using AJAX Callback

Opening Modal Dialog with dynamic data

Securing the Modal Dialog

Learn Dynamic Actions in detail

Practical Example of Framework and Component Events

Learn how to create a Custom Event

Using JavaScript as a Dynamic Action

Learn about Interactive Grid (IG) in detail

Customize Interactive Grid using JavaScript

Understanding APEX JavaScript APIs

Learn about jQuery Dialog


Syllabus Back to Top

Overall topics:

1. APEX Basics - Application, Pages and Regions

2. APEX Regions - Forms, Reports, Charts

3. User Interface, Templates and Themes

4. Creating Mobile Application

5. APEX Advanced - Security and Performance


Detailed-level course content:

1. Workspace

2. SQL Workshop

3. Application Builder

4. Form

5. Form with Report

6. Master-Detail Form

7. Classic Report

8. Interactive Report

9. Interactive Grid

10. Charts

11. Menus

12. Tree Region

13. Authentication

14. Authorization

15. Public Page

16. Templates

17. Theme

18. JavaScript in APEX

19. Dynamic Action

20. Validation

21. Computation

22. Page Process

23. Branches

24. Custom Process

25. Default Value

26. Shared Library

27. List of Values

28. Application Properties

29. Page Zero (Page0)

30. Performance

Certification Back to Top

This Oracle APEX training course will help the participant to master the Oracle certified Web Application developer. As a part of this Oracle apex training, the participants will master the application development framework.

In the Oracle Apex course, the participants will understand the low-code application development framework. In this Oracle Apex training, the participants will learn to create and deploy web applications that is compatible on mobile and desktop browsers.

Oracle Apex Certification is an important level in becoming a Web Application Developer. As a part of the Oracle Apex course training, the Oracle Web Application Developer get trained in each functionality to build an application. Oracle apex tutorial helps the participants to fulfil the role of a web application developer.

The Oracle Apex certification exam validates that the participants should prove their skills in developing applications using Oracle Apex. Oracle Certification exams verifies the participant understanding and skill set to create a professional application using Oracle Apex . The process of becoming Oracle certified Web Application Developer expands the participants knowledge and skills by getting exposed to Apex features.

Uplatz online training on Oracle APEX will help the participants to prepare for the Oracle Apex certification provided by Oracle. Uplatz provides appropriate teaching and expertise training is provided to equip the participants for implementing the learnt concepts in an enterprise.

Course Completion Certificate will be awarded by Uplatz upon the completion of the Oracle Apex course.

Below given are the Certification details of Oracle Application Express 18: Developing Web Applications

·       Certification Level: Associate

·       Exam Name: Oracle Application Express 18: Developing Web Applications

·       Exam Code: 1Z0-750

·       Exam Mode: Online

·       Total Number of Questions: 75

·       Pass Score: 56%

·       Time Duration: 120 Minutes

·       Exam Price: $330

Career & Jobs Back to Top

The Oracle Web Application Developers draw an average salary of $106,120 per year depending on the knowledge and hands-on experience. The Oracle Web Application Developer job roles are in high demand and make a rewarding career.

The Oracle Web Application Developers have major demand in global-based companies and MNCs. The adoption of the application development ideology in global companies can open up a job opportunity. The Global companies hire Oracle Web Application Developer considering the skill of building professional web applications. The Learners earn the Oracle Web Application Developer course completion certificate through our training and course structure.

The Oracle APEX Certification course is ideally designed for application developers who wants to become an Oracle certified Web Application Developers.

After pursuing Oracle APEX certification course the participants can pursue a wide range of career paths.

The following are the job titles in this area:

·       Web Developer

·       Application Developer

·       Web Developer Associate

·       Software Engineer

·       Oracle APEX Developer

·       Web & Apps Engineer 

Highly-skilled web developer professionals can build any type of applications using Oracle APEX. The Oracle Certified Web Application Developers are in high demand by organizations across the globe.

Interview Questions Back to Top

Q.1 What is Oracle Application Express?

Oracle Application Express (also called APEX and formerly called HTML DB) is a FREE RAD web development tool. APEX is written using PL/SQL and runs completely inside of a web browser. Apex is an IDE and a runtime environment. You use APEX to write web applications. Users, using their database user ID, log into APEX and run their application from a menu. With the APEX IDE, you can create forms, reports and charts. All of the normal web widgets are available: radio groups, buttons, drop down lists, date pickers, etc. You can even integrate your own JavaScript code should you need it. Output from APEX applications can be to the screen or to PDF, Excel spreadsheet, Flash, or even integrated into a web service.

You can use a supplied theme for a consistent look and feel or create your own theme for a personalized feel to your application. The most important thing to remember about Oracle Application Express is that it is designed from the ground up to be tightly integrated with the Oracle Database, to be a fully capable web development environment, and to be easy enough for savvy business users to create or extend applications for themselves.


Q.2 What are the uses of APEX?

1. Builds professional looking web applications that are both fast and secure.
2. Runs on and lives in Oracle database. APEX framework and meta data are stored in Oracle tables.
3. It is FREE. No licensing required.
4. Fast learning curve for developers to build application.
5. Deployment of application is as simple as ‘Export and Import’ if hard coded references of values that change between environments are avoided.
6. Lot of scope for customization of application look and feel.
7. Scalable for high user volume. ASKTOM, former ORACLE METALINK (before migrated to Flash version) and MANY APPLICATIONS are built using APEX.
8. Can be configured to use Oracle SSO and EBS fnd user repository.


Q.3 What kind of activities you have done for apex as apex dba?

1) setup of apex environment
2) SSL configuration
3) USER access
4) Security modal definition
5) ad hoc issue and resolution
6) Patching /Performance /


Q.4 How do you know what version apex is install in system

If dba view access then select comp name, version, status from dba_registry or schema user


Q.5 How does developer know in which version they are working

Need to check schema name   OR select version_no from apex_release;


Q.6 If you forget admin password ,how will you login to apex application.

We need to call sql scripts to reset the password  @apxchpwd.sql (this is same as alter user username identifies by password)


Q.7 By which user we connect to apex application.



Q.8 Who uses APEX?

If you are running on oracle database and you want to build rich web application with reports, forms, charts, drill downs and dashboards with limited Java experienced developers in a short time frame, Oracle APEX is the most likely candidate for consideration.


Q.9 How APEX Architecture works?

APEX is installed on Oracle database (above 9.2 version), starting from Oracle 11g it comes pre-installed with the database. It is comprised of meta data in tables, pl/sql code and extensive JavaScript APIs.
The URL request from the browser is translated into appropriate APEX PL/SQL call by either Oracle HTTP Server (Apache) with mod_plsql plugin or Embedded PL/SQL Gateway. This varies by the type of APEX installation on oracle database. After the data is processed, results are relayed back to browser as HTML. This cycle happens each time user request or submit a page. The application session state is maintained in database tables.
APEX installation can be done in two ways. DBAs are more concerned about it than developers. But this determines how the URL is translated.


Q.10 Does APEX works with non-Oracle databases?



Q.11 What are skills required for APEX Developers?

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


Q.12 What are the different type of apex users

Users are divided into three primary roles developer, Workspace administrators and Instance administrators


Q.13 Some views of apex

apex_workspaces,apex_workspace_activitiy_log etc.


Q.14 How will you validate apex
Utlrp.sql  or
SQL> exec validate_apex; (If your APEX version is 2.0 or above)
SQL> exec validate_htmldb; (If your APEX version is prior to 2.0


Q.15 Which user in apex own sso module.



Q.16 Which scripts need for registration process for SSO?



Q.17 How will you enable SSO for apex application?

Login to APEX_030200


Q.18 How will you direct your application to use https instead of http?

Create wallet from apache home (wallet should be in ready state)
configure ssl.conf file
restart apache
verify with opmnctl status -l


Q.19  I have installed Oracle 11g Enterprise Database with a view to use the embedded APEX but dont know how to launch it.

Oracle apex by default while installation of oracle DB .But you need to configure access mechanism to launch APEX application.
1) Apache (Web Server)
2) Embedded PL/SQL gateway
3) Oracle Listner


Q.20 How does APEX integrate with the database?

Oracle Application Express is truly a database application. The IDE, the menus, and all of the screens you see in APEX are written in PL/SQL. The meta data for all of those screens, reports, and menus are stored in relational tables within the database. When you point your browser at the APEX URL, the Oracle HTTP listener (Apache +mod_plsql or the PL/SQL gateway, depending on database version) receives that call and uses PL/SQL and the meta data stored in database tables to paint the welcome screen. When you log into APEX you are using an actual database user ID. This user ID is associated with a role (or roles) within the database and these roles determine what access you will have. If you are an administrator, you have access to create users and workspaces. As a developer, you have access to create new applications. If you are configured as an end-user, you will be able to run one or more applications. Oracle Application Express is integrated with the Oracle Database as no environment is. If you need to extend the basic functionality of APEX, there is no need to learn additional languages or link in additional libraries. On the rare occasions you need to extend functionality, you’ll either use SQL for data access or PL/SQL when procedural code is required.


Q.21 How is APEX a RAD Tool?

Because APEX is so tightly integrated to the database, you can prototype screens while sitting with the user. The Object Browser allows you to create database objects such as tables in addition to viewing those same objects. This allows you to create objects on the fly and then build tables around those objects. The IDE, including the above Table builder, and all applications are run within a browser. Turn-around time is immediate. Because APEX is declarative, you can easily make changes in real-time via the built-in wizards. Because APEX controls session information for you, and because you use the security framework built into the Oracle Database, you can concentration delivering applications, not on connection configuration and other typical web development time wasters.


Q.22 How much does APEX Cost and where can I get it?

APEX comes pre-installed and completely integrated with Oracle Database Express Edition(XE). For all other editions of Oracle Database, Oracle Application Express comes as a free add-on that can be downloaded and installed. If you chose to “try before you buy”, or since it’s free, “try before you install”, you can also use the hosted APEX Online facility. This facility allows you to create and run complete applications just as you would on your own equipment.


Q.23 What is the current version of APEX and why should I upgrade?

Beta version APEX 4.2 is released a couple of weeks back. This new version offers many enhancements. Among the most useful are:
Print to PDF
– Users can chose to export their reports and screens to PDF output.
Migrate from MS-Access
– Using an export tool and the Access Migration Workbench, you can migrate user applications to APEX.
Calendar Widget
– Older versions included a calendar widget but now users can choose between day, week, or month calendars.
Improved Page and Region Caches
– Caching improves performance.
Application Builder Defaults
– The developer can set defaults for wizards to reduce development time (basically themes for development).The benefits of upgrading include performance enhancements and additional usability features for both the developer and the end user.
Oracle Database 10g Express Edition only supports Oracle APEX version 2.2.


Q.24 What applications come with APEX?

The current version of APEX allows you to download pre-packaged applications for you to learn from and/or modify for your own uses. You can currently download (form Oracle’s Technology site):
1. Employee Directory Lookup – This is exactly what it sounds like.
2. Ask The Expert – Q&A Site ala “asktom”.
3. Bug Tracker – Log and track bug reports.
4. Discussion Forum – Threaded chat, user management, and more.
5. Document Library – Multi-user document repository (Word, Excel, etc).
6. Project Issue Tracker – Define, assign, and report project issues.
7. Online Store – Catalog and shopping cart.
8. Software Projects – Project task tracker.
You are by no means limited to this list of projects. An Internet search for
“oracle APEX projects”
Gets almost 500,000 hits and more are being posted all the time.


Q.25 Where can I try APEX?

As mentioned above, you can sign up for a free account at APEX.ORACLE.COM (Oracle’s hosted Application Express site). When you sign up for an account, you identify the work area name that you want to use and identify an administrator. From there you can create applications and users just as you would on your own hardware and systems.apex.oracle.com is not intended for production systems, it is intended for exploration and testing. For additional hosting companies, check out the Oracle. These sites offer varying levels of hosting including free developer access and full application deployment.


Q.26 What kind of support exists for APEX?

Application Express has a robust community to help you develop, deliver, and use APEX applications. The first stop for support would be the APEX Forum sat Oracle Technology Network. This active forum provides tips and answers from many experts both inside and outside of Oracle.
Other sites include:
THE APEX WIKI – Wikipedia for the APEX crowd.
APEX STUDIO – Community created applications available for download.
APEX MAILING LIST – Sign up for info and Q&A.
THE ORACLE APEX COMMUNITY LISTING The list is growing daily.


Q.27 Where can I get more information?

In addition to the OTN forums and community sites, Application Express has a huge following in the blogosphere. Many expert level resources maintain blogs about APEX. Some particularly well known blogs are:
SCOTT SPENDOLINI– APEX Guru and owner of Sumner Technologies (an APEX Training, Services, and Consulting company).
PATRICK WOLF– Inside Oracle APEX, Patrick is along-time Oracle veteran.
DIMITRI GELLIS – Another long-time Oracle vetand co-founder of APEX Evangelists, an APEX specific company, with John Scott.
JOHN SCOTT– As mentioned above, co-founder of APEX Evangelists, an Oracle ACE, and Application Express Developer of the Year for2006.
You can find all of these and more at the OTN COMMUNITY SITE.


Q.28 What is the future of Application Express?

Oracle has made a large commitment to Application Express. In a fairly short time, APEX has made it to version 3.0. Every release makes it easier to use and deploy applications. While recent releases have improved APEX integration with SOA, APEX does not try to compete with jDeveloper or the Oracle Java stack. APEX is the glue that can combine various parts of an enterprise solution into a whole. APEX is the tool of choice to create web-based, database-centric applications. If your business logic is in the database tier, APEX is the way to go. If your logic is in the middle tier or is implemented at the java level, J2EE may be the better choice. APEX take-up has doubled in the past year and thousands of developers are using APEX. Numbers like these ensure a healthy future for APEX. A recent INFOWORLD ARTICLE contains the following:
“We’re going to take out the need to understand the database,” said Mike Hichwa, vice president of software development at Oracle, talking about Application Express 3.1, which is likely to appear before year-end. The next release of the tool will retain its core functionality but will also be more wizard-driven so it’s easier for nonprogrammers to use, he added.
Application Express enables Oracle database users, including those with limited technical skills, to create and manage secure Web applications using only a Web browser. The tool can be used to prototype Web-based applications as well as run those applications supporting tens to thousands of users.
Currently, Oracle estimates that around 100,000 developers are using Application Express on a monthly basis, but the company would like to open up the tool to many more users, Hichwa said. Oracle’s particularly interested in those people who are currently using Microsoft Corp.’s Access database or its Excel spreadsheet or IBM Corp.’s Lotus Notes groupware to develop Web- based applications.


Q.29 Are there any limitations in using Oracle XE?

XE is free but Oracle has built certain limitations into the product.
The first limitation is memory. Oracle Database XE can address only 1GB of RAM. This limitation mainly affects how many users can access the database concurrently and how well it performs.
The second limit is that XE will only use one CPU. XE will run on a multi -CPU computer but wont scale up to use those CPUs. This functionality requires Oracle Database Standard Edition or Enterprise Edition.
The third limit is that only a single XE database can run on any given computer. You do not need a database for each application. Instead, Oracle uses the concept of schemas to separate applications.
Finally, a 4GB limit is enforced on disk space. 4GB is a huge amount of storage for most applications. You can also use APEX to link to other databases (on other servers) for more storage as needed.


Q.30 How do I backup and restore an Oracle XE Database?

Backing up and restoring Oracle Database XE is based on protecting the physical files that make up the
There are 6 files in C:oraclexeoradataXE: CONTROL.DBF, SYSAUX.DBF, SYSTEM.DBF, TEMP.DBF, UNDO.DBF and USER.DBF.
The control file SPFILE is in C: oraclexe app oracle product 10.2.0 server dbs.
If in ARCHIVELOG mode, the redo log files should be backed up. Two redo log files are in
C: oraclexe app oracle Vlash_recovery_areaVE ONLINELOG.
Cold back up is when you stop the database and zip up all those 9 files (in NOARCHIVEMOD). When you restore the database copy all 9 files back to the same folders.
If the application is in ARCHIVEMOD and should run 24X7 then use hot backup.


Q.31 How to make applications portable?

To ensure application can easily be moved from one Application Express environment to another you should avoid hard coded references to values that may change between environments.
For example, the application ID is often referenced in URLs throughout an application. The Application Express engine uses the application ID to uniquely identify the application fetched and run from the application repository. Rather than using the actual application ID as is done in the URL below:
It is recommended to use an indirect reference instead:
Here, &APP_ID. is a built in substitution string that replaces the hard coded value 100. Using this technique, no modifications have to be made prior to deployment, even if the application ID changes.
Similarly, to ensure smooth deployment, references to images in templates, HTML regions or SQL queries should use substitution strings instead of hard coded paths.
Consider, for example, an application whose images are stored on the file system in the virtual path /dev/images/ in a development environment and /prod/images/ on the production server.
Use substitution strings at the application level to avoid having to make changes throughout the application before deployment. E.g., define substitution string IMAGE_PATH, and give it a value of /dev/images/


Q.32 Should static files be placed in the database?

Application Express applications may reference additional external files such as cascading style sheets (CSS), images and Javascript libraries.
These images can either be placed on the file system of the server that runs the web server or, when they are uploaded using Application Express’s application builder, can be stored inside the database.
A benefit of managing files such as images and CSS in the database with the application builder is that they can be exported and imported into another Application Express environment or workspace using only a browser.
However, storing related files in the database is recommended only when you have relatively few images and when the application is not expected to endure high request throughput.
When images, CSS and Javascript libraries are stored in the database, a database connection is established each time the browser requests one of these files.
In a high throughput application this may result in undue and unwanted strain on the database.


Q.33  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 few more Oracle Apex Interview Questions soon.


Q.34 Which platforms are supported by Oracle Application Express?

Oracle Apex works on the following operating systems:
1. Linux x86
2. Mac OS X Server
3. Linux on Power
4. Linux x86-64
5. z/Linux
6. Linux Itanium
7. Solaris x86
8. Solaris Operating System (SPARC) (64 bit)
9. Microsoft Windows (32 -bit)
10. Microsoft Windows (64 -bit Itanium)
11. Microsoft Windows (x64)
12. AIX5L
14.HP Tru64 UNIX (Compaq / DEC)
15. HP-UX Itanium

Q1. What are the payment options?
A1. We have multiple payment options: 1) Book your course on our webiste by clicking on Buy this course button on top right of this course page 2) Pay via Invoice using any credit or debit card 3) Pay to our UK or India bank account 4) If your HR or employer is making the payment, then we can send them an invoice to pay.

Q2. Will I get certificate?
A2. Yes, you will receive course completion certificate from Uplatz confirming that you have completed this course with Uplatz. Once you complete your learning please submit this for to request for your certificate https://training.uplatz.com/certificate-request.php

Q3. How long is the course access?
A3. All our video courses comes with lifetime access. Once you purchase a video course with Uplatz you have lifetime access to the course i.e. forever. You can access your course any time via our website and/or mobile app and learn at your own convenience.

Q4. Are the videos downloadable?
A4. Video courses cannot be downloaded, but you have lifetime access to any video course you purchase on our website. You will be able to play the videos on our our website and mobile app.

Q5. Do you take exam? Do I need to pass exam? How to book exam?
A5. We do not take exam as part of the our training programs whether it is video course or live online class. These courses are professional courses and are offered to upskill and move on in the career ladder. However if there is an associated exam to the subject you are learning with us then you need to contact the relevant examination authority for booking your exam.

Q6. Can I get study material with the course?
A6. The study material might or might not be available for this course. Please note that though we strive to provide you the best materials but we cannot guarantee the exact study material that is mentioned anywhere within the lecture videos. Please submit study material request using the form https://training.uplatz.com/study-material-request.php

Q7. What is your refund policy?
A7. Please refer to our Refund policy mentioned on our website, here is the link to Uplatz refund policy https://training.uplatz.com/refund-and-cancellation-policy.php

Q8. Do you provide any discounts?
A8. We run promotions and discounts from time to time, we suggest you to register on our website so you can receive our emails related to promotions and offers.

Q9. What are overview courses?
A9. Overview courses are 1-2 hours short to help you decide if you want to go for the full course on that particular subject. Uplatz overview courses are either free or minimally charged such as GBP 1 / USD 2 / EUR 2 / INR 100

Q10. What are individual courses?
A10. Individual courses are simply our video courses available on Uplatz website and app across more than 300 technologies. Each course varies in duration from 5 hours uptop 150 hours. Check all our courses here https://training.uplatz.com/online-it-courses.php?search=individual

Q11. What are bundle courses?
A11. Bundle courses offered by Uplatz are combo of 2 or more video courses. We have Bundle up the similar technologies together in Bundles so offer you better value in pricing and give you an enhaced learning experience. Check all Bundle courses here https://training.uplatz.com/online-it-courses.php?search=bundle

Q12. What are Career Path programs?
A12. Career Path programs are our comprehensive learning package of video course. These are combined in a way by keeping in mind the career you would like to aim after doing career path program. Career path programs ranges from 100 hours to 600 hours and covers wide variety of courses for you to become an expert on those technologies. Check all Career Path Programs here https://training.uplatz.com/online-it-courses.php?career_path_courses=done

Q13. What are Learning Path programs?
A13. Learning Path programs are dedicated courses designed by SAP professionals to start and enhance their career in an SAP domain. It covers from basic to advance level of all courses across each business function. These programs are available across SAP finance, SAP Logistics, SAP HR, SAP succcessfactors, SAP Technical, SAP Sales, SAP S/4HANA and many more Check all Learning path here https://training.uplatz.com/online-it-courses.php?learning_path_courses=done

Q14. What are Premium Career tracks?
A14. Premium Career tracks are programs consisting of video courses that lead to skills required by C-suite executives such as CEO, CTO, CFO, and so on. These programs will help you gain knowledge and acumen to become a senior management executive.

Q15. How unlimited subscription works?
A15. Uplatz offers 2 types of unlimited subscription, Monthly and Yearly. Our monthly subscription give you unlimited access to our more than 300 video courses with 6000 hours of learning content. The plan renews each month. Minimum committment is for 1 year, you can cancel anytime after 1 year of enrolment. Our yearly subscription gives you unlimited access to our more than 300 video courses with 6000 hours of learning content. The plan renews every year. Minimum committment is for 1 year, you can cancel the plan anytime after 1 year. Check our monthly and yearly subscription here https://training.uplatz.com/online-it-courses.php?search=subscription

Q16. Do you provide software access with video course?
A16. Software access can be purchased seperately at an additional cost. The cost varies from course to course but is generally in between GBP 20 to GBP 40 per month.

Q17. Does your course guarantee a job?
A17. Our course is designed to provide you with a solid foundation in the subject and equip you with valuable skills. While the course is a significant step toward your career goals, its important to note that the job market can vary, and some positions might require additional certifications or experience. Remember that the job landscape is constantly evolving. We encourage you to continue learning and stay updated on industry trends even after completing the course. Many successful professionals combine formal education with ongoing self-improvement to excel in their careers. We are here to support you in your journey!

Q18. Do you provide placement services?
A18. While our course is designed to provide you with a comprehensive understanding of the subject, we currently do not offer placement services as part of the course package. Our main focus is on delivering high-quality education and equipping you with essential skills in this field. However, we understand that finding job opportunities is a crucial aspect of your career journey. We recommend exploring various avenues to enhance your job search:
a) Career Counseling: Seek guidance from career counselors who can provide personalized advice and help you tailor your job search strategy.
b) Networking: Attend industry events, workshops, and conferences to build connections with professionals in your field. Networking can often lead to job referrals and valuable insights.
c) Online Professional Network: Leverage platforms like LinkedIn, a reputable online professional network, to explore job opportunities that resonate with your skills and interests.
d) Online Job Platforms: Investigate prominent online job platforms in your region and submit applications for suitable positions considering both your prior experience and the newly acquired knowledge. e.g in UK the major job platforms are Reed, Indeed, CV library, Total Jobs, Linkedin.
While we may not offer placement services, we are here to support you in other ways. If you have any questions about the industry, job search strategies, or interview preparation, please dont hesitate to reach out. Remember that taking an active role in your job search process can lead to valuable experiences and opportunities.