What is the difference between primary key & unique index ?

Answer Posted / s

Primary Key uniquely identifies the record and the UNIQUE
index on the primary key ensures that no duplicates values
will be stored in the table.

Is This Answer Correct ?    16 Yes 14 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

750


What is db2 catalog database?

583


Explain the benefits you can get from mainframe connect?

523


What action db2 takes when a program aborts in the middle of a transaction?

659


Which are the db2 tools to protect integrity of the database?

692






What is the syntax for seeing the columns and data types of a table in the db2 database?

579


Is db2 a database?

575


Is db2 free?

684


How to execute stored procedures?

624


What is cursor stability in db2?

813


What is the difference between plan and package in db2?

581


What is db2 plan table?

622


I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

2757


What language is db2 written in?

596


What is dpf in db2?

667