Interview Questions.

Question 1. How Do You Select A Row Using Indexes In Db2?

Answer :

Specify the indexed columns inside the WHERE clause of db2 query.

Question 2. How Do You Find The Maximum Value In A Column In Db2?

Answer :

Use SELECT MAX(...) .. In db2 query

IBM-REXX Interview Questions
Question 3. How Do You Retrieve The First 5 Characters Of Firstname Column Of Db2 Table Emp ?

Answer :

SQL Query : SELECT SUBSTR(FIRSTNAME,1,five) FROM EMP;

Question four. What Are Aggregate Functions?

Answer :

Bulit-in mathematical capabilities to be used in SELECT clause.

IBM-REXX Tutorial
Question five. Can You Use Max On A Char Column?

Answer :

YES.

IBM-CICS Interview Questions
Question 6. My Sql Statement Select Avg(profits) From Emp Yields Inaccurate Results. Why?

Answer :

Because SALARY isn't always declared to have NULLs and the employees for whom the salary is not regarded also are counted.

Question 7. What Is The Use Of Value Function?

Answer :

Avoid -ve SQLCODEs through dealing with nulls and zeroes in computations
Substitute a numeric price for any nulls used in computation
IBM-CICS Tutorial JCL Interview Questions
Question 8. Explain The Function Of Data Manager ?

Answer :

The bodily database is controlled via the DB2 factor known as Data supervisor. It invokes different system additives to perform logging, locking and so forth.

Question 9. What Is A Storage Group (stogroup)?

Answer :

STOGROUP is a named collection of DASD volumes, which is to be utilized by index spaces and table areas of the database.

IBM DB2 Interview Questions
Question 10. Define Predicate?

Answer :

Predicate is an element of a seek condition. It expresses or implies a search condition.

IBM DB2 Tutorial
Question 11. Define Declaration Generator (dclgen) ?

Answer :

Declaration Generator is a facility that is used to form SQL statements that describes a table or view. At pre-assemble time, the table or view descriptions are then used to test the validity of SQL statements.

COBOL Interview Questions
Question 12. List Out The Buffer Pools In Db2 ?

Answer :

There are four buffer swimming pools in DB2 and they're

         BP0
        BP1
        BP2
        BP32
IBM-REXX Interview Questions
Question thirteen. Define Clustering Index ?

Answer :

Clustering index is a sort of index, which locates the table rows and determines how to institution the rows collectively inside the tablespace.

COBOL Tutorial
Question 14. What Is Concurrency?

Answer :

More than one DB2 software procedure can get entry to the equal statistics on the equal time, is called concurrency. However, problems can occur such as, lost updates get right of entry to to unrepeatable reads and uncommitted records.

Question 15. Explain The Function Done By Data Manager?

Answer :

Data supervisor can be taken into consideration as a element this is able to coping with the databases which can be bodily gift and is able to invoking different components associated with the machine for acting functionalities like logging, locking and in performing other I/O operations.

MySQL Interview Questions
Question sixteen. Explain About Dbrm ?

Answer :

DBRM stands for Database Request Module and is part internal DB2, that is created by using the pre compiler of DB2. This is a module that includes SQL supply statements that get extracted out of the software program. DBRMs shape inputs which might be useful within the binding system.

MySQL Tutorial
Question 17. Define Data Page?

Answer :

Data page may be taken into consideration as a unit that is able to retrieving information from the database. The database from which the records can be retrieved is in the shape of four kilobytes or 32 kilobytes. The form wherein facts is retrieved depends at the manner the table is defined inside the database. Data page additionally contains information regarding the catalog or user which can be part of the database.

IBM-JCL Interview Questions
Question 18. Explain About Rct?

Answer :

RCT is elevated as Resource – Control Table and is described in the DB2/CICS location. This is the aspect that accommodates of features that are amassed thru macros of DSNCRCT. RCT fits with the transaction ID that of CICS, with the authorization ID that of DB2. This need to additionally be matched with plan ID.

IBM-CICS Interview Questions
Question 19. How Can Tablespace Be Moved To Another Dasd Volume That Is Allocated For That Tablespace?

Answer :

Tablespace which you are using is allotted most effective to STOGROUP, then you could enter the command ALTER STOGROUP for including in addition to deleting volume. REORG TABLESPACE and RECOVER TABLESPACE are statements that are useful in creating new STOGROUP which can point toward the brand new extent. ALTER tablespace and REORG and RECOVER are statements used for altering and improving the tablespace allocated in the reminiscence.

IBM-JCL Tutorial
Question 20. What Is The Information Associated With Sysibm.Syslinks Table?

Answer :

This is the table that incorporates data at the hyperlinks that exists between the tables created thru referential constraints.

Oracle 11g Interview Questions
Question 21. Explain In Detail About Buffer Manager And Its Functionalities?

Answer :

Buffer manager can be taken into consideration as the thing inner DB2 that helps in transferring records among digital in addition to outside medium. The buffer supervisor reduces the quantity of physical input as well as output operations which are actually done by using utilising buffering techniques which can be noticeably state-of-the-art.

Question 22. Explain About Cursor Stability?

Answer :

Cursor stability is the property that tells the DB2 that the values of database which are read with the aid of using this software gets included whilst the facts is used.

Oracle 11g Tutorial
Question 23. How Do You Specify And Use A Cursor In A Cobol Program?

Answer :

Use DECLARE CURSOR statement either in operating storage or in method division(before open cursor), to specify the SELECT announcement. Then use OPEN, FETCH rows in a loop and eventually CLOSE.

System Administration Interview Questions
Question 24. What Happens When You Say Open Cursor?

Answer :

If there's an ORDER BY clause, rows are fetched, taken care of and made to be had for the FETCH statement. Other smart certainly the cursor is positioned on the primary row.

JCL Interview Questions
Question 25. Is Declare Cursor Executable?

Answer :

No.

IBM Mainframe Tutorial
Question 26. Can You Have More Than One Cursor Open At Any One Time In A Program ?

Answer :

Yes.

IBM-JCL&VSAM Interview Questions
Question 27. How Do You Leave The Cursor Open After Issuing A Commit?

Answer :

Use WITH HOLD option in DECLARE CURSOR assertion. But, it has now not impact in psuedo-conversational CICS packages.

IBM DB2 Interview Questions
Question 28. Give The Cobol Definition Of A Varchar Field.

Answer :

A VARCHAR column REMARKS could be defined as follows:

10 REMARKS.

49 REMARKS-LEN PIC S9(four) USAGE COMP.

49 REMARKS-TEXT PIC X(1920).

Question 29. What Is The Physical Storage Length Of Each Of The Following Db2 Data Types:date, Time, Timestamp?

Answer :

DATE: 4bytes

TIME: 3bytes

TIMESTAMP: 10bytes

IBM Mainframe Interview Questions