Home / Interview Questions / Apps DBA Interview Questions / Apps DBA Interview Questions Part 1

Apps DBA Interview Questions Part 1

Briefly Describe the architecture of Oracle Applications?

Oracle Applications follow a Three tier architecture:

  • Database Tier containing the RDBMS database.
  • Middle-Tier containing various servers like Forms Server, Web Server, Concurrent Processing Server, Admin Server, Reports Server.
  • Desktop Tier, the client desktop, through which users access Oracle Applications.
Does a Tier mean a Physical Machine in Oracle Applications?

No, a Tier does not mean a physical machine. It is basically a logical portioning.

Each tier has more than one physical server and each physical server can accommodate more than one different tier.

For example: The middle-tier can be configured in 4-5 different servers and any server can be used for hosting database as well as Web server.

How is the three-tier architecture different from client server architecture model and which is a better model?

In a client-server architecture, you need to install the application software in all the client’s machines. If you are using 50 computers as clients, you need to install the application software in 50 computers, whereas, The three-tier architecture eliminates this issue.

The application software is hosted centrally in the Middle Tier and there is no need to install it in all the client’s machine.

If I am not installing the client software in the desktop PC, then how will I access Oracle Applications?

The client desktop accesses Oracle Applications through JAVA-enabled web browser with JInitiator or JRE and forms client applet.

What is forms client applet?

For running forms from the client computer, the forms client applet must run in the client desktop. It supports all Oracle Application forms including the custom forms.

How many Homes are there in Oracle Applications?

Oracle applications have three Oracle Homes:

  1. Database Oracle Home in the database tier that acts as the Oracle Home for the Oracle database.
  2. Oracle Home in the application tier. It is called the technology stack Oracle Home and used by forms, reports.
  3. IAS Oracle Home, used by the Oracle HTTP server. It is used by the Web listener.
What does the application tier consist of?

The Application Tier is the place where the application software is located. It also hosts a large number of servers which interact with the database and the client tier. The application tier architecture shifts software administration from the desktop to the middle tier removing the burden of installing the application software at every client.

Which servers are hosted from the application tier?

The following servers constitute the application tier:

  • Oracle HTTP server (Apache)
  • Forms server
  • Reports server
  • Admin Server
  • Concurrent Processing Server
What is HTTP Server?

Oracle HTTP Server is the Web Server which is used by Oracle Applications. It Processes all the requests received from the clients.


What is the difference between Apache and Oracle HTTP Server?

Oracle HTTP server is the customized form of the Apache. Oracle has customized the Apache Web server as per there requirements which is known as Oracle HTTP Server.

What is Admin Server?

The Admin Server is that node of the APPL_TOP from which all maintenance activities for Oracle Applications are performed.

What kind of activities can be performed by admin server?
  • Applying the patches
  • Maintaining Oracle Applications
  • Applying the ad utilities
  • Upgrading Oracle Applications
What is Concurrent Processing Server?

When an Oracle Application user submits a request to run a program, it is called Concurrent Requests.

Concurrent Managers are the programs responsible for running the concurrent requests. Concurrent requests are processed from Concurrent Processing Server.

What is Forms Server?

Form server is that server from which the forms are hosted. It’s a component of Middle Tier. The Forms user interface is used in the desktop clients for working in Oracle Applications.

What is reports server?

Report server is also a component of the middle tier and is hosted in the same node of the concurrent processing server.

What are the tables which store the Information about the various application users and their passwords?

FND_USERS and FND_ORACLE_USERID stores the information about the applications users and their passwords.

Name adadmin utilities and Its location?

Location of Adadmin utilities is $AD_TOP/bin.

Below are the name of Adadmin utilities provided by Oracle Applications.

  1. adadmin
  2. adpatch
  3. adsplice
  4. adident
  5. adrelink
  6. adlicmgr
What is the Diff between APPS Schema and other Schemas?

APPS schema contains only Synonyms. We can’t create tables in apps schema, where as other schema contains tables, and all the objects. Here only we will create the tables and giving grants on created tables. Almost every time we connect to APPS schema only.

Difference between Application Developer and System Administrator?

Role of Technical Consultant:

1.Designing New Forms, Programs and Reports
2. Forms and Reports customization
3. Developing Interfaces
4. Developing PL/SQL stored procedures
5. Workflow Automations

Role of System Administrator:

1. Define Logon Users
2. Define New/Custom Responsibility
3. Define Data Groups
4. Define Concurrent Managers
5. Define Printers
6. Test Network Preferences
7. Define/Add new Modules

Role of an Apps DBA:

1.Installation of Application
2. Up-Gradation
3. Migration
4. Patches
5. Routing maintenance of Application
6. Cloning of Oracle Applications

About Syed Saad Ali

As a certified and experienced Oracle Database Administrator with Almost 10 Years of Experience I am able to perform all levels of database maintenance and am fully qualified to do Oracle updates as well. Capitalizing on my interest in Business & IT both, I chose to navigate my career towards Enterprise Solutions, which has enabled me to excel in the combination of both. I have developed exceptional analytical skills that allow me to diagnose and take care of issues immediately. Extremely skilled in planning and execution of special projects in time- critical environments. Extensive knowledge in directing, coordinating and exercising concern authority for planning, organization, control and successful completions. Very skilled at solving customer relations issues by seeking first to understand and then to be understood. Effectively able to communicate with customers, vendors and management.

Check Also

Apps Technical Interview Questions Part 5

Leave a Reply