Application Developer Question:

Can we give DML statements inside a function?

Application Developer Interview Question
Application Developer Interview Question

Answer:

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


Previous QuestionNext Question
Suppose if 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.		Define oracle application certification?