what is the difference between primary key & foreign key?
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
How to create an oracle database?
What is a database table in oracle?
How to change program global area (pga) in oracle?
Is there an oracle sql query that aggregates multiple rows into one row?
What are group functions in oracle?
What is the maximum limit on the number of columns in a table?
Which is better Oracle or MS SQL? Why?
What is enter substitution variable in oracle?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
What is the max number of columns in an oracle table?
What is difference between cartesian join and cross join?
How do I limit the number of rows returned by an oracle query after ordering?
How to retrieve values from data fields in record variables?
What is recovery manager in Oracle?
Explain oracle’s server parameter file.