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

Tell me what views available in application designer project workspace?

893

---

How do you uninstall the weblogic server?

966

---

Which crystal report does peoplesoft query tool create by default?

895

---

You want to change the system passowrd. How would you do it?

849

---

Where would you install connectivity software?

897

---

What is peoplesoft server process logs?

894

---

Tell us about web servers.

962

---

What are the common elements in peoplesoft configuration manager?

906

---

Explain ren server?

914

---

How can you configure sql trace?

1048

---

Explain what are the search keys you use to find patches and fixes?

870

---

Suppose I have created a menu and a page and given user access to that page, which of the tables gets affected on this?

788

---

Suppose you want to update your password and enter a hint for forgotten password. What would you access?

876

---

What are the different types of reports in peoplesoft?

860

---

DB is in windows, application server can be configured in Windows or Unix or Anyone?

2162

---