what is the difference between primary key & foreign key?
- 57 Answers
- 122290 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
Answer Posted / anjanareddy
i cleared this question simple.
TAKE A LOOK
primary key:-It doesn't allow NULL values and duplicate values
it is a unique one.
Foreign key:- It allows NULL and duplicate values
It always give reference to primary key of another table
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain constraining triggers.
What is tns service name?
How can I see all tables in oracle?
What is oracle data type?
Which is better Oracle or MS SQL? Why?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
How would you begin to troubleshoot an ORA-3113 error?
Can we store pictures in the database and if so, how it can be done?
How to estimate disk space needed for an export job?
How to initialize variables with default values?
What is the data type of dual table?
Explain oracle’s server parameter file.
What suggestions do you have to reduce the network traffic?
Explain the difference between replace() and translate() functions in oracle?
How to declare a local variable?
