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
What is a database table in oracle?
Explain a segment?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is the oracle implicit cursor?
What is an index associated with a constraint?
What is a connect identifier?
What is a cursor in oracle?
is there a tool to trace queries, like profiler for sql server?
How do I uninstall oracle client from windows?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
How to define a variable of a specific record type?
How to create a new tablespace in oracle?
How to update values on multiple rows in oracle?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
What is a nested table?