Why we choose emp number as primarykey?
- 4 Answers
- 5318 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 |
Define oracle database
How to execute a stored procedure in oracle?
What is difference between truncate and delete?
Difference between varchar and varchar2 data types?
What are the benefits of ordbms?
Explain integrity constraints?
what is normalisation?what are its uses?
how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group
What are the uses of synonyms?
difference between bind variable and variable
What is format trigger?
How to convert a string to a date in oracle database?
Oracle General 
