Excellis IT Interview Questions and Answers

6 question 1 hard, 3 med, 2 easy

Q1. Rainwater PRoblem and multisource bfs
Add your answer

Q1. Lru Cache leet problem in deep
Ans. 
Implement a Least Recently Used (LRU) cache
• Use a combination of a doubly linked list and a hashmap to efficiently implement the LRU cache

• When a new element is accessed, move it to the front of the linked list and update the hashmap

• When the cache is full, remove the least recently used element from the end of the linked list and the hashmap
Answered by AI
Add your answer

Q1. Multithreading is asked in deep
Add your answer

Q1. Coalesce, SQL Order of Execution
Add your answer
Q2. Given a table with fields(id, name, salary, managerId) find out the managers who have atleast 5 reportees under him/her.
Ans. 
Use SQL query to count number of reportees for each manager and filter out those with atleast 5 reportees.
• Write a SQL query to count number of reportees for each manager using GROUP BY clause

• Add HAVING clause to filter out managers with atleast 5 reportees

• Example: SELECT managerId, COUNT(id) AS num_reportees FROM table_name GROUP BY managerId HAVING num_reportees >= 5
Answered by AI
Add your answer
Q3. How to manage large datasets in python
Ans. 
Use libraries like pandas and dask to efficiently manage large datasets in Python.
• Use pandas library for data manipulation and analysis.

• Use dask library for parallel computing and out-of-core processing.

• Optimize memory usage by loading data in chunks or using data types efficiently.

• Consider using cloud services like AWS S3 or Google BigQuery for storing and processing large datasets.
Answered by AI
Add your answer
Q4. Name few of the commonly used python libraries used by DA
Ans. 
Some commonly used Python libraries for Data Analysts are Pandas, NumPy, Matplotlib, and Scikit-learn.
• Pandas - used for data manipulation and analysis

• NumPy - used for numerical computing and working with arrays

• Matplotlib - used for data visualization

• Scikit-learn - used for machine learning and data mining
Answered by AI
Add your answer

Q1. What is the concept of a session in PHP?
Ans. 
A session in PHP is a way to store information (variables) to be used across multiple pages.
• Sessions are used to store user data on the server for later use

• Sessions are identified by a unique session ID, usually stored in a cookie

• Session data is stored on the server side, making it more secure than using cookies alone
Answered by AI
Add your answer
Q2. What is the difference between variables and constants in PHP?
Ans. 
Variables can be changed during the execution of a script, while constants cannot be changed once they are defined.
• Variables can be reassigned with new values, while constants cannot be changed once defined

• Constants are defined using the define() function, while variables are assigned using the $ symbol

• Constants are case-sensitive by default, while variables are case-insensitive
Answered by AI
Add your answer
Q3. What will be the output of the code below and why?
Ans. 
The code will output 'Hello World!' because the variable $x is set to true.
• The code will check if $x is true, which it is, so it will output 'Hello World!'

• The if statement will only execute if the condition is true, in this case $x is true.
Answered by AI
Add your answer

What are the differences between echo and print in PHP?

Q1. Questions were based QMS & ISMS and past experience
Add your answer

Q1. Discussed about past experience
Add your answer

Q1. Behavior, worst personality, useless manager
Add your answer
Q2. Always keeping eyes on girls one of the worst manager
Add your answer

It includes questions from aptitude as well as coding related questions, JAVA was the most common language in which majority of the coding questions were

Q1. Questions related to the skills mentioned under Resume
Add your answer
Q2. One DSA question is must, like Pallyndrome
Add your answer

Q1. Questions regarding your project
Add your answer
Q2. Questions regarding your internship experience and if any difficulties faced during internship
Add your answer

Easy you will have enough time to solve the questions

Q1. Tell me about yourself
Ans. 
Experienced product manager with a background in tech and a passion for creating innovative solutions.
• Over 8 years of experience in product management

• Strong background in technology and software development

• Proven track record of launching successful products and driving revenue growth

• Passionate about user experience and customer satisfaction

• Excellent communication and leadership skills
Answered by AI
Add your answer
Q2. Why you want to join our company
Ans. 
I am drawn to your company's innovative products and strong reputation in the industry.
• Impressed by company's track record of success

• Excited about the opportunity to work on cutting-edge products

• Interested in the company's culture and values
Answered by AI
Add your answer

Q1. Scenario of microservice saga pattern
Add your answer
Q2. Given an integer array segregate odd and even numbers without using another array
Ans. 
Segregate odd and even numbers in an integer array without using another array
• Iterate through the array and maintain two pointers, one for odd numbers and one for even numbers

• Swap elements at the odd and even pointers until all odd numbers are on one side and even numbers on the other

• Example: Input array [3, 6, 8, 5, 4], Output array [6, 8, 4, 5, 3]
Answered by AI
Add your answer

Q1. Reverse the string and find occurance of character in java
Ans. 
To reverse a string and find the occurrence of a character in Java.
• Use StringBuilder to reverse the string.

• Use a loop to iterate through the string and count the occurrences of the character.

• Use the charAt() method to access individual characters in the string.
Answered by AI
Add your answer
Q2. Write screenshot script in selenium
Ans. 
To take a screenshot in Selenium, use the getScreenshotAs method
• Create a WebDriver instance

• Use the getScreenshotAs method to capture the screenshot

• Save the screenshot to a file using File class
Answered by AI
Add your answer
Q3. Write getter an setter method
Ans. 
Getter and setter methods are used to access and modify the values of private variables in a class.
• Create a method with the prefix 'get' followed by the variable name to retrieve its value.

• Create a method with the prefix 'set' followed by the variable name to set its value.

• Ensure the getter method returns the value of the variable and the setter method updates the variable with the passed value.
Answered by AI
Add your answer
Q4. Opps concept and its pillar
Ans. 
Object-oriented programming paradigm and its four pillars: Inheritance, Encapsulation, Abstraction, Polymorphism
• Inheritance: Allows a class to inherit properties and behavior from another class

• Encapsulation: Bundling data and methods that operate on the data into a single unit

• Abstraction: Hiding the complex implementation details and showing only the necessary features

• Polymorphism: Ability to present the same interface
Answered by AI
Add your answer