What is the difference between Primary key and
unique index?
Answer Posted / guest1
Using the Primary Key you can establish referential
integrity. Unix index will be created upon the Primary Key
column, and the data will be seperately placed in the Index
space. If you have not created Unix Index, while accessing
the table it leads to SQLCODE = -540
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is db2 a mainframe?
What is host variable in db2 cobol?
What parameters are used to control the free space in DB2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is rebind in db2?
What is db2 stogroup?
What is a collection in db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What's The Percentage Free Space ?
Mention the downsides of page level lock.
What is the picture clause of null indicator variable?
What is the role of data manager in the db2 database?
Explain correlated sub-queries.
Explain about open switch business continuity software?
Give a brief description of db2 isolation levels?