what is the difference between primary key & foreign key?
- 57 Answers
- 122436 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
Answer Posted / navane
Primary key is a keyword.
It should not have null value and duplicate value.
We can have only one primary key in a table and the value
should be unique.
Foreign key is a keyword.
It can have null value and duplicate value.
We can have more than one foreign key for a table and this
froeign key table references the primary key table.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
State some uses of redo log files?
What are a cluster and non-cluster index?
Explain a private synonyms?
Difference between inner join vs where ?
How to use "in out" parameter properly?
What are the numeric comparison operations?
What are the most common interview questions on ETL Testing for experience?
What is the difference between a primary key & a unique key?
Briefly explain what is literal? Give an example where it can be used?
How to establish administrator authentication to the server?
How to use select statement to count the number of rows in oracle?
How to bring a tablespace offline?
How would you begin to troubleshoot an ORA-3113 error?
What are a query and state the different types of queries and their uses?
What is an oracle function?
