InterviewSolution
Saved Bookmarks
InterviewSolution
This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
What Is The Physical Storage Length Of Each Of The Following Db2 Data Types:date, Time, Timestamp? |
|
Answer» DATE: 4bytes TIME: 3bytes DATE: 4bytes TIME: 3bytes TIMESTAMP: 10bytes |
|
| 2. |
Give The Cobol Definition Of A Varchar Field. |
|
Answer» A VARCHAR column REMARKS WOULD be defined as follows: 10 REMARKS. 49 REMARKS-LEN PIC S9(4) USAGE COMP. 49 REMARKS-TEXT PIC X(1920). A VARCHAR column REMARKS would be defined as follows: 10 REMARKS. 49 REMARKS-LEN PIC S9(4) USAGE COMP. 49 REMARKS-TEXT PIC X(1920). |
|
| 3. |
How Do You Leave The Cursor Open After Issuing A Commit? |
|
Answer» Use WITH HOLD option in DECLARE CURSOR STATEMENT. But, it has not EFFECT in psuedo-conversational CICS programs. Use WITH HOLD option in DECLARE CURSOR statement. But, it has not effect in psuedo-conversational CICS programs. |
|
| 4. |
Can You Have More Than One Cursor Open At Any One Time In A Program ? |
|
Answer» Yes. Yes. |
|
| 5. |
Explain About Dbrm ? |
|
Answer» DBRM stands for Database Request Module and is a component inside DB2, which is created by the pre compiler of DB2. This is a module that consists of SQL SOURCE statements that GET extracted out of the APPLICATION PROGRAM. DBRMs form inputs that are helpful in the binding process. DBRM stands for Database Request Module and is a component inside DB2, which is created by the pre compiler of DB2. This is a module that consists of SQL source statements that get extracted out of the application program. DBRMs form inputs that are helpful in the binding process. |
|
| 6. |
Define Clustering Index ? |
|
Answer» Clustering INDEX is a type of index, which locates the table rows and DETERMINES how to GROUP the rows together in the tablespace. Clustering index is a type of index, which locates the table rows and determines how to group the rows together in the tablespace. |
|
| 7. |
List Out The Buffer Pools In Db2 ? |
|
Answer» There are FOUR BUFFER POOLS in DB2 and they are
There are four buffer pools in DB2 and they are |
|
| 8. |
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-compile time, the table or view descriptions are then used to check the VALIDITY of SQL statements. Declaration Generator is a facility that is used to form SQL statements that describes a table or view. At pre-compile time, the table or view descriptions are then used to check the validity of SQL statements. |
|
| 9. |
Explain The Function Of Data Manager ? |
|
Answer» The physical DATABASE is MANAGED by the DB2 COMPONENT called Data MANAGER. It invokes other system COMPONENTS to perform logging, locking etc. The physical database is managed by the DB2 component called Data manager. It invokes other system components to perform logging, locking etc. |
|