Oracle Application Developer

  Home  Certifications  Oracle Application Developer


“Oracle Application Developer Certification Frequently Asked Questions in various Oracle Application Developer Exam Interviews asked by the interviewer. So learn Oracle Application Developer Certification with the help of this Oracle Application Developer Exam Interview questions and answers guide and feel free to comment as your suggestions, questions and answers on any Oracle Application Developer Exam Interview Question or answer by the comment feature available on the page.”



7 Oracle Application Developer Questions And Answers

3⟩ How to Use Delegated Administration Services (DAS), which task can you accomplish?A. manage OracleAS Single Sign-On serverB. manage Oracle Internet Directory processesC. register applications that are created using OracleAS PortalD. 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)

 167 views

4⟩ 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;

 191 views

6⟩ Suppose You execute the following command in your Oracle Application Server 10g installationto 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 startThe command does not error out. But while trying to locate the server instance using theProcess 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.

 180 views