IBM MAINFRAME GURU Forum
  Home      Forum      Online Tutorials      Interview Questions      Mainframe Books      IT News
 


Home  >  Discussion Forum  >  DB2 INTERVIEW QUESTIONS
    

DB2 INTERVIEW QUESTIONS

No of Questions : 142
Goto page Previous  1, 2, 3 ... 8, 9, 10 ... 13, 14, 15  Next



DB2 INTERVIEW QUESTIONS
What are the disadvantages of PAGE level lock?
Question : What are the disadvantages of PAGE level lock?

View Answer(1)

How does DB2 determine what lock-size to use?
Question : How does DB2 determine what lock-size to use?

View Answer(1)

What are the various locking levels available?
Question : What are the various locking levels available?

View Answer(0)

I use CS and update a page. Will the lock be released after
Question : I use CS and update a page. Will the lock be released after I am done with that page?

View Answer(1)

When do you specify the isolation level? How?
Question : When do you specify the isolation level? How?

View Answer(2)

What is the difference between CS and RR isolation levels?
Question : What is the difference between CS and RR isolation levels?

View Answer(1)

What are the isolation levels possible ?
Question : What are the isolation levels possible ?

View Answer(1)

simulate the EXPLAIN of an embedded SQL statement
Question : How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause.)

View Answer(1)

How do you do the EXPLAIN of a dynamic SQL statement?
Question : How do you do the EXPLAIN of a dynamic SQL statement?

View Answer(1)

EXPLAIN has output with MATCHCOLS = 0. What does it mean?
Question : EXPLAIN has output with MATCHCOLS = 0. What does it mean?

View Answer(1)

Goto page Previous  1, 2, 3 ... 8, 9, 10 ... 13, 14, 15  Next

Home  >  Discussion Forum  >  DB2 INTERVIEW QUESTIONS


   

IBM MAINFRAME - COBOL Interview Questions( 59 )

IBM MAINFRAME - DB2 Interview Questions ( 110 )

IBM MAINFRAME - JCL Interview Questions( 52 )

IBM MAINFRAME - CICS Interview Questions( 70 )

IBM MAINFRAME - VSAM Interview Questions( 22 )





Google
 
Web mainframegurukul.com









 
Online ABEND Reference ||  JCL References ||  COBOL References ||  VSAM References ||  Tutorials by Drona Series ||  SQL tutorial ||  BOOKS  ||  SiteMap    || Simple JCL Tutorials  || JCL Tutorial from MainframeGurukul.com   || Simple JCL Tutorial - Chapter1   ||  DB2 Interview questions   || JCL Interview Questions   || COBOL Interview Questions   || VSAM Interview Questions   || CICS Interview Questions   || < simple DB2 SQL tutorial



Drona Educational Forums - Mainframe Cobol DB2 CICS Board
Copyright ? 2005 mainframegurukul.com. All rights reserved