OpenXcell Technolabs Senior Software Engineer Interview Questions and Answers

Q1. Basic to medium questions related to DotNet Core MVC, SQL Server, etc
Add your answer

Q1. Completely unprofessional behavior of the interviewer. - No Introduction Direct start asking questions. - Asking too many misleading questions (First ask what you worked on, then ask did you heard about th...read more
Add your answer

Q1. Go Lang related questions
Add your answer
Q2. System architecture
Add your answer

Q1. About the project. and asked what i did in project. how to create schema in pyspark. what is ADE. what are the difficulties i faced in project. what is spark submit command how we write sparksubmit command...read more
Add your answer
Q2. No of occurrences of letter in a string.
Ans. 
Count occurrences of a letter in a string.
• Iterate through each character in the string and count occurrences of the specified letter.

• Use a hashmap to store the count of each letter.

• Handle both uppercase and lowercase letters to ensure accurate counting.
Answered by AI
Add your answer

Q1. Deep Technical Questions
Add your answer
Q2. Problem solving and usecases
Add your answer

Q1. Usecase based questions
Add your answer

Q1. Data structure question asked
Add your answer

I was asked t solve 2 coding questions got 20 minutes for each, both were on DS and Algo moderate problems. 1 on trees and second on linked list.

Q1. System design round where i was asked to design a parking lot followed by few DB questions
Add your answer

Q1. Then there was a UI round where i had to answer few Typescript questions and then was given a case study which i had t solve and propose a UI/UX solution.
Add your answer

Q1. What is dependency injection in laravel
Ans. 
Dependency injection in Laravel is a technique to manage class dependencies and improve code flexibility.
• Dependency injection allows for easier testing and maintenance of code.

• It involves passing dependencies to a class through its constructor or method parameters.

• Laravel's container class manages the dependencies and resolves them when needed.

• Example: injecting a database connection into a repository class.

• Can also us...read more
Answered by AI
View 1 more answer
Q2. How do you find the second largest number in a coulmn in mySQL
Ans. 
To find the second largest number in a column in MySQL, you can use the ORDER BY and LIMIT clauses.
• Write a SELECT statement to retrieve the column values in descending order using ORDER BY.

• Use the LIMIT clause to limit the result set to the second row.

• The value in the second row will be the second largest number in the column.
Answered by AI
View 1 more answer

Q1. What do you know about magic Edtech
Ans. 
Magic Edtech is an innovative educational technology company.
• Magic Edtech develops interactive learning platforms and tools.

• They use advanced technologies like AI, AR, and VR to enhance the learning experience.

• Their products include virtual classrooms, adaptive learning systems, and educational games.

• Magic Edtech focuses on personalized learning and data-driven insights.

• They collaborate with schools, universities, and
Answered by AI
View 1 more answer
Q2. What was the most challenging task you faced and how you overcame it
Add your answer

Q1. What is CSS Sprite
Ans. 
CSS Sprite is a technique used to combine multiple images into a single image to reduce the number of server requests.
• CSS Sprite helps in reducing loading time by reducing the number of HTTP requests.

• It involves combining multiple images into one larger image and then using CSS to display only the portion of the image needed.

• This technique is commonly used for icons, buttons, and other small images on websites.

• By using...read more
Answered by AI
Add your answer
Q2. Object Oriented Programming
Add your answer