what is the difference between primary key & foreign key?
Answer Posted / aarti
Primary Key : It is a unique key of the table.Unique for
each record in the table(e.g ID).
Foreign Key : When a primary key is used as a reference key
in another table then it is called as a foreign key.It is
used to link two tables.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How to export your connection information to a file?
Difference between varchar and varchar2 data types?
What is a database table in oracle?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
How to put more than 1000 values into an oracle in clause?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
Difference between hot backup vs. Cold backup?
Why do you use stored procedures and state some of its disadvantages?
types of indexes and the rationale behind choosing a particular index for a situation.
what is the difference between substr and instr function in oracle?
Is the After report trigger fired if the report execution fails ?
How to delete a user account in oracle?
How to get a list of all background sessions in the database?
Explain the use of ignore option in imp command.
How do you increase the OS limitation for open files (LINUX and/or Solaris)?