Answer Posted / dips

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


author_id lastname firstname -> book_id title
--------- -------- --------- -> ------- ------
0001 henry john -> 0001 a database
primer
0002 building
datawarehouse
0003 teach
yourself sql
0002 johnson mary -> 0004 101 exotic
recipes
0003 bailey harry -> 0005 visiting
europe
0004 smith adam

Explain how to login into bs mode?

1056

---

Explain how many message nodes are possible for a database?

905

---

What are the various layers of peoplesoft.

968

---

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

957

---

What are peopletools utilities?

915

---

Explain recycling the server processes.

1007

---

Explain compare reports?

984

---

Explain environment hub?

983

---

How to get a single ouptut by combining two or more queries?

894

---

Explain psstatus table?

972

---

What does psadmin do?

889

---

Explain psstatus table. What is its use?

923

---

What is weblogic server administration console?

1040

---

What bea product is used for db transaction in peoplesoft? How would you log into the bs mode?

1057

---

Name the people tools available for integration broker?

884

---