Fresh Oracle Application Developer Interview Questions & Answers:

1. Explain Can we give DML statements inside a function?

YES YOU CAN USE DML(SELECT) WITHIN User defined function(UDF). BUT KEEP IN MIND THAT UDF CAN ONLY RETURN ONE SINGLE VALUE. BUT YOU CANT USE DDL(CREATE/ALTER/DROP) WITHIN UDF. TO DO THAT YOU HAVE TO USE SP(Stored Procedure).

DML EXAMPLE:
CREATE OR REPLACE Function IncomeLevel
( name_in IN varchar2 )
RETURN varchar2
IS
monthly_value number(6);
ILevel varchar2(20);
cursor c1 is
select monthly_income
from employees
where name = name_in;
BEGIN
open c1;
fetch c1 into monthly_value;
close c1;
IF monthly_value <= 4000 THEN
ILevel := 'Low Income';
ELSIF monthly_value > 4000 and monthly_value <= 7000 THEN
ILevel := 'Avg Income';
ELSIF monthly_value > 7000 and monthly_value <= 15000 THEN
ILevel := 'Moderate Income';
ELSE
ILevel := 'High Income';
END IF;
RETURN ILevel;
END;

2. Suppose You need to save a certificate request in a file system directory by using Oracle Wallet
Manager. What would you do?
A. export the certificate request
B. use the File > Save As option
C. import the certificate request and save it
D. upload the certificate request to the Directory Service

A.export the certificate request

3. Suppose You execute the following command in your Oracle Application Server 10g installation
to start the Oracle Internet Directory (OID) Server Instance with a new instance ID:
$ oidctl connect=infra server=oidldapd instance=1 host=edtdr5p1.us.oracle.com start
The command does not error out. But while trying to locate the server instance using the
Process Status (ps) operating system utility, you realize that the instance has not started.
What could be the reason?
A. The OID Listener process has not started.
B. The OID server processes have not started.
C. The Oracle HTTP Server process has not started.
D. The Oracle Internet Directory (OID) Monitor process has not started.
E. The Oracle Enterprise Manager 10g Application Server Control page has not started.

D.The Oracle Internet Directory (OID) Monitor process has not started.

4. What is oracle application certification?

Oracle application certification is an Oracle certification exam

5. Suppose You require a certificate for your Web server. Which tool would you use to create a
certificate request?
A. OCA User pages
B. Oracle Wallet Manager
C. Application Server Control
D. Oracle Enterprise Security Manager

B.Oracle Wallet Manager

6. How to Use Delegated Administration Services (DAS), which task can you accomplish?
A. manage OracleAS Single Sign-On server
B. manage Oracle Internet Directory processes
C. register applications that are created using OracleAS Portal
D. manage user and group entries in Oracle Internet Directory (OID)
E. monitor system components in an Oracle Application Server 10g installation

D. manage user and group entries in Oracle Internet Directory (OID)

7. What is the format of oracle table?

create table <table_name>