1. Explain What are the components which form the part of Integration Broker?

1] Application Messaging
2] Component Interface
3] File Layout

4. Where do we need to install connectivity software?

We need to install Connectivity Software on Appserver and
scheduler server if they are not on the Database server

6. What is One to Many Relationship?

In a one-to-many relationship, each row in the related to
table can be related to many rows in the relating table.
This allows frequently used information to be saved only
once in a table and referenced many times in all other
tables. In a one-to-many relationship between Table A and
Table B, each row in Table A is linked to 0, 1 or many rows
in Table B. The number of rows in Table A is almost always
less than the number of rows in Table B.

example:
authors table
============
author_id (primary key)
lastname
firstname
book_id (foreign key - link to book_id of books table)


books table
===========
book_id (primary key)
title

7. Given ma a SQL Statement, if you have been asked to check the right syntax?

Run in backend whether WinSQL or Toad and check if errors
out if it is the cursor will stop exactly where the syntax
is wrong

8. Do you know What is the purpose of state records?

State record is used in AE program property to hold the
data in buffer and it passes the data one step to another
step or one action to another action.Most of the time
record type of the state record is derived/work but while
using with restart logic record type sd be SQL Table.

9. What are the AE program options?

Do When, Do While, De select, Peoplecode, SQL or call
section, log message, and Do until

SQL and CallSection are mutually exclusive and one can be
used at a time in a step.

10. Can we install two different peopletools version on same machine ie client, if yes , what oracle configuration should be installed?

Yes we can install 2 different client peopletools version
on same machine and configuration for the version will be
different

Download Interview PDF