Primary Key uniquely identifies the record and the UNIQUE index on the pr

What is the difference between primary key & unique index ?

Question Posted / s

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

Please Help Members By Posting Answers For Below Questions

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1230

How can deadlocks be resolved?

890

How and when does the db2 enforces the unique key?

1032

What is the difference between nvl and coalesce?

1009

What is commit in db2?

998

What is host variable?

1016

What is meant by dclgen?

1061

what are bind concepts in db2 cobol?

1036

What is plan in cobol db2?

1062

What's The Percentage Free Space ?

1158

List some fields from sqlca?

1004

what is the role of the cursor in db2?

1002

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2869

What is deadlock in db2?

1021

Define buffer pool.

999