Why we choose emp number as primarykey?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to define a cusotmer as a supplier in ORACLE R12

1728


Where do we use decode and case statements?

563


What is the usage of merge statement?

674


Is primary key indexed by default in oracle?

548


What is an anonymous block?

625






How to write a query with an inner join in oracle?

564


What is rich query?

544


How to filter out duplications in the returning rows using oracle?

644


How to sort the query output in oracle?

615


What is oracle rownum?

522


What is a oracle database?

609


Is there a combination of "like" and "in" in sql?

583


What is a system tablespace and when it is created?

563


How to add a new column to an existing table with a default value?

548


Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1260