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

DB2 Interview Questions

Questions Answers Views Company eMail

What does CURRENTDATA option in bind indicate

IBM,

1 8913

What is the format (internal layout) of ?TIMESTAMP??

1 5745

What is the difference between group by and order by?

IBM, TCS,

2 14639

How many buffer pools are there in DB2?

2 7428

What are the three lock types?

2 6571

When is the access path determined for dynamic SQL?

2 9143

What is a Database Request Module(DBRM)?

4 20236

What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?

Tech Mahindra,

3 14338

What is cursor stability?

1 8450

What are data types?

2 5416

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

2 9657

What are leaf pages?

3 8858

when does the SQL statement gets executed when you use cursor in the application programming ?

IBM,

3 10537

What are the disadvantages of PAGE level lock?

3 8376

In terms of DB2 indexing, what is the root page?

1 5333

Post New DB2 Questions

Un-Answered Questions { DB2 }

Explain dclgen.

1218

What is netezza database?

1032

What is a plan and package in db2?

1107

What is the difference between cursor stability and repeatable read isolation levels?

1182

Name the various locking levels available?

1101

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1053

What is bind and rebind in db2?

1141

What is the result of open cursor statement?

1085

What is the use of db2?

1060

What is runstats and reorg in db2?

1308

How would you find out the total number of rows in a db2 table?

1057

How do I start db2 in windows?

1104

Explain about rct.

1093

what is a corelated subquerry?

1126

Where can you declare a cursor in a cobol-db2 program?

1081

For More Un-Answered { DB2 } Questions Click Here