what is the difference between primary key & foreign key?
- 57 Answers
- 122453 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
Answer Posted / simbu
primary key is a keyword .that refers to the unique value
in the particular record.it cant have null
foreign key is always keyword that refers primary key.it has
null value.its refers to another table
| Is This Answer Correct ? | 34 Yes | 8 No |
Post New Answer View All Answers
How do I spool to a csv formatted file using sqlplus?
Why do we need integrity constraints in a database?
what are steps for interface? where is exchange rate defined in which table?
How index is implemented in oracle database?
Can you tell me how to add new column in existing views?how?How is possible?
What is background process in Oracle?
Explain integrity constraints?
What is the order of defining local variables and sub procedures/functions?
what's query optimization and without use of IN AND Exist can we get another way data from query
Can the query output be sorted by multiple columns in oracle?
Describe varray?
What are the different pseudo commands? Explain in general?
How to get a list of all background sessions in the database?
How to export your connection information to a file?
What are the oracle differences between nvl and coalesce
