• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

Oracle Apex Interview Questions

Oracle Apex Interview Questions

What is Application Express?

It is formerly called HTML-DB, a web-based RAD tool which resides in Oracle database. Using browser based user interface and limited programming experience, you can build a complete data-centric web application in a very fast development cycle.

From the end user’s perspective, the deployed applications require only a browser and access to an Oracle database running Application Express.

What are the uses of APEX?

-Builds professional looking web applications that are both fast and secure.

-Runs on and lives in Oracle database. APEX framework and meta data are stored in Oracle tables.

-It is FREE. No licensing required.

-Fast learning curve for developers to build application.

-Deployment of application is as simple as ‘Export and Import’ if hard coded references of values that change between environments are avoided.

-Lot of scope for customization of application look and feel.

-Scalable for high user volume. AskTom, former Oracle Metalink (before migrated to Flash version) and many applications are built using APEX.

-Can be configured to use Oracle SSO and EBS fnd user repository.

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.

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.

Oracle HTTP Server: In this three-tier configuration, mod_plsql in Oracle HTTP Server acts a broker between client web browser and server database.

For each URL that is processed, mod_plsql either uses a database session from its connection pool, or creates a new session on the fly and pools it. For mod_plsql to invoke the appropriate database PL/SQL procedure in a URL-processing session, you must first configure a virtual path and associate that path with a Database Access Descriptor (DAD).

A DAD is a named set of configuration values that specify the information necessary to create a session for a specific database and a specific database user/password. This includes the database service name and the Globalization Support setting (for example, language) for the session.

Embedded PL/SQL Gateway: This is a classic client-server architecture where embedded PL/SQL gateway provides the Oracle database with a Web server and also the necessary infrastructure to create dynamic applications. The embedded PL/SQL gateway runs in the XML DB HTTP server in the Oracle database and includes the core features of mod_plsql, but does not require the Oracle HTTP Server powered by Apache.

Oracle HTTP Server is known and proven technology, it has been used for Self Service applications.

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

-setup of apex environment .

-SSL configuration .

-USER access .

-security modal definition .

-ad hoc issue and resolution

– patching /Performance /

Inclined to build a profession as Oracle Apex Developer? Then here is the blog post on
 Oracle Apex Training Program.

Define application top?

Application tops are found when we are connecting to server.

There are two types of application tops available they are product top and custom top.

-Product top is the kind of top that is built in default by manufacturer.

-Custom top can be chosen by the client, and any number of custom tops can be created as per the requirement of the client.

Which platforms are supported by Oracle Application Express?

Oracle Apex works on the following operating systems:

-Linux x86

-Mac OS X Server

-Linux on Power

-Linux x86-64

-z/Linux

-Linux Itanium

-Solaris x86

-Solaris Operating System (SPARC) (64 bit)

-Microsoft Windows (32 -bit)

-Microsoft Windows (64 -bit Itanium)

-Microsoft Windows (x64)

-AIX5L

-HP-UX PA -RISC

-HP Tru64 UNIX (Compaq / DEC)

-HP-UX Itanium

Does APEX works with non-Oracle databases?

No.

What is current version available?

APEX 4.2 is released a couple of weeks back.

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

Where to learn and get hands on APEX?

There are multitude of sites dedicated to APEX. apex.oracle.com allows anyone to request for  free APEX account to build applications or run packaged applications.

Follow the below steps for creating account in apex.oracle.com

-Go to apex.oracle.com and click ‘sign up for account’ link below Login button.

-Fill administrator information. This user will have all rights to create new users and manage their accounts.

-Enter workspace name (For Ex: XX-APEX). Workspace is dedicated area where you develop applications. A workspace is attached to one or more database schemas. In a typical development environment, you might create a single workspace for all your developers to share.

-Enter name of database schema and its space allocation.

-Fill justification and complete by confirming the request.

-You will get email once the request is approved. Oracle administrator do great job to approve your request as soon as they can. (Usually few hours … latest a day).

-After clicking on approval link, you get another email with userid/password.

-Then you are set on login on apex.oracle.com  and run sample application under Application Builder.

What is the menu?

Menu can be defined as a hierarchical arrangement associated with functions of the system.

What is Function?

Function is the smaller part of the application and that is defined inside menu.

Define SQL Loader ?

Sql loader is a utility resembling a bulk loader for the purpose of moving data that are present in external files towards the oracle database.

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

How to register concurrent program with oracle apps?

There are certain steps that you need to follow for the purpose of registering concurrent program.

The first step is to log in to your system with the responsibility of the system administrator.

The next step is to define executable concurrent program.

While defining concurrent program do take care to give application name, short name and description along with the selection of executable concurrent program.

Define the Types of validation?

There are various kinds of validation.

-None: this is the indication of minimal validation.

-Independent: Input should be there in the list of – values that are defined previously.

-Dependent: According to the previous value, input is compared with a subset of values.

-Table: Input is checked on the basis of values that exist in the application table.

-Special: These are the values that make use of flex field.

-Pair: A pair can be defined as the set of values that make use of flex fields.

-Translated Independent: This is a kind of value that can be made used only if there is any existence for the input in the list that is -defined previously.

-Translatable dependent: In this kind of validation rules that compare the input with the subset of values associated with the previously defined list.

 Learn more about Oracle Apex Tutorials in this blog post.

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.

Which are the attachments that are platform independent and become a part of the template?

There are several attachments that are part of the template form.

APPSCORE:  This is a kind of attachment that comprises of packages as well as procedures which are useful for all the different forms for the purpose of creating toolbars, menus etc.

APPSDAYPK: This attachment contains packages that are helpful in controlling the applications associated with oracle.

FNDSQF: This attachment has various procedures as well as packages for flex fields, profiles, message dictionary and also concurrent processing.

CUSTOM: This attachment is helpful in extending the application forms of oracle without causing any modification related with the application code. There are various kinds of customization including zoom.

Which are the types of Triggers?

There are various kinds of triggers associated with forms and they are

-Key triggers

-Error triggers

-Message triggers

-Navigational triggers

-Query – based triggers

-Transactional triggers

How will you enable SSO for apex application ?

Login to APEX_030200

What are the different type of apex users?

Users are divided into three types

-primary roles developer ,

-Workspace administrators

-Instance administrators

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

What is current version available?

beta version APEX 4.2

Name the file where we configure oracle connection ?

dad.conf (database access descriptor (DAD))

How will you enable SSO for apex application ?

Login to APEX_030200

@loadsdk.sql;

@regapp.sql;

By which user we connect to apex application?

apex_public_user

Which tool you use for publishing reports ?

BI publisher

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

-setup of apex environment .

-SSL configuration

-USER access

-security modal definition

-ad hoc issue and resolution

-patching /Performance /

Which scripts  need for registration process for SSO?

regapps.sql

What is the purpose of cursors in PL/SQL?

The cursor can be made used for the purpose of handling various row – query associated with PL/SQL. Implicit cursors are available for the purpose of handling all the queries related with oracle. The memory spaces that are unnamed are used by oracle for storing the data that can be used with implicit cursors.

Summary
Review Date
Reviewed Item
Useful,Oracle Apex Interview Questions
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Oracle Apex Interview Questions"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.