what is the difference between primary key & foreign key?
Answer Posted / vaziuddin shaik
PRIMARY KEY
-------------
Primary key is a column in a table which is having unique
values......and it does not contain null values and
duplicate values...........
FOREIGN KEY
-------------
Foreign key is a column in a table which act as reference to
another table.....and it may contain null and duplicate
values.....(or)it may not contain null and duplicate
values...........
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to rename a tablespace in oracle?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What is oracle latest version?
What are the extensions used by oracle reports?
What are the set operators union, union all, minus & intersect meant to do?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
Explain the dml?
Explain the use of show option in imp command.
Difference between cartesian join and cross join?
What is a view and how is it different from a table?
Give the different types of rollback segments.
How to commit the current transaction in oracle?
How to list all user accounts in oracle?
Explain constraining triggers.
Use of an integrity constraint is better to validate data. Explain