Interested to Buy Any Domain ? << Click Here >> for more details...
Why we choose emp number as primarykey?
- 4 Answers
- 6794 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 |
Query to retrieve record for a many to many relationship ?
How to use "out" parameter properly?
One Table having two rows with one colomn having values Like"Male" and "Female". how to upadte these values Like "Female" and "Male" in single update statement.
What is the diff between Oracle and SQL Server
5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.
how many columns can a plsql table have
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
Explain the use of log option in exp command.
How to Select second Maximum salary in a Table ?
Can u make a synonym for deptno=10 only from emp table.
How do I uninstall oracle client from windows?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
Oracle General 
