explain about index with examples
- 2 Answers
- 6292 Views
- Syntel, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swapnil
USING AN INDEX WE CAN ACCESS THE KEY VERY FAST
ON PRIMARY KEY YOU CREATE AN INDEX.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / 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 |
How can you display the current date & current time ?
How many buffer pools are available in db2?
What Utility is used to migrate DB2 from one release to the next?
What is the clustering index in the db2 database?
What is package in cobol db2?
How is a typical DB2 batch program executed ?
What is the use of dclgen in db2?
What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?
Are views updateable?
Mention the different locking levels that are available in db2.
What is a view? Why use it?
What type of database is db2?
COBOL 
