Ericsson Project Manager-IT/Software Interview Questions and Answers

Q1. Basic techno managerial questions on tech you worked on work, interests, challenges you faced. Was fairly short.
Add your answer

Initially had a string based coding problem. Then was asked technical questions and then had a small break before doing system design with same interviewer for building book my show system and db schema.

Q1. Had a discussion with hiring manager on expectations, salary and growth.
Add your answer

Q1. Sql related ques mege into, rank,dense rank,queries of joins etc.
Add your answer
Q2. Java 8 related ques optional and stream
Add your answer

Q1. What is different between Mysql Vs sql ?
Ans. 
MySQL is a specific implementation of SQL, which is a standardized language for managing databases.
• MySQL is a specific relational database management system (RDBMS) that uses SQL as its query language.

• SQL (Structured Query Language) is a standardized language for managing databases, used by various RDBMS like MySQL, Oracle, and SQL Server.

• MySQL is open-source and free to use, while some other RDBMS like Oracle may requ...read more
Answered by AI
Add your answer
Q2. What abstraction and interface in java?
Ans. 
Abstraction and interface are key concepts in Java for achieving abstraction and defining contracts for classes.
• Abstraction in Java is achieved using abstract classes and interfaces.

• Abstract classes can have both abstract and concrete methods, while interfaces can only have abstract methods.

• Interfaces define contracts that classes must implement, allowing for polymorphism and loose coupling.

• Example: interface Shape { v...read more
Answered by AI
Add your answer
Q3. What is mean by JSP?
Ans. 
JSP stands for JavaServer Pages, a technology used for creating dynamic web pages.
• JSP allows embedding Java code in HTML pages

• It simplifies the process of creating dynamic web content

• JSP files are compiled into servlets by the server for execution
Answered by AI
Add your answer

Q1. How to optimise fetching 1 lakh entries from db
Ans. 
Use pagination, indexing, caching, and query optimization to fetch 1 lakh entries efficiently from the database.
• Implement pagination to fetch data in smaller chunks

• Create indexes on columns frequently used in queries

• Use caching to store frequently accessed data

• Optimize queries by avoiding unnecessary joins and using appropriate indexes

• Consider using database-specific optimizations like query hints or stored procedures
Answered by AI
Add your answer

Q1. Reverse a linked list.
Add your answer
Q2. Merge sort on a array/
Add your answer

Easy-medium level and it included two coding questions and some technical questions

Q1. How are structures and classes stored?
Ans. 
Structures and classes are stored in memory as a combination of data members and member functions.
• Structures and classes are stored in memory as a combination of data members and member functions.

• Data members of a structure or class are stored in contiguous memory locations.

• Member functions of a class are stored separately in memory and are shared among all instances of the class.

• Pointers to member functions are used t...read more
Answered by AI
Add your answer
Q2. What is final and finalize?
Ans. 
final is a keyword in Java used to restrict inheritance, overriding, and modification. finalize is a method used for cleanup operations before an object is garbage collected.
• final keyword is used to declare constants, prevent inheritance by marking a class as final, and prevent method overriding by marking a method as final

• finalize method is called by the garbage collector before an object is destroyed

• Example: final in...read more
Answered by AI
Add your answer

Q1. Introduction call and experience matching
Add your answer

Q1. Docker and web development questions
Add your answer

Queue question - create queue from array

Q1. Working structure preference
Add your answer
Q2. Salary preference
Add your answer
Q3. No more questions
Add your answer