What is use of Applications listener ?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is use of Applications listener ?

Apps Listener usually running on All Oracle Applications 11i Nodes with listener alias as APPS_$SID is mainly used for listening requests for services like FNDFS and FNDSM.

(Continued on next question...)

Other Job Interview Questions

• Where is Jserv configuration files stored ?
• What is PCP is Oracle Applications 11i ?
• Can a function take OUT parameters. If not why?
• What WHERE CURRENT OF clause does in a cursor?
• What should be the return type for a cursor variable. Can we use a scalar data type as return type?
• Can the default values be assigned to actual parameters?
• Which data type is used for storing graphics and images?
• Where is plssql cache stored in Oracle Applications ?
• How will you find Invalid Objects in database ?
• What is a OUTER JOIN?
• More...