Interested to Buy Any Domain ? << Click Here >> for more details...
Why we choose emp number as primarykey?
- 4 Answers
- 6804 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 |
What is transaction control statement and how many types of transaction control statement in Oracle?
What is a named program unit?
Where do you use decode and case statements?
How many categories of data types in oracle?
if i am using dml statement in function. then i am writing select statement what was the output
Compare and contrast between sql and sql server and explain its various functions?
What is the function of Redo Log ?
How to run the anonymous block again?
Are truncate and delete commands same? If so why?
What is an oracle tablespace?
What is Index and different types of Indexes?
Write a simple Store procedure and pass parameter to it ?
Oracle General 
