Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between primary key & foreign key?
- 57 Answers
- 135043 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
Answer Posted / afzaal
primary key is a constraint key that can not contain a null
or duplicate values.
foriegn key is a reference key ,before referencing the
foriegn key parent table field or fields must have primary
key.If u can try to insert a value in referencing field,new
record that must contain parent field.
| Is This Answer Correct ? | 22 Yes | 11 No |
Post New Answer View All Answers
Explain what are the characteristics of data files?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
How to convert characters to times in oracle?
Explain oracle’s server parameter file.
What is ASM (Automatic Storage Management) in Oracle?
what is difference between sql plus and sql*plus? (not sql and sql plus).
What is query image?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
What is sharded cluster?
Explain integrity constraints?
How to update values in a table in oracle?
How can windows applications connect to oracle servers?
Explain the different normalization forms?
Explain about functional dependency and its relation with table design?
