Answer Posted / dilon
index are nothing but primary key in the table...
ex:create table emp(eno numeric(4) not null primary key,
ename char(10) not null,
elocation char(10) not null)
in this example employee number eno is the primary key it is
called as index...
| Is This Answer Correct ? | 1 Yes | 8 No |
Post New Answer View All Answers
What do you mean by between and in? Is between inclusive of specified range values?
Mention the various locks that are available in db2.
How do I connect my db2 database to ibm?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
How to find the number of rows in a db2 table?
How do I start db2 in windows?
Define check constraint.
What is the role of schema in the db2 database?
What is explain plan in db2?
What's The Error Code For Unique Index Voilation?
How is a typical db2 batch pgm executed?
How do I add a column to a table in db2?
What is reorg and runstats in db2?
What is db2 bind process?
When do you specify the isolation level?