Deutsche Bank
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Clear (1)
To increase performance of a COBOL program using multiple cursors, consider optimizing the SQL queries, reducing the number of cursors, and using efficient data structures.
Optimize SQL queries to retrieve only necessary data
Reduce the number of cursors by combining multiple queries into one
Use efficient data structures like arrays or tables to store and manipulate data
Avoid unnecessary looping and processing within cur
To resolve division by zero error, check for zero before performing division operation.
Check if the denominator is zero before performing division operation
Handle the error by displaying a message or returning a default value
Use conditional statements or try-catch blocks to prevent division by zero
Abend the program by moving error code to Return code
To abend the program, set the return code to a non-zero value indicating an error
This can be done using a conditional statement to check for errors and then setting the return code accordingly
For example, in COBOL, you can use the ACCEPT statement to move the error code to the return code
To check if a file is empty, you can use file size or read the file and check for any content.
Check the file size using system functions like stat() or file length property
Read the file and check if there is any content present
Use file handling functions to determine if the file is empty
To read a file with different record structures, use a combination of file parsing techniques and data manipulation.
Identify the record structure of each section in the file
Use conditional logic to parse each record based on its structure
Implement error handling for unexpected record structures
Utilize tools like regular expressions or custom parsing functions
Consider using libraries or frameworks that support flexible
No, SQLCA EXEC SQL is not mandatory for Mainframe Developer.
SQLCA EXEC SQL is not mandatory but can be used for error handling and status checking in COBOL programs.
It is used to retrieve information about the most recent SQL operation.
Developers can choose to use SQLCODE and SQLSTATE instead of SQLCA EXEC SQL.
Data from Cobol can be passed to JCL using file handling techniques like writing data to a dataset or passing parameters through PROCs.
Use file handling techniques to write data from Cobol program to a dataset that can be accessed by JCL.
Pass parameters from Cobol program to JCL using PROCs.
Use symbolic parameters in JCL to reference data from Cobol programs.
Use the COND parameter in the JCL to prevent job abend when subscript limit is reached.
Use COND parameter in JCL to check for subscript limit before executing subsequent steps
Set COND parameter to check for specific return code when subscript limit is reached
Add a condition to bypass subsequent steps if subscript limit is exceeded
To add the 10th additional record in a file using a Cobol program, you would need to read the file sequentially and write the new record at the appropriate position.
Read the file sequentially until you reach the 9th record
Write the 10th record at the current position in the file
Update the file with the new record
I was interviewed before Mar 2016.
Behavioural and culture fit
posted on 19 Apr 2020
I applied via Company Website and was interviewed in Oct 2019. There were 4 interview rounds.
HackerEarth / Hacker rank Test
Using dynamic programming to find the lowest cost for metro passes based on given days.
Create an array to store the minimum cost for each day.
Iterate through each day and calculate the minimum cost based on 1, 7, or 30 day pass.
Update the minimum cost for each day using dynamic programming.
Return the minimum cost for the total number of days needed.
I applied via Campus Placement and was interviewed in Dec 2020. There were 3 interview rounds.
Static is a keyword in Java used to create class-level variables and methods.
Static variables are shared among all instances of a class
Static methods can be called without creating an instance of the class
Static blocks are used to initialize static variables
Static import is used to import static members of a class
The program replaces consecutive same characters in a string with a single '$'.
Iterate through each character in the string
Compare the current character with the next character
If they are the same, replace the next character with '$'
Continue until the end of the string
Function overloading is having multiple functions with the same name but different parameters. Function overriding is having a derived class implement a method with the same name and parameters as a method in its base class.
Function overloading is used to provide different ways of calling a function with different parameters.
Function overriding is used to provide a specific implementation of a method in a derived class...
posted on 10 Jul 2024
LRU cache design involves maintaining a cache with limited capacity and removing the least recently used item when the cache is full.
Use a doubly linked list to maintain the order of items based on their usage.
Implement a hash map for fast access to items in the cache.
When a new item is accessed, move it to the front of the linked list to mark it as the most recently used.
When the cache is full, remove the item at the ...
posted on 13 Sep 2024
Prime numbers are numbers that are only divisible by 1 and themselves.
Start by checking if the number is less than 2, as prime numbers start from 2.
Iterate from 2 to the square root of the number and check if the number is divisible by any of these numbers.
If the number is not divisible by any number in the range, then it is a prime number.
I applied via Naukri.com and was interviewed before Jun 2023. There was 1 interview round.
Some of the top questions asked at the Deutsche Bank Mainframe Developer interview -
based on 1 interview
Interview experience
Associate
4.8k
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Analyst
3.9k
salaries
| ₹0 L/yr - ₹0 L/yr |
Assistant Vice President
3.4k
salaries
| ₹0 L/yr - ₹0 L/yr |
Analyst
2.1k
salaries
| ₹0 L/yr - ₹0 L/yr |
Financial Analyst
1k
salaries
| ₹0 L/yr - ₹0 L/yr |
Barclays
JPMorgan Chase & Co.
HDFC Bank
ICICI Bank