Interested to Buy Any Domain ? << Click Here >> for more details...
Why we choose emp number as primarykey?
- 4 Answers
- 6576 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 |
In which language oracle has been developed?
What is an Oracle Instance?
Is primary key = unique key,not null? If yes,please explain IF No,please explain
How to define an explicit cursor in oracle?
What is a cognitive schema?
How to create a new table in oracle?
Who i will insert 1 lacks record in a Database table
1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]
9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS
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.
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
How to empty your oracle recycle bin?
Oracle General 
