What is the difference between TYPE 1 index and

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is the difference between TYPE 1 index and TYPE 2 index?

TYPE 1 and TYPE 2 are specified when an index is created on the table. TYPE 1 index is the option which comes with DB2V4. With TYPE 2 index data can be retrieved faster as only the data pages are locked and not the index pages. Hence TYPE 2 index is recommended.

(Continued on next question...)

Other Job Interview Questions

• What is the SQL Communications Area and what are some of its key fields?
• What is an asychronous write?
• Suppose I have a program which uses a dynamic SQL and it has been performing ...
• What is the syntax required for the creation of a cursor ?
• What keyword does an SQL SELECT statement use for a string search?
• When one binds a PACKAGE of a plan what package information is stored and where it is stored?
• How do you declare a host variable ...
• Are view updatable?
• Which command is issued to establish the Boot Strap Data Set after an I/O failure?
• What is a cursor ?
• More...