Interested to Buy Any Domain ? << Click Here >> for more details...
explain about index with examples
- 2 Answers
- 7064 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 |
What is read-only cursor?
Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?
Explain correlated sub-queries.
What is dbrm? What it contains?
What are some SQL aggregates and other built-in functions?
How to check last update on table in db2?
What is a correlated sub query?
Define declaration generator (dclgen).
What is a cursor in programming?
I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?
What is the use of value function?
What are the contents of a DCLGEN?
COBOL 
