Interested to Buy Any Domain ? << Click Here >> for more details...
Why we choose emp number as primarykey?
- 4 Answers
- 6492 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 are Indexes Update ?
How to create a table interactively?
How to connect to a local oracle 10g xe server?
How to delete a column in an existing table?
difference between truncate and delete ,drop?
How view is different from a table?
Explain can a view based on another view?
What is raw datatype?
How would you optimize a slow SQL query?
Please explain oracle left join with an example?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
Explain enable novalidate constraint.
Oracle General 
