what is primary key and foreign key when and where have to use
Answer Posted / ramprasad.s
HI
Primary key = (Not Null + Unique).
Foreign key = (For Referential table access).
Bye
sun_ramprasad@yahoo.com
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
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 use group functions in the select clause using oracle?
What is difference between truncate and delete?
Explain the use of ignore option in imp command.
How to export several tables together?
How to drop a stored function?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
What happens to the current transaction if the session is killed?
What is a schema in oracle?
What is the relation of a user account and a schema in oracle?
What are the ansi data types supported in oracle?
What are the differences between char and varchar2 in oracle?
What is a proxy object?
What is recovery manager in Oracle?