Answer Posted / sridevi bandi
simplify complex select statements.we can use load-lookup
to simplify joins.use dynamic sql instead of a condition in
a select statement.one program can create multiple reports
simultaneously.we can save compiled programs and return
them with sqr execute.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
How do you regenerate PSTUXCFG after manually changing psappsrv.cfg?
Does Tuxedo use psappsrv.cfg in text form to determine run-time parameters for the domain? If not, what does it use?
What are the various documents you need to become familiar with prior to the installation?
What is Tnsnames.ora?
What other files are copied to this directory? What is the purpose of each?
What Web Service software is currently supported in PeopleSoft 8.4?
What is the Tux IPC Helper?
What port does the Web Server use?
Have you done Migration? How to build in PeopleSoft ? Why build from Oracle?
Describe two SQR reports you can run to check the integrity of the database?
What must be installed prior to running the PeopleSoft installer?
What is the difference between a Listener process and a Handler process?
What is an Application Server Domain?
Briefly describe PeopleSoft and Non PeopleSoft objects?
What are the PeopleSoft components for the Web Server?