Interested to Buy Any Domain ? << Click Here >> for more details...
Why we choose emp number as primarykey?
- 4 Answers
- 6627 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 |
Explain the use of grant option in imp command.
what is meant by magic query
1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records
can we insert any row to dual table if i got the permission from DBA
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
How to define default values for formal parameters?
Shall I get Pro*C Compiler in Oracle-10g release ?
How many memory layers are in the oracle shared pool?
SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?
Give the different types of rollback segments.
What is SAVE POINT ?
What is recycle bin in Oracle?
Oracle General 
