Deutsche Bank Interview Questions and Answers

Q1. What is the difference between a HashMap, a ConcurrentHashMap, and a synchronized HashMap?
Ans. 
HashMap is not thread-safe, ConcurrentHashMap allows concurrent access, synchronized HashMap uses explicit synchronization.
• HashMap is not thread-safe and can lead to ConcurrentModificationException if accessed by multiple threads simultaneously.

• ConcurrentHashMap allows concurrent access by multiple threads without the need for external synchronization.

• Synchronized HashMap uses explicit synchronization to make it thread...read more
Answered by AI
Add your answer
Q2. What is a lambda expression, and how does it relate to functional interfaces? Could you provide an example?
Ans. 
A lambda expression is a concise way to represent an anonymous function, often used with functional interfaces in Java.
• Lambda expressions provide a way to pass functionality as an argument to a method.

• Functional interfaces are interfaces with a single abstract method, which can be implemented using lambda expressions.

• Example: (x, y) -> x + y is a lambda expression that takes two parameters and returns their sum.
Answered by AI
Add your answer

Q1. Union vs unionByName, RDD vs Dataframe, spark internals, jobs, stages, tasks, catalyst optmizer. The interviewer panel were not very clear on asking questions. Even after asking to reframe they were not ab...read more
Add your answer
Q2. Schema evolution program in scala
Ans. 
Schema evolution in Scala allows for changes in data structure without breaking compatibility with existing data.
• Use Avro or Parquet formats for schema evolution in big data applications.

• Define a base schema and use optional fields for new data attributes.

• Example: Adding a new field 'age' to a user schema without affecting existing records.

• Leverage libraries like Apache Spark for handling schema evolution in data proce...read more
Answered by AI
Add your answer

Array questions were asked of medium level

Questions on linkedlist, trees, graphs were asked

Q1. Projects based question
Add your answer
Q2. Why join us like hr questions
Add your answer

Q1. Na..... Don't want to share questions
Add your answer
Q2. Na., Don't want to share questions
Add your answer

It was data structures and algorithm

Q1. What is friend function
Add your answer
Q2. Basic definitions of oops
Ans. 
Object-Oriented Programming (OOP) is a programming paradigm based on the concept of objects, which can contain data and methods.
• Encapsulation: Bundling data and methods that operate on the data within one unit (e.g., a class).

• Inheritance: Mechanism to create a new class using properties and methods of an existing class (e.g., a 'Dog' class inheriting from an 'Animal' class).

• Polymorphism: Ability to present the same int...read more
Answered by AI
Add your answer

Q1. Basics about the jobs and JD
Add your answer

Q1. Interview with Director
Add your answer

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...read more
Answered by AI
Add your answer
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
Answered by AI
Add your answer
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
Answered by AI
View 1 more answer
Q4. Inner Join Outer Join Left Join , String ,Unstring , Inspect all questions
Add your answer
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
Answered by AI
Add your answer
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 ...read more
Answered by AI
Add your answer
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.
Answered by AI
Add your answer
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.
Answered by AI
Add your answer
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
Answered by AI
View 1 more answer
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
Answered by AI
Add your answer