what is difference between foreign key and reference key
Answer Posted / anup
very simple...we use primary key or foreign key whenever we need to make relation.ex..if we need to join student (Roll P.K) and marks(roll F.K.) then we can join both tables only if we have primary key in one table and foreign key in other..one table may have n numbers of foreign key and n number of primary key (Called composite key)..mail me if u need more details in oracle or any front end lang...anup from chennai,Ranchi.
Is This Answer Correct ? | 8 Yes | 27 No |
Post New Answer View All Answers
Is oracle an operator?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
how can we store any pdf file in oracle
Differentiate between pre-select and pre-query?
What is a user account in oracle?
What are the differences between lov and list item?
What is the meaning of recursive hints in oracle?
How to create a temporary table in oracle?
Explain cascading triggers.
What are the oracle differences between nvl and coalesce
How much memory your 10g xe server is using?
How to loop through a cursor variable?
How to insert a record into a table?
What do you know about normalization? Explain in detail?
How do I reset a sequence in oracle?