Answer / ramana

The relationship between a database server and an
application server is a one-to-many model.
That is, a single database server can have multiple
application servers connecting to it.
The database server simultaneously handles the application
server connections, Development Environment connections,
and batch programs running against it.

Answer / 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

How do you find app server / process scheduler are up and running ?

0 Answers  

---

you have created a Menu and a Page and given user access to that page, which of the tables gets affected on this?

1 Answers  

---

PeopleSoft tracks object changes using a system table. Which PeopleTools System table is used to track object changes?

2 Answers  

---

How do you start weblogic on unix?

0 Answers  

---

Differentiate between rowclass and rowset?

0 Answers  

---

You are a PeopleSoft Partner and wish to get information on database performance benchmark ( or something like this) Where would you look for the information ?

1 Answers  

---

Explain about the Optimizer values passed in Oracle?

0 Answers  

---

What are the People Tools available for Integration Broker?

1 Answers  

---

For downloading patches and fixes , you have gone to the customer connection and looking under 8 april, 2000 and see Report IDS like R-CCHEN-VP14JM. What does R stand for ?

4 Answers   Cognizant,

---

How would you find out how many users are connected to peoplesoft?

0 Answers  

---

one particular query taking long time how to reduce that time

2 Answers   Oracle,

---

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

0 Answers  

---