Answer / Adesh Kumar

Data can be retrieved from multiple tables using a single SQL statement through JOIN operations, which combine rows from two or more tables based on a related column between them.

in options (main) , what is meaning of main . if u not used main what will happen? After compiling, os will not understand where to load and execute from

1 Answers   AppLabs,

---

Explain lock contention?

1 Answers  

---

How to find all duplicate records?

1 Answers  

---

Can you explain create an empty file by using sort?

1 Answers  

---

how to get last 100 records in file-aid?

1 Answers   Syntel,

---

State all the file open modes?

1 Answers  

---

how do we do unit testing in mainfrmae. explain step-wise.

2 Answers   IBM, JBK,

---

Explain host variables?

1 Answers  

---

subscripting can be said as A) subscripting enables us to write a move compact code in the procedure division. B) subscripting enables us to refer to any element of a table by the same data name with the facility of identifying a particular element through the values of subscript. C) Subscripting reduces the no of entries to be included in the data division D) subscripting enables us to use loops in the procedure division

1 Answers   Accenture,

---

Explain identify whether a call statement is a static or dynamic call?

1 Answers  

---

If DB2 query returns in null value, how do you work with it in PL/1?

1 Answers   IBM,

---

Why we use  "OCCUR"  with multiple occurence DS(Data Structure)?

1 Answers  

---