what is the difference between primary key & foreign key?
Answer Posted / hardik patel
primary key is used to identify a row and it doesnot allow
null values. It avoids duplication of rows.
whereas foreign key refers to a column or combination of
columns included in the defenition of referential integrity.
| Is This Answer Correct ? | 65 Yes | 20 No |
Post New Answer View All Answers
Explain temporal data types in oracle
What is literal?
definition of cluster and non-clustered index?
How would you begin to troubleshoot an ORA-3113 error?
How do I know if oracle is installed on windows?
What is the string concatenation operator in oracle?
How many types of synonyms in Oracle?
Explain oracle insert into command?
How to define an external table with a text file?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
What is Virtual Private Database in Oracle?
How to resolve the ORA-39133 error in Oracle?
What is bind variable in oracle 11g?
Can a formula column referred to columns in higher group ?
What is PL/SQL ?