Accenture DB2 Interview Questions asked in a Mainframe Interview.
Mainframe professionals are invited to share the answers.
- What is the difference between CS and RR isolation levels in DB2? Where do you specify them?
- What are the various locking levels available?
- How does DB2 determine what lock-size to use?
- What is lock escalation in DB2?
- What is a collection in DB2?
- What are the advantages of using a PACKAGE?
- What are PACKAGES in DB2?
- What are the various locks available?
- Can I use LOCK TABLE on a view?
- What is ALTER in DB2?
- What is a DBRM, PLAN?
- What is ACQUIRE/RELEASE in BIND?
- What is a DBRM and PLAN in DB2?
- What is ALTER?
- How can you use LOCK TABLE on a view?
- What are the various locks available?
- What are the disadvantages of PAGE level lock in DB2?
- How does DB2 determine what lock-size to use?
- What are the various locking levels available?
- When do you specify the isolation level in DB2?
- What else is there in the PLAN apart from the access path?
- What happens to the PLAN if index used by it is dropped?
- How do you do the EXPLAIN of a dynamic SQL statement?
- How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF?
- Give an example with a host variable in WHERE clause.
- What are the two sqlcodes that are returned in DB2?
- How would you print the output of an SQL statement from SPUFI?
- How does DB2 store NULL physically?
- How do you retrieve the data from a null column in DB2?
- What is the picture clause of the null indicator variable?
- What does it mean if the null indicator has -1, 0, -2?
- How do you insert a record with a null column?
- What is RUNSTATS in DB2?
- When will you chose to run RUNSTATS?
- Give some example of statistics collected during RUNSTATS?
- What is REORG? When is it used in DB2?
Related Posts
No comments :