DB2 Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB2 Interview Questions

Questions Answers Views Company eMail

wht are the restrictions for union ?

CTS,

2 6821

where can we use index and subscript ? with example ?

CTS,

3 11167

i want to delete 20th million record how ?

IBM,

4 10964

wt is view ? wht r the restrictions for view ?

Verizon,

3 7778

how can u nderstand the sql stmts executed successfully or not ?

TCS,

1 5979

how to u check the query is executing or not ?where will u check for sqlcode ?

Infosys,

6 12791

i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?

EDS,

2 6966

how can we retrieve the 100 records of the file ?

IBM,

2 8418

is there any restrictions for unions ?

Patni,

4 9253

can i code union in cobol-db2 pgm ?

Patni,

4 13245

what is + sign and -ve sign for sql code ?

TCS,

1 6611

how can u understand the end of the table ?

TCS,

1 6637

if i made sme changes in sub pgm wht r the things to be done for this ?

TCS,

1 6231

wht displays the number of times a query modified ?

TCS,

2 7085

where will u check for sqlcode ?

TCS,

2 7612

Post New DB2 Questions

Un-Answered Questions { DB2 }

How to find primary key of a table in db2?

1065

define clustering index.

1026

What is consistency token in db2?

1141

What is dbrm?

1105

what is db2 restart?

2158

How can you do the explain of a dynamic sql statement?

1069

What is an instance database?

1052

Explain in detail about buffer manager and its functionalities?

1065

How is the value function used?

1154

How would the varchar column remarks defined?

1088

What is copy pending status in db2?

1127

What is a buffer in memory?

1058

What type of database is db2?

971

What is package in cobol db2?

1119

What is dpf in db2?

1109

For More Un-Answered { DB2 } Questions Click Here