What is One to Many Relationship?
Answers were Sorted based on User's Feedback
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 |
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 |
You can specifically trace the activity of the PSAPPSRV server process by setting which one?
Explain how to login into bs mode?
What are various ways to trace a process / application in peoplesoft?
How can you control weblogic server life cycle?
What bea product is used for db transaction in peoplesoft?
Your Onsite DBA has called you up and told you that one of the tables PS_ABC_TAO has grown very big in size. Based on the standard naming convention, you have determined that the record is a temporary record since it ends with _TAOYou look into the database and decide that that the data is not required any more. You ask the DBA to delete the data in the table.Next day you get a call from an irritated user who says that a daily process that took only 1 minute to run is taking about 2 hours today. You look into his process and find that it uses PS_ABC_TAO as a temporary table.What would you suggest the DBA to do ?
What is the default Crystal Report that PeopleSoft Query tool creates?
What statuses are available in peoplesoft domain status menu?
What are the default values for psappsrv and other servers when application designer starts?
Is it ok to install two different peoplesoft versions on same machine? If yes, how would you do it?
You want to setup file attachment / report servers. How would you do that?
Explain what are the differences between rowclass and rowset in peoplesoft?