Interview Questions Answers in DB2

Questions / { sunil }

Questions Answers Category Views Company eMail

Answers / { sunil }

Question { 10402 }

What is meant by repeatable read?

Answer

Its an isolation level. In RR the locks are retained til
the end of the transaction.

Is This Answer Correct ?

6 Yes

4 No

Question { 4950 }

Compare a subselect to a join?

Answer

join is more efficeint, Subselect can be written as a join.

Is This Answer Correct ?

0 Yes

0 No

Question { 6468 }

Describe the elements of the SELECT query syntax?

Answer

SELECT * FROM WHERE COLNAME=;

Is This Answer Correct ?

1 Yes

0 No

Question { 5609 }

What is DB2 (IBM Database 2)?

Answer

Its a database/datacommunication system.

Is This Answer Correct ?

1 Yes

2 No

Question { 13164 }

What is QUIESCE?

Answer

Its an utility to flush all the buffers

Is This Answer Correct ?

3 Yes

1 No

Question { 18553 }

What is a DBRM, PLAN ?

Answer

database rquest module(DBRM) , they are created after the
precompilation is performed. It contains executable host
SQL statements.

Plan is the output of bind process, of which the inout to
bind is DBRM. Plan contains host SQL statements.

Is This Answer Correct ?

16 Yes

3 No

Question { 20140 }

What is a Database Request Module(DBRM)?

Answer

A DBRM is the output of the precompilsaton. The DBRM will
be having the name of the member name. It contains SQL
source statements extracted from the appl. program

Is This Answer Correct ?

18 Yes

3 No

Question { 8416 }

What is cursor stability?

Answer

Its an isolation level, It is cursor stability that “tells”
DB2 that database values read by this application are
protected only while they are being used. As soon the
program moves from one row to another other programs read
the first row.

Is This Answer Correct ?

25 Yes

3 No

Question { 9600 }

What is a NULL value? What are the pros and cons of using
NULLS?

Answer

A null value indicates that there is blank value in the
column field. It takes one byte of storage. Null value
requires special prog. to be handled in the app. prog

Is This Answer Correct ?

2 Yes

6 No

Question { 9326 }

What is meant by the attachment facility?

Answer

CICS attachment facility is used to communicate between
CICS and DB2 interface.

Is This Answer Correct ?

4 Yes

0 No

Question { 10206 }

What is a Cartesian product?

Answer

A Cartesian product results from a faulty query. It is a
row in the results for every combination in the join
tables.

Is This Answer Correct ?

1 Yes

1 No

Question { 20606 }

What does the RUNSTATS Utility do?

Answer

reclaims free spcace, orders the records

Is This Answer Correct ?

1 Yes

29 No

Question { 8411 }

When do you use the IMAGECOPY?

Answer

i think its used to make a copy of tablespaces

Is This Answer Correct ?

2 Yes

0 No

Question { 7643 }

When would you prefer to use VARCHAR?

Answer

when u declare a column with 10 bytes and only the field is
using 6bytes of storage , the balance 4 bytes will be
reclaimed ie its not wasted.

Is This Answer Correct ?

6 Yes

2 No