Why we choose emp number as primarykey?
- 4 Answers
- 6911 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 |
Is insert autocommit in oracle?
Does facebook use oracle?
various types of joins
What are the differences between blob and clob 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?
How would you best determine why your MVIEW couldnt FAST REFRESH?
What is an oracle recycle bin?
which is best insttute for teradata,sybase,mysql,oracle in hyderabad
Which is better Oracle or MS SQL? Why?
What does COMMIT do ?
types of indexes and the rationale behind choosing a particular index for a situation.
What are a query and state the different types of queries and their uses?
Oracle General 
