Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between primary key & foreign key?
- 57 Answers
- 137390 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
Answer Posted / leang heng
Primary Key is a column or group of columns that determine
in each Record to make not null.
Foreign Key is Column that provide Relationship to Primary
Key between Entities or Table.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
Explain a private synonyms?
Explain the use of inctype option in exp command.
How to Truncate Table in Oracle
What is Data Dictionary Cache in Oracle?
What is backup in Oracle?
How to write a left outer join with the where clause in oracle?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Can we create database in oracle using command line ?
How to check the oracle tns settings?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
What is oracle rownum?
Give the various exception types.
What do you mean by a database transaction & what all tcl statements are available in oracle?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
