what is primary key and foreign key when and where have to use
- 5 Answers
- 5927 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 |
What are the advantages of oracle?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
How to assign a table row to a record variable?
List the parts of a database trigger.
which institute and which faculty is providing best training for oracle sql, plsql in hyderabad
Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
How to invoke the data pump export utility?
Explain implicit cursor.
Can you use a commit statement within a database trigger?
How to generate query output in html format?
How to retrieve values from data fields in record variables?
Oracle General 
