Invasystems Digital Interview Questions and Answers

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

Easy you will have enough time to solve the questions

Q1. Tell me about yourself
Add your answer
Q2. Why you want to join our company
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

Q1. Mvvm and Mvc architectures
Add your answer
Q2. Gave Code snippets to find the output
Add your answer
Q3. Swift basics and concepts like memory management
Add your answer
Q4. Oops concepts and solid principles
Add your answer

The questions are quite simple.

Two SQL and two Python HackerRank questions.

Q1. What questions were asked regarding your resume project?
Ans. 
Questions were asked about the projects listed on my resume, focusing on the technologies used, challenges faced, and results achieved.
• Technologies used in the project

• Challenges faced during the project

• Results achieved from the project
Answered by AI
Add your answer

Q1. General questions
Add your answer