Interview Questions

The supply curve slopes upward because for reflecting the higher price needed to cover the higher marginal cost of production. 

Customer Information Control System (CICS) is an online transaction processing monitor from IBM that acts as an interface between the operating system and application programs to provide rapid high-volume online transaction processing.

Example:

"I have several awesome  achievements in my career. Probably the most awesome achievements were the delivery of the most recent version replace update to one of our core products for customer bills. This was a 1-year project and I was one of 9 team members. What made it more for me was that my role expanded from being one of the tech team individuals to taking the lead on building the mobile makings of the product. In order to deliver this aspect of the product, I pulled in 3 new project resources with new specific skills in each of the mobile technology floors we targeted and cross-trained all project resources to support each floor. In the last, our team delivered the product on time and have received numerous accolades, both external and internal. The mobile component was particularly  identified to be world class and distributed the product at its release. Our CEO spent time showing the mobile components to the industry and press and it has since met with superb  reviews. Would you like to see the Android version of the product?"

PCT (Program Control Table) - Defines each transaction containing a list of valid transaction identifiers (transid) where each transaction is paired with its matching program.

PPT (Program Processing Table) - Contains a list of valid program names and maps and whether a current version is in the CICS region or needs to be brought in as a new copy.

FCT (File Control Table) - Contains a list of files known to CICS, the dataset name and status (closed/open, enable/disabled)

TCT (Terminal Control Table)- A list of the terminals known to CICS.

DB2 use the multiple indexes to satisfy multiple predicates in a SELECT statement that are joined by an AND or OR.

In a correlated query, the outer query is related to the inner query. This means one or more columns in the outer query are referenced. It’s used when the outer queries value is being used by inner query. For example, we need to find which employee had more perks in the current month than they did in the previous month. The correlated subquery is executed for each row of perks information in the parent query to first determine what the perks were for each employee in the previous month. This data, in turn, is compared to perks for each employee in the current month, and only those employees whose perks in the current month were greater that their previous month's perks are returned.