Answer / Mahendra Singh

Binding a COBOL module to a specific job in COBOL involves defining the EXEC SQL SECTIONs within your COBOL program and creating an external program that can be linked with the COBOL program using a preprocessor such as SQL/COBOL. Here's a step-by-step guide on how to do it: 1. Use the COBOL preprocessor (SQL/COBOL) to compile your COBOL source code, which includes EXEC SQL SECTIONS. 2. Create an external program using a language like C or Fortran that connects to the database and initializes necessary parameters such as connection details, job name, etc. 3. Link both the compiled COBOL object file and the external program to create a new executable. 4. Finally, run the newly created executable with appropriate arguments to specify the job name.

How would you go about increasing the buffer cache hit ratio?

2 Answers  

---

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers  

---

what is the differnce between process and thread ?

1 Answers   IBM,

---

the process of adding a cpu in sql server is called..?

2 Answers   TCS,

---

How do you open a cluster administrator? : sql server DBA

1 Answers  

---

Can you redefine a table online?

1 Answers   Oracle,

---

How do you resize a data file?

2 Answers  

---

what is incremental checkpoint?

1 Answers   CTS,

---

How would you force a log switch?

4 Answers  

---

Explain the difference between a data block, an extent and a segment.

2 Answers  

---

What is blocking and how would you troubleshoot it?

1 Answers  

---

How would you determine the time zone under which a database was operating?

2 Answers  

---