What is the difference between Primary key and
unique index?

Answer Posted / rams

Primary Key is Unique and Not Null. Unique index can be defined on Primary Key or any other Unique column in the table. Unique index can have a Null Value unlike Primary Key.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the purpose of using commit?

616


What is access path in db2?

562


How to create db2 table in mainframe?

629


What is plan in cobol db2?

593


Can you use max on a char column?

638






Explain the function done by data manager?

853


What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

710


What are the bind parameters ibm db2?

623


Why do chiropractors use drop table?

660


What are concurrency issues?

629


What does a deadlock mean in DB2?

653


How many databases are there?

590


How do we specify index to include or not during bind process.

1674


What does reorg do in db2?

578


What is load utility in db2?

668