Why we choose emp number as primarykey?

Answers were Sorted based on User's Feedback



Why we choose emp number as primarykey?..

Answer / devaraj

Because, emp number is unique. so easy to retrieve

Is This Answer Correct ?    14 Yes 0 No

Why we choose emp number as primarykey?..

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

Why we choose emp number as primarykey?..

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

Why we choose emp number as primarykey?..

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

Post New Answer

More Oracle General Interview Questions

can u call user defined functions in select statements

2 Answers  


How to assign data of the deleted row to variables?

0 Answers  


Which is better Oracle or MS SQL? Why?

2 Answers   Bally Technologies,


What is use of oracle?

2 Answers   Satyam,


What are the execution control statements?

0 Answers  






How to use windows user to connect to the server?

0 Answers  


Point the difference between translate and replace?

0 Answers  


Hi Every One , What is the table Space in Oracle Database ? waiting for answere and thankyou

8 Answers  


25. Display the client number and the value of the highest value order placed by that client.

2 Answers   Wipro,


What is data type in oracle?

0 Answers  


How to download oracle database 10g xe?

0 Answers  


how to create a new database in oracle?

6 Answers   TCS,


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)