Interested to Buy Any Domain ? << Click Here >> for more details...
Why we choose emp number as primarykey?
- 4 Answers
- 6632 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 |
select statement does not retrieve any records. what exception is raised?
Explain database link?
What's dateware house and what's clustor with practicle example
What is a read only transaction in oracle?
find out first highest salary?
10 Answers Verinon Technology Solutions,
How to drop an index?
How to remove a row in a database table?
2. Display the post code and the total number of purchase orders placed with creditors in that post code.
How will you differentiate between varchar & varchar2?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
how to retrieve 1st and last row of table without using group functions??
What is a snapshot in oracle database?
Oracle General 
