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
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
DB is in windows, application server can be configured in Windows or Unix or Anyone?
You just started a new application server. What problems you may encounter?
Suppose if you want to log into datamover in bootstrap mode, you would login as?
How can you launch psadmin?
You want a single output by comining two or more queries. How would you do that?
All the application servers in production environment have reached a threshold. How would you configure a new application server so that the web server is not bounced?
Explain the architecture of peoplesoft.
Explain what are the status available in peoplesoft domain status menu?
Peoplesoft supports which web servers?
What is weblogic server administration console?
How can you configure sql trace?
What is idda logging?
You want to change the system passowrd. How would you do it?
How can you control weblogic server life cycle?
You are receiving an error "application server is down at this time" but hthe application server is running. What could be the problem? How will you debug it?