What is the difference between Primary key and
unique index?
Answer Posted / sunny kalra
Primary key: a relational database constraint. Primary key consists of one or more
columns that uniquely identify a row in the table. For a normalized relation, there
is one designated primary key.
Unique index: a physical object that stores only unique values. There can be one
or more unique indexes on a table.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the result of open cursor statement?
What is db2 purescale?
How do I change the column size in db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is the usage of open cursor command?
What is the difference between dbm cfg and db cfg file in db2 ?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
How can record locking be achieved in those DB2 versions which do not support it?
How many types of page locks can be held in db2?
How many databases are there?
What is buffer pool in the db2 database?
How can deadlocks be resolved?
What are iseries servers?
How to run db2 command in windows?
What is node in db2?