Interview Questions Answers in DB2

obularaju

{ City } hyderabad
< Country > india
* Profession * asst manager
User No # 4750

Total Questions Posted # 0
Total Answers Posted # 4

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 56
Users Marked my Answers as Wrong # 6

Questions / { obularaju }

Questions Answers Category Views Company eMail

Answers / { obularaju }

Question { IBM, 15202 }

Name the different types of Table spaces.

Answer

1) Simple Tablespace
2) Segmented Tablespace
3) Partitioned tablespace

Is This Answer Correct ?

27 Yes

5 No

Question { 7326 }

What information is used as input to the bind process?

Answer

DBRM- Database Request Modules.

Is This Answer Correct ?

6 Yes

1 No

Question { IBM, 11960 }

How do you declare a host variable (in COBOL) for an
attribute named emp-name of type VARCHAR(25) ?

Answer

10 EMP-NAME.
49 EMP-NAME-LEN PIC S9(4) USAGE COMP.
49 EMP-NAME-TEXT PIC X(25).

Is This Answer Correct ?

19 Yes

0 No

Question { IBM, 5339 }

What should be specified along with a cursor in order to
continue updating process after commit?

Answer

WITH HOLD

Is This Answer Correct ?

4 Yes

0 No