what is primary key and foreign key when and where have to use
- 5 Answers
- 6236 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 |
How many types of synonyms in Oracle?
How to view the tablespaces in the current database?
i want department wise maxmum salary and empolyee name
How do I find the database name in oracle?
what is the syntax of SELECT command?
Ho to insert no. of records at a time..i mean i want to insert 100 records at a time into a table
What is merge in oracle?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
what is kernel?
How do you find current date and time in oracle?
Does facebook use oracle?
How to turn on or off recycle bin for the session?
Oracle General 
