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
What is the maximum number of triggers that can be applied to a single table?
Explain an exception and its types?
What is oracle server autotrace in oracle?
What happens to the data files if a tablespace is dropped?
How to list all indexes in your schema?
what are the default admin accounts in Oracle 10g ?
How to check database size in Oracle?
How to create a new table in oracle?
What is rowid and rownum in oracle?
What is not equal to in oracle?
How many categories of data types in oracle?
What is the data type of dual table?
How to assign query results to variables?
What to do if dba lost the system password?
Why do you use stored procedures and state some of its disadvantages?