Oracle APEX Interview Questions and Answers

Ques 16. What are the different types of reports available in Oracle Application Express?

There are four different types of reports available in Oracle Application Express: Classic Reports, Interactive Reports, Matrix Reports, and Pivot Grid Reports.

Ques 17. What is a break field in context of reporting in Oracle Application Express?

A break field is a field that is used to break up data in a report. For example, if you have a report that contains data for multiple years, you could use a break field to break up the data by year. This would allow you to easily see the data for each year separately.

Ques 18. 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

Ques 19. Who uses APEX?

If you are running on an oracle database and you want to build rich web applications 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.

Ques 20. How does APEX Architecture work?

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 metadata 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 the oracle database. After the data is processed, results are relayed back to the browser as HTML. This cycle happens each time a user requests or submits 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.