What is One to Many Relationship?

Answers were Sorted based on User's Feedback



What is One to Many Relationship?..

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.

Is This Answer Correct ?    2 Yes 0 No

What is One to Many Relationship?..

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

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More PeopleSoft Administration Interview Questions

The Security Administrator is not available. You are in a hurry to grant a user the ability to start an application server, and you decide to make the change in the actual application server configuration file, rather than using the Security Administrator. Referring to the above information, how would you grant a user the ability to start an application server using the application server configuration file, PSAPPSRV.CFG?

1 Answers  


Tell us about web servers.

0 Answers  


How do you set up table-sharing in PeopleTools applications?

2 Answers   ADS,


Is it ok to install two different peoplesoft versions on same machine?

0 Answers  


You have downloaded an Application fix as a project from the customer connection. Where would you upgrade it to ?

1 Answers  






What are the common elements in peoplesoft configuration manager?

0 Answers  


What is peoplesoft server process logs?

0 Answers  


What is psadmin in peoplesoft?

0 Answers  


Where are workflow work items found?

3 Answers   Accenture,


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

5 Answers  


Customization done in Dev DB, Which tool you will use to move it to Prod DB?

1 Answers  


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

0 Answers  


Categories
  • PeopleSoft HRMS Interview Questions PeopleSoft HRMS (83)
  • PeopleSoft Financials Interview Questions PeopleSoft Financials (27)
  • PeopleSoft Administration Interview Questions PeopleSoft Administration (181)
  • PeopleSoft Tools Interview Questions PeopleSoft Tools (176)
  • PeopleSoft Interfaces Interview Questions PeopleSoft Interfaces (58)
  • Internet EBusiness Interview Questions Internet EBusiness (19)
  • PeopleSoft Implementation Interview Questions PeopleSoft Implementation (142)
  • PeopleSoft General Interview Questions PeopleSoft General (385)
  • PeopleSoft AllOther Interview Questions PeopleSoft AllOther (60)