Interested to Buy Any Domain ? << Click Here >> for more details...
Why we choose emp number as primarykey?
- 4 Answers
- 6426 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / devaraj
Because, emp number is unique. so easy to retrieve
| Is This Answer Correct ? | 14 Yes | 0 No |
Answer / barun
Hi
each employe have empid is unique and nonzero.acording to
difinition of primery key row uniquely represent and it
should be non zero.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / sanjay
Bcoz it easy to find a number then a character in the table
and easy to insert in another table which have foriegn key
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / aslam baig
Primary key contains the charechteristics ( unique , not
null ), which means the number should not repeat, and
should null, the employees in the company can have same
name. if you assign unique number we can easily identity.
which employee absent, which employee got salary.... etc.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to connect to oracle using service name instead of sid?
How can we find out the duplicate values in an oracle table?
what is the difference between first normal form & second normal form?
What is meant by joins?
What is meant by raw datatype?
How to create id with auto_increment on oracle?
How to insert multiple rows with one insert statement in oracle?
What is a dead lock in oracle?
Explain the blob datatype?
What is the function of Optimizer ?
How to list all tables in your schema?
What exactly do quotation marks around the table name do?
Oracle General 
