what is the difference between primary key & foreign key?
Answer Posted / deepa
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 ? | 22 Yes | 7 No |
Post New Answer View All Answers
What is the difference between sharding and replication?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
What are a collation and state the different types of collation sensitivity?
Explain what are synonyms used for?
How to sort output in descending order in oracle?
How to upsert (update or insert into a table)?
How oracle handles dead locks?
Differentiate between pre-select and pre-query?
Give syntax for SQL and ORACLE joins.
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
What is a snapshot log?
What is a system tablespace and when it is created?
How to login to the server without an instance?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
What is a relational database management system?