DRA Global Interview Questions and Answers

Q1. Introduce yourself. Roles and Projects you were part of.
Add your answer
Q2. SQL joins, CTEs, Snowflake
Add your answer
Q3. Python libraries, data cleaning techniques
Add your answer

Q1. What improvements to interfaces were introduced in Java 8 that were missing in Java 7, specifically regarding static and default methods?
Add your answer
Q2. Explain internal working of HashMap ? How to synchronize it ?
Add your answer
Q3. Given a list of employees with their ratings, how can you sort the employees based on their ratings using the Java 8 Streaming API?
Add your answer
Q4. Will the program compile if the parent class throws a runtime exception while the child class throws an arithmetic exception?
Add your answer
Q5. In a Spring Boot application with two databases, how can you configure JDBC to specify which database to use?
Add your answer
Q6. How to use a jetty server in your spring boot application ?
Add your answer
Q7. Difference between @RequestParam and @PathVariable ?
Add your answer
Q8. How would you handle a scenario where one microservice is awaiting a response from another microservice that is taking an extended time to respond?
Add your answer

There are two main sections: foundation and advanced. The foundation section consists of three subsections: quantitative, reasoning, and verbal. If you pass the foundation section but do not clear the advanced section, you will be considered for either the ninja role or the digital role during the interview process. The advanced section includes advanced aptitude questions and two coding questions.

Q1. Can you provide an introduction about yourself?
Add your answer
Q2. 3 to 4 questions based on database
Add your answer
Q3. 2 easy coding questions
Add your answer
Q4. Questions based on technology that I knew
Add your answer
Q5. Situation based questions
Add your answer

Q1. Are you aware about process industry ?
Add your answer
Q2. Tell me about design principles
Add your answer

Q1. What is difference between Dependency Inversion & Dependency Injection ?
Add your answer
Q2. How do you push the data from server to client
Add your answer

English, Quant & Reasoning- 3 section, each section 15 que, Total 45 minutes & 45 questions, cut off for each section

Q1. Java What is JVM,JRE,JDK? what is the difference between class and instance variable in java? what is string Pool? write a code in java(prefer a good standard question) Web development if you have inter...read more
Ans. 
To build a web application, I would use a combination of front-end technologies like HTML, CSS, and JavaScript, along with back-end technologies like Node.js and MongoDB.
• Use HTML for structuring the content of the web pages

• Use CSS for styling the web pages and making them visually appealing

• Use JavaScript for adding interactivity to the web pages and handling user input

• Use Node.js for server-side scripting and handling ...read more
Answered by AI
Add your answer
Q2. If you have azure certification what is azure, what is Azure Blob Storage, What is ARM, what is horizontal Scaling?
Ans. 
Azure is a cloud computing platform by Microsoft. Azure Blob Storage is a service for storing large amounts of unstructured data. ARM stands for Azure Resource Manager, used for managing resources in Azure. Horizontal scaling is increasing the number of instances of a service to distribute load.
• Azure is a cloud computing platform by Microsoft

• Azure Blob Storage is a service for storing large amounts of unstructured data

• ...read more
Answered by AI
Add your answer

Q1. Why cse? explain a project (they might ask about a project in your resume)
Add your answer
Q2. How you solved the problems that you have faced while working on projects?
Ans. 
I approach problems by breaking them down into smaller parts, analyzing root causes, seeking input from team members, and implementing solutions systematically.
• Identify the root cause of the problem

• Break down the problem into smaller parts

• Seek input from team members for different perspectives

• Implement solutions systematically

• Learn from the experience to prevent similar issues in the future
Answered by AI
Add your answer

Q1. Introduction Family Background Do you have any placement/internship offers in your hand? if so, why Ericsson At last, they will tell you about stipend, role
Ans. 
Yes, I have internship offers from Ericsson due to their reputation for innovation and cutting-edge technology.
• I have received internship offers from Ericsson because of their reputation for innovation and cutting-edge technology.

• I am excited about the opportunity to work with a global leader in telecommunications.

• I believe that interning at Ericsson will provide me with valuable experience and skills that will benefit
Answered by AI
Add your answer

The Aptitude Test session accesses mathematical and logical reasoning abilities

Q1. What is Vlookup
Ans. 
Vlookup is a function in Excel used to search for a value in a table and return a corresponding value from another column.
• Vlookup stands for 'Vertical Lookup'

• It is commonly used in Excel to search for a value in the leftmost column of a table and return a value in the same row from a specified column

• Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searc...read more
Answered by AI
Add your answer
Q2. Some IF else Question in Excel
Add your answer
Q3. What does your day in your previous organization look like?
Ans. 
My day in my previous organization involved analyzing large datasets, creating reports, and presenting findings to stakeholders.
• Reviewing and cleaning large datasets to ensure accuracy

• Creating visualizations and reports to communicate insights

• Collaborating with team members to identify trends and patterns

• Presenting findings to stakeholders in meetings or presentations
Answered by AI
Add your answer
Q4. Could you share the technical skills you possess?
Ans. 
I possess strong technical skills in data analysis, including proficiency in programming languages, statistical analysis, and data visualization tools.
• Proficient in programming languages such as Python, R, SQL

• Skilled in statistical analysis and data modeling techniques

• Experience with data visualization tools like Tableau, Power BI

• Knowledge of machine learning algorithms and techniques
Answered by AI
Add your answer
Q5. Can you explain what a Pivot Table is?
Ans. 
A Pivot Table is a data summarization tool used in spreadsheet programs to analyze, summarize, and present data in a tabular format.
• Pivot tables allow users to reorganize and summarize selected columns and rows of data to obtain desired insights.

• Users can easily group and filter data, perform calculations, and create visualizations using pivot tables.

• Pivot tables are commonly used in Excel and other spreadsheet program...read more
Answered by AI
Add your answer
Q6. Find the Highest-paid employee in each department along with their salary and department name.
Ans. 
To find the highest-paid employee in each department, we need to group employees by department and then select the employee with the highest salary in each group.
• Group employees by department

• Find the employee with the highest salary in each group

• Retrieve the employee's name, salary, and department name
Answered by AI
Add your answer

Topics - mcq of algorithms, networking, dbms

Q1. Based on resume
Add your answer
Q2. Questions on linked list, tree,
Add your answer

Q1. About how you approach a problem
Add your answer
Q2. Managerial questions on situations
Add your answer

Q1. Basic hr questions
Add your answer

It was a coding round interview along with interviewer via Virtual mode. I was given 2 coding questions on HackerRank for the interview:

1. one was an easy problem on counting minimum replacements.
2. "pat is an ordinary kid who works hard to be a great runner...." this was a challenging problem (which I managed to solve).
3. I was asked some basic Python questions, as the role was for a Python Developer.

Q1. LLD for Parking Lot
Add your answer
Q2. Which database are you going to use for Parking lot and Why ?
Ans. 
I would use a relational database like MySQL for the Parking lot as it provides structured data storage and supports complex queries.
• Relational databases like MySQL offer structured data storage for parking lot information

• Supports complex queries for managing parking lot data efficiently

• Ability to handle large amounts of data and transactions

• Provides data integrity and security features

• Can easily integrate with other s
Answered by AI
Add your answer
Q3. Questions related to OOPs
Add your answer
Q4. Questions related to Multi Threading
Add your answer
Q5. Questions related to Projects
Add your answer

Q1. I hate this since i was informed that this round was a technical.
Add your answer
Q2. Usual Mangerial questions, Project Related, etc
Add your answer