DB2 interview questions – page 6

By using any condition is there any way to abend a program.?If so how?

How do you eliminate duplicate values in SELECT? ?

What are Dedicated and Pool Threads?

What are aggregate functions?

What is the restriction on using UNION in embedded SQL?

How do you select a row using indexes? ?

What are the disadvantages of using VARCHAR?

What is meant by isolation level?

What is DCLGEN ?

In the WHERE clause what is BETWEEN and IN?

What do you mean by NOT NULL WITH DEFAULT? When will you use it?

What are the disadvantages of PAGE level lock?

How is the SUBSTR keyword used in sql?

What is the purpose of the WHENEVER statement?

A dataset contains 1000 records ,I want to brouse particular record in file-id?

File opening modes in cobol and corresponding dispositions?

How would you retrieve rows from a DB2 table in embedded SQL? ?

What are the 2 sqlcodes that are returned? ?

How do you specify and use a cursor in a COBOL program? ?

What else is there in the PLAN apart from the access path? ?

How does DB2 store NULL physically?

What are the three DB2 date and time data types and their associated functions?

What is REORG? When is it used?

How does DB2 determine what lock-size to use?

What are correlated subqueries?

When do you specify the isolation level? How?

What is sqlcode -811?

Can you use MAX on a CHAR column?

What is a packed decimal..?

How to increase table space in db2?