Interview Questions.

Q1. Name The Various Locking Levels Available?

PAGE, TABLE, TABLESPACE

Q2. Explain What Are The Various Isolation Levels Possible ?

The isolation ranges are CS: Cursor Stability RR: Repeatable Read

Q3. Explain How Can You Do The Explain Of A Dynamic Sql Statement?

 Use SPUFI or MF to EXPLAIN the dynamic SQL assertion

 Include EXPLAIN command inside the embedded dynamic SQL statements

Q4. Can You Tell Where Is The Output Of Explain Stored?

In user id PLAN_TABLE

Q5. Explain In Brief How Do You Leave The Cursor Open After Issuing A Commit?

Use WITH HOLD option in DECLARE CURSOR declaration, it has no longer impact in psuedo-conversational CICS applications.

Q6. Can You Tell Me How Can You Find Out The # Of Rows Updated After An Update Statement?

You need to check the price stored in SQLERRD(three)

Q7. When You Do A Database Commit, Is The Cursor Closed In Db2?

Yes, the cursor can be closed.

Q8. Explain What Are The Contents Of A Dclgen In Db2?

EXEC SQL DECLARE TABLE announcement which gives the layout of the table/view in terms of DB2 datatypes. A host language copy book that gives the host variable definitions for the column Names.

Q9. Differentiate Between Cs And Rr Isolation Levels?Wherein Do You Specify Them?

CS: Releases the lock on a page after use

RR: Retains all locks acquired till end of traction. ISOLATION LEVEL is a parameter for the bind procedure

Q10. Describe The Cobol Definition Of A Varchar Field?

A VARCHAR column REMARKS could be defined as follows: 10 REMARKS forty nine REMARKS-LEN PIC S9(four) USAGE COMP forty nine REMARKS-TEXT PIC X(1920)

Q11. Can You Tell What Do You Need To Do Before You Do Explain?

You need to make sure that the PLAN_TABLE is created below the AUTHID

Q12. Explain How Can You Specify And Use A Cursor In A Cobol Program?

Try to use DECLARE CURSOR statement either in working garage or in method department, to specify the SELECT assertion Then use OPEN, FETCH rows in a loop and ultimately CLOSE.

Q13. What Does It Mean - Explain Has Output With Matchcols = zero?

A non matching index test if ACCESSTYPE = I 

Q14. Explain What Are The Disadvantages Of Page Level Lock In Db2?

The primary drawback is the excessive aid utilization if massive updates are to be finished.

Q15. Explain In Brief How Is A Typical Db2 Batch Program Gets Executed ?

You need to Use DSN software to run a DB2 batch application from local TSO An example is shown: DSN SYSTEM(DSP3) RUN PROGRAM(EDD470BD) PLAN(EDD470BD) LIB('ED01TOBJLOADLIB') END Use IKJEFT01 application program to run the above DSN command in a JCL

Q16. Explain How Would You Retrieve Rows From A Db2 Table In Embedded Sql?

Can attain it by using both via the use of the unmarried row SELECT statements, or by the use of the CURSOR

Q17. Can You Tell If Declare Cursor Is Executable?

No, DECLARE CURSOR isn't always executable.

Q18. In Db2, Is It Always Mandatory To Use Dclgen? If Not, Why Would You Use It At All?

It isn't always constantly obligatory to use DCLGEN Using DCLGEN, allows locate wrongly spelt column names and so forth for the duration of the pre- collect stage itself ( due to the DECLARE TABLE ) DCLGEN being a tool, might generate correct host variable definitions for the desk decreasing possibilities of mistakes.

Q19. What Are The Alternate Ways Available To You To Retrieve A Row From A Table In Embedded Sql Apart From Cursor?

By the usage of Single row SELECT.

Q20. Is It Possible More Than One Cursor Open At Any One Time In A Program?

Yes, we are able to open more than one cursor at a time

Q21. List Some Fields From Sqlca.?

SQLCODE, SQLERRM, SQLERRD

Q22. Explain In Brief How Does Db2 Determine What Lock-size To Use?

Based on the lock-size given at the same time as developing the tablespace

Programmer can direct the DB2 what lock-size to apply

If lock-size ANY is unique, DB2 normally choses a lock-length of PAGE

Q23. Is Is Always Mandatory To Use Declare Table In Dclgen ? Can You Tell Why It Used?

It no longer mandatory to have DECLARE TABLE announcement in DCLGEN This is used by the pre-compiler to validate the desk-name, view-call, column call and many others, throughout pre-compile.

Q24. When Do You Specify The Isolation Level?

During the BIND system ISOLATION ( CS/RR )

Q25. Can You Tell Me What Will Happen When You Say Open Cursor?

If there is an ORDER BY clause, rows are fetched, sorted and made to be had for the FETCH declaration Other sensible truly the cursor is positioned on the primary row.

Q26. Can You Tell Me What Is The Physical Storage Length Of Each Of The Following Db2 Data Types:

DATE, TIME, TIMESTAMP and its photograph clause in COBOL. DATE: 4bytes DATE: PIC X(10) TIME: 3bytes TIME PIC X(08) TIMESTAMP: 10bytes TIMESTAMP: PIC X(26)