what is primary key and foreign key when and where have to use
- 5 Answers
- 5857 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prashant
primary key has a unique & it is only one in a
databasewhile fkey is not unique. it is based on primary key
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
Answer / chandrika
primary key has unique value, it dostnt contain null values
and duplicate values.
foregin key is primary key of another table
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / raveendran
Primary key is unique across entire table.In primary key
not null constraint is activated.Only one primary key in
one table.
foreign key points to primary key of another table
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / csprusty
To establish a relationship between 2 tables.
pk=(unique+not null)
fk=unique
| Is This Answer Correct ? | 1 Yes | 2 No |
Can we insert data in view oracle?
What is the function of Optimizer ?
after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble
How to download oracle database 10g xe?
Can we store images in oracle database?
Can we create more than one constraint to column ?
can you write commit in triggers?
How can one skip any number of rows while loading the DB tables with SQL Loader? Similarly how can one skip any column?
How would you go about verifying the network name that the local_listener is currently using?
What is meant by joins? List out the types of joins.
What is SAVE POINT ?
Why should I use oracle database?
Oracle General 
