Accenture DB2 Interview Questions
How Would You Retrieve Rows From A Db2 Table In Embedded Sql?
Can obtain it by both by utilizing the one row SELECT statements, or by utilizing the CURSOR?
What Are The Alternate Ways Available To You To Retrieve A Row From A Table In Embedded Sql Apart From Cursor?
By utilizing Single row SELECT.
How Can You Specify And Use A Cursor In A Cobol Program?
Try to make use of DECLARE CURSOR assertion both in working storage or in process division, to specify the SELECT assertion Then use OPEN, FETCH rows in a loop and eventually CLOSE.
Can You Tell Me What Will Happen When You Say Open Cursor?
If there may be an ORDER BY clause, rows are fetched, sorted and made accessible for the FETCH assertion Other smart merely the cursor is positioned on the primary row.
Is It Possible More Than One Cursor Open At Any One Time In A Program?
Yes, we are able to open multiple cursor at a time.
Can You Tell If Declare Cursor Is Executable?
No, DECLARE CURSOR just isn’t executable.
In Brief How Do You Leave The Cursor Open After Issuing A Commit?
Use WITH HOLD possibility in DECLARE CURSOR assertion, it has not impact in psuedo-conversational CICS packages.
When You Do A Database Commit, Is The Cursor Closed In Db2?
Yes, the cursor will probably be closed.
Describe The Cobol Definition Of A Varchar Field?
A VARCHAR column REMARKS can be outlined as follows: 10 REMARKS 49 REMARKS-LEN PIC S9(4) USAGE COMP 49 REMARKS-TEXT PIC X(1920)
Can You Tell Me What Is The Physical Storage Length Of Each Of The Following Db2 Data Types:
DATE, TIME, TIMESTAMP and its image clause in COBOL. DATE: 4bytes DATE: PIC X(10) TIME: 3bytes TIME PIC X(08) TIMESTAMP: 10bytes TIMESTAMP: PIC X(26)
What Are The Contents Of A Dclgen In Db2?
EXEC SQL DECLARE TABLE assertion which supplies the format of the desk/view when it comes to DB2 datatypes. A number language copy ebook that provides the host variable definitions for the column Names.
In Db2, Is It Always Mandatory To Use Dclgen? If Not, Why Would You Use It At All?
It just isn’t all the time necessary to make use of DCLGEN Using DCLGEN, helps detect wrongly spelt column names and so forth through the pre- compile stage itself ( due to the DECLARE TABLE ) DCLGEN being a software, would generate correct host variable definitions for the desk decreasing probabilities of error.
Is Is Always Mandatory To Use Declare Table In Dclgen ? Can You Tell Why It Used?
It not necessary to have DECLARE TABLE assertion in DCLGEN This is utilized by the pre-compiler to validate the table-name, view-name, column title and so forth, throughout pre-compile.
In Brief How Is A Typical Db2 Batch Program Gets Executed ?
You ought to Use DSN utility to run a DB2 batch program from native TSO An instance is proven: DSN SYSTEM(DSP3) RUN PROGRAM(EDD470BD) PLAN(EDD470BD) LIB(‘ED01TOBJLOADLIB’) END Use IKJEFT01 utility program to run the above DSN command in a JCL
List Some Fields From Sqlca.?
SQLCODE, SQLERRM, SQLERRD
Can You Tell Me How Can You Find Out The # Of Rows Updated After An Update Statement?
You must verify the worth saved in SQLERRD(3)
Can You Tell What Do You Need To Do Before You Do Explain?
You have to make sure that the PLAN_TABLE is created underneath the AUTHID
Can You Tell Where Is The Output Of Explain Stored?
In person id PLAN_TABLE
What Does It Mean – Explain Has Output With Matchcols = 0?
A non matching index scan if ACCESSTYPE = I
How Can You Do The Explain Of A Dynamic Sql Statement?
Use SPUFI or MF to EXPLAIN the dynamic SQL assertion
Include EXPLAIN command within the embedded dynamic SQL statements
What Are The Various Isolation Levels Possible ?
The isolation ranges are CS: Cursor Stability RR: Repeatable Read
Differentiate Between Cs And Rr Isolation Levels?the place Do You Specify Them?
CS: Releases the lock on a web page after use
RR: Retains all locks acquired until finish of transaction. ISOLATION LEVEL is a parameter for the bind course of
When Do You Specify The Isolation Level?
During the BIND course of ISOLATION ( CS/RR )
Name The Various Locking Levels Available?
PAGE, TABLE, TABLESPACE
Explain In Brief How Does Db2 Determine What Lock-size To Use?
- Based on the lock-size given whereas creating the tablespace
- Programmer can direct the DB2 what lock-size to make use of
- If lock-size ANY is specified, DB2 normally choses a lock-size of PAGE
Explain What Are The Disadvantages Of Page Level Lock In Db2?
The predominant drawback is the excessive useful resource utilization if massive updates are to be executed.