AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Deutsche Bank Mainframe Developer Interview Questions and Answers
6 Interview questions
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
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.
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 flex...
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
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.
Deutsche Bank Mainframe Developer Interview Experiences
1 interview found
Anonymous
(10 Questions)
- Q1. How will you increase performance of cobol program when its using number of cursors?
- Ans.
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...
- Q2. How will you resolve division by zero error Socb
- Ans.
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
- Q3. How will you abend the program? by moving error code to Return code
- Ans.
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
- Q4. Inner Join Outer Join Left Join , String ,Unstring , Inspect all questions
- Q5. How will you check if file is empty ?
- Ans.
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
- Q6. How will you read your file in different record structure ?
- Ans.
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 ...
- Q7. Is SQLCA EXEC SQL is mandatory ?
- Ans.
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.
- Q8. How will you give data from Cobol to JCL ?
- Ans.
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.
- Q9. What syntax you give in Parm parameters to not be abend job when Subscript had ended his limit?
- Ans.
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
- Q10. How you will add 10 th additional record in file using Cobol program , what is the path.
- Ans.
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
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I applied via Company Website and was interviewed before Oct 2020. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. Questions were asked based on the resume regarding the process we have worked on.
- Ans. Explain the concept, flow of the process you follow. Be well versed with AML/KYC and rules and regulatory bodies if applying for relevant job.
Interview Preparation Tips
I applied via Campus Placement
Interview Questionnaire
4 Questions
- Q1. Explain the background process that takes place during an atm transaction
- Q2. Cut cake into 8 pieces .You can use knife 3 times only
- Q3. A shot fired from a gun pointing towards a tree full of birds. All birds left except one. Why ?
- Q4. Explain projects which you made in college?
- Ans.
Developed a web-based attendance management system and a mobile app for event management.
Created a database schema and implemented CRUD operations using PHP and MySQL.
Designed the user interface using HTML, CSS, and JavaScript.
Integrated Google Maps API for location tracking in the mobile app.
Implemented push notifications using Firebase Cloud Messaging.
Collaborated with a team of four to complete the projects within t...
Interview Preparation Tips
Experience: The question paper was a mix of aptitude, programming of c++ java , sql and reasoning.
There was negative marking set for each questions.
Tips: Attempt that portion first in which you are really confident.
Dont try to attempt all questions , as negative marking plays big role.
Duration: 60 minutes
Round: Technical Interview
Experience: As Barclays is a bank , so this kind of question is obvious.
Be prepared for technical process that takes place in a usual banking domain.
Also , any type of question whether reasoning based or technical can be asked.
Tips: Be confident. Try to tell everything in a straight manner.
Round: Case Study Interview
Experience: You can put humour while answering as this shows your positivity.
There can be many reason for this like birds ia dead , bird is deaf , bird is of plastic. You can choose whatever hit into your mind.
Round: Behavioural Interview
Experience: Explaining the thing in which you already have knowledge is a plus point.
But make sure you have complete knowledge of your college project as they can ask as many questions as possible because your project is the main thing which can extend your interview time.
Skills: Common Sense, Presence Of Mind, Positive Thinking, Ability To Deliver On A Project, C Programming
College Name: UPTU
Motivation: As it is a product based company , so chances of growth is good and pay scale is better.
I applied via Campus Placement
Interview Preparation Tips
Experience: Was nice experience,should have good aptitude.
Tips: Learn aptitude more and morr
Duration: 60 minutes
Round: Group Discussion
Experience: Just speak about the topic
Tips: Do not get silent
Round: Technical Interview
Experience: iOS,C/C++
Tips: Just be confident about your answwers ansd show that you are capable to do each and everything in this world and you have quick learning capacity to grasp anything.
General Tips: C/C++,
Skills:
College Name: CDAC PUNE
Motivation: Bank more than 325 years old.
Interview Questionnaire
11 Questions
- Q1. 1st technical round
- Q2. How you will find the smallest of 4 numbers without using >.< and min function using java
- Q3. Write a code for palindrome
- Q4. Write any javascript code
- Q5. Swap two number without using temperory variable
- Q6. How you will add 2 table
- Q7. Difference between union and union all
- Q8. They provide an instance, and tell us to write a query for that
- Ans.
Crafting SQL queries requires understanding the database schema and the specific requirements of the task.
Understand the database schema: Know the tables, columns, and relationships.
Identify the requirements: Determine what data is needed based on the instance provided.
Write the SQL query: Use SELECT, JOIN, WHERE, and other clauses as necessary.
Test the query: Run the query to ensure it returns the expected results.
- Q9. Tell me about yourself
- Q10. The worst situation during your internship period
- Ans.
Being assigned a project with unrealistic deadlines and minimal guidance
Received a project with tight deadlines and unclear requirements
Struggled to meet the deadlines due to lack of guidance and support
Had to work long hours and weekends to try to complete the project
Learned the importance of clear communication and setting realistic expectations
- Q11. How you will overcome from that worst situation
Interview Preparation Tips
Experience: The question were not that much difficult. Many apti questions are easy. Technical was very easy for me.
The questions were fully based on java, c and SQL. 7 to 8 questions are from SQL. But all are straight forward questions. Other 2 sections were easy and any student who had a good sort of thinking ability can able to solve those questions.
Tips: Just refer all the basic topics in java, c and sql.
Duration: 60 minutes
Total Questions: 50
Round: Technical Interview
Experience: It was fully based on the final sem project which i was doing.
Since my project is company's employee portal, i was asked about that. They will dig into deep with respect to that project.
Tips: U should be aware of each and everything in your project which you are going to explain them. The question which they use to ask is really unpredictable.
Round: Technical Interview
Experience: This is pure technical round where i was asked the questions which is easy but takes time to think. Anyhow, i answered all these questions and get into the next round.
Tips: Logical thinking matters. Though questions look easier, sometimes we co calculate with wrong manner.
So keep calm and think in a broader manner.
Round: Technical Interview
Experience: Technical round with pure database stuffs. I was asked only few question in this. Since it was straight forward, i answered all the questions.
Round: HR Interview
Experience: Confidence really matters. Though i was not that much good in conversing, i spoke with brave and confidently which makes me to became a part of the barclays team.
General Tips: Be confident enough and answer them what you know.
Talking too much as well as taking less is also a problematic.
Skills: Logical thinking, Technical skills ( Especially about database )
College Name: MANIPAL INSTITUTE OF TECHNOLOGY, MANIPAL
Motivation: Credits should goes to my bro who motivates me to apply to this comapny.
Skills evaluated in this interview
Shubham Srivastava
Interview Preparation Tips
Experience: General aptitude consisted of quantitative questions .There were 6 questions and suggested time as 10 minutes. Questions were of easy level. Questions based on numbers,distance,time etc..Answers of general aptitude were to be written in textbox. eg ans is 4,write 4. there were no options in quant. Answers were integers an easy.
Technical comprehension involved two paragraphs and questions based on sql.
Logical analysis contained questions of logical deduction mainly.
Program tracing involved finding output of programs(mainly while loop and if else)..
Programming : There was only one question of programming(to be solved in 30 minutes). Code was given and was to be modified.Modification involved like , find out the least salary of employees,... (they used file input output and structures).
Tips: Practice basic aptitude.Concepts should be clear.
Duration: 90 minutes
Total Questions: 18
Skills: Basic C/C++, Logical Thinking, Logical Reasoning, General Aptitude
College Name: NIT Raipur
Ritika Nevatia
Interview Preparation Tips
Experience: Study data interpretation (calculator allowed) and pattern puzzles
Round: Group Discussion
Experience: Two topics (have been same case studies for past 4 years now): - Mobile app improvement - Making a business decision
Round: HR Interview
Experience: Everything depends only on HR interview
Tips: Make a list of your strengths and an example for each!
Round: Technical Interview
Experience: Short, easy and basic questions asked about projects and DS. Pretty chilled
College Name: Sardar Patel Institute of Technology
I applied via Job Portal and was interviewed before Feb 2021. There were 2 interview rounds.
(1 Question)
- Q1. I tell about my studies and previous experience
Interview Preparation Tips
I appeared for an interview in Dec 2020.
Interview Preparation Tips
Tip 1 : Master Your Data Structures and Algorithm, solving Leetcode, Geeksforgeeks, having a great solved count is not that important. Just make sure, you are comfortable.
Tip 2 : Master Your Data Structures and Algorithm, if you think, you are done, try reading more about competietive programming topics at https://cp-algorithms.com/
Tip 3 : Have at least 2 Good Project, That would be an advantage
Tip 1 : Try to complete in 1 page, without reducing the beauty. Show atleast 2 project, 2 hackathons, 1 internship, and your achivement.
Tip 2 : Be honest. Copying something from github, isn't a great idea. You can do, but please work in it. Spend 1 week reading that code, and try implementing that project by yourself, and then put into the resume.
I appeared for an interview before Sep 2020.
(2 Questions)
Round duration - 150 minutes
Round difficulty - Medium
For MCQ Round, we have 2 rounds:-
1. Logical Reasoning (Window of 4 hours)
2. Mathematical Reasoning(Window of 4 hours)
The environment was fine. They gave an option of attempting a mock test in order to familiarize us with the environment
Logical Reasoning, in which there were 12 questions, and for each question we had a time limit of 75 seconds. There was a cut-off of 40 for the next round, and people who qualified were sent an e-mail with a link to continue with the process.
Numerical Reasoning, in my opinion, was the most challenging round. The questions were in a pair of 3 in which a table/bank statement was given and 3 questions were based on that. The questions were purely based on calculations and semi-subjective. The time given for the 1st question was 90 seconds and for the rest 2 questions, 75 seconds each
For Coding Round,
120 minutes window(Test was of 90 minutes)
We have two questions
For the first question(30 Minutes)
For the second question(60 Minutes)
The tricky thing was we only had one attempt, i.e we were allowed to submit the solution only once.
- Q1.
Maximum Frequency Number Problem Statement
Given an array of integers with numbers in random order, write a program to find and return the number which appears the most frequently in the array.
If multip...
- Ans.
Find the number with the highest frequency in an array, returning the first one in case of ties.
Count Frequencies: Use a hash map to count occurrences of each number in the array.
Track First Occurrence: Store the index of the first occurrence of each number to resolve ties.
Iterate Efficiently: Loop through the array once to build the frequency map and another pass to determine the maximum frequency.
Example: For input [...
- Q2.
Mike and Mobile Problem Statement
Mike, a little boy who loves solving math problems, was playing with his mom's mobile phone. The mobile keypad includes 12 buttons: 10 digit buttons (0-9) and 2 non-digit...
- Ans.
Mike can generate unique numbers by pressing mobile keypad buttons, following specific rules for adjacent presses.
Button Press Rules: Mike can press the same button or an adjacent one after the initial press.
Initial Choices: For N=1, he can choose any of the 10 digits (0-9), resulting in 10 unique numbers.
Adjacent Button Logic: For N=2, starting from any digit, he can press the same or adjacent digits, leading to 36 co...
(1 Question)
Round duration - 40 minutes
Round difficulty - Medium
The timing was around 1 pm and the whole interview went for about 40 minutes.
The interviewer first went through my resume and asked me to introduce myself. After my introduction, he asked me about my projects mentioned in the resume. In the introduction itself, I told him that I am interested in competitive programming and preparing for ICPC. He then asked me about my preparation for ICPC. He then asked me some questions from OOPS. I was then asked 1 simple CP problem. The interviewer also asked about situation-based problems. As I previously mentioned about Competitive Programming, he asked how this will help in adding value to the company.
- Q1.
Remove Duplicates Problem Statement
You are given an array of integers. The task is to remove all duplicate elements and return the array while maintaining the order in which the elements were provided.
...
- Ans.
The task is to remove duplicates from an array while preserving the original order of elements.
Use a set to track seen elements and a list to store the result, ensuring duplicates are skipped.
Example: For input [1, 2, 2, 3, 1], the output should be [1, 2, 3].
Iterate through the array, adding elements to the result list only if they haven't been seen before.
This approach maintains the order of first occurrences of each ...
Round duration - 10 minutes
Round difficulty - Easy
In this round interviewer basically asked about my project in detail and also asked about various technologies used in that project.
Round duration - 10 minutes
Round difficulty - Easy
We were asked about family background, location of the intern, any interest in startups (as they don’t want students who they hire also work with startups side by side), etc.
Interview Preparation Tips
Tip 1 : Solve as many questions as possible
Tip 2 : Focus on Communication Skills
Tip 3 : Spend some time on resume building
Tip 4 : Give some mock interviews
Tip 5 : Read others experiences as it will give you an idea about the whole interview process
Tip 6 : Learn from failures and try not to repeat the same mistakes in the future
Tip 7 : Most importantly enjoy the process
Tip 1 : Should not exceed 1 page
Tip 2 : Put only those things which you are confident that you can answer anything
Tip 3 : Have some projects on your resume
Tip 4 : Select the template of your resume based on its readability
Tip 5 : Put things on your resume in a systematic manner(Don't create a mess)
Tip 6 : Take a look at other selected resumes as it will give an idea on what basis companies accept or reject the resumes
Skills evaluated in this interview
Deutsche Bank Interview FAQs
Some of the top questions asked at the Deutsche Bank Mainframe Developer interview -
Tell us how to improve this page.
Deutsche Bank Interviews By Designations
- Deutsche Bank Analyst Interview Questions
- Deutsche Bank Associate Interview Questions
- Deutsche Bank Senior Analyst Interview Questions
- Deutsche Bank Financial Analyst Interview Questions
- Deutsche Bank Associate Vice President Interview Questions
- Deutsche Bank KYC Analyst Interview Questions
- Deutsche Bank Assistant Vice President Interview Questions
- Deutsche Bank Software Developer Intern Interview Questions
- Show more
Interview Questions for Popular Designations
- Software Developer Interview Questions
- Software Engineer Interview Questions
- Java Developer Interview Questions
- Team Lead Interview Questions
- Web Developer Interview Questions
- Senior Software Developer Interview Questions
- Application Developer Interview Questions
- Salesforce Developer Interview Questions
- Show more
Overall Interview Experience Rating
based on 1 interview experience
Interview Questions from Similar Companies
|
Associate
5.2k
salaries
|  ₹8 L/yr - ₹33.6 L/yr |
|
Senior Analyst
4k
salaries
| ₹4 L/yr - ₹17 L/yr |
|
Assistant Vice President
3.9k
salaries
| ₹16.5 L/yr - ₹48.4 L/yr |
|
Analyst
2.2k
salaries
| ₹3 L/yr - ₹13 L/yr |
|
Vice President
938
salaries
| ₹31.4 L/yr - ₹94 L/yr |
Barclays
JPMorgan Chase & Co.
Kotak Mahindra Bank
AU Small Finance Bank
- Home >
- Interviews >
- Deutsche Bank Interview Questions
