what is the difference between primary key & foreign key?
Answer Posted / anand
Primary key is used to identify a row in a table 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 ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to create an oracle database?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
How index is implemented in oracle database?
Explain the use of record option in exp command.
What are the tools for Oracle ?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
How to get execution statistics reports on query statements?
How to drop a stored procedure in oracle?
What is difference between cartesian join and cross join?
How does Oracle guarantee data integrity of data changes?
What do you mean by a tablespace?
How will you differentiate between varchar & varchar2?
What is ADDM Advisor in Oracle?
How to get maxsal , minsal, ename department wise in single query
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.