Interested to Buy Any Domain ? << Click Here >> for more details...
explain about index with examples
- 2 Answers
- 7058 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 |
when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations
What are db2 objects?
What is the information associated with sysibm.syslinks table?
What is a Resource Control Table(RCT)? Describe its characteristics.
Are view updateable?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
Name the different types of Table spaces.
Explain about dbrm.
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
How is the value function used?
What is db2 and what is the use of db2 optimizer?
When do you specify the isolation level? How?
COBOL 
