what is the difference between primary key & foreign key?
- 57 Answers
- 122277 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
What is the difference between sharding and replication?
material view and view disadvantages?
what are steps for interface? where is exchange rate defined in which table?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
How to use windows user to connect to the server?
How to use "startup" command to start default instance?
various types of hints and their usage
What is system tablespace?
What is different types of joins?
What to do if the binary spfile is wrong for the default instance?
What is the use of aggregate functions in oracle?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
When system tablespace is created?
query optmization techniques and quwry analyser+projects+ppts
How would you go about verifying the network name that the local_listener is currently using?
