MindSquare Technologies Interview Questions and Answers

Q1. All employees having same salary in the smae department sql and pysprk
Add your answer
Q2. How to create pipeline in databricks
Ans. 
To create a pipeline in Databricks, you can use Databricks Jobs or Apache Airflow for orchestration.
• Use Databricks Jobs to create a pipeline by scheduling notebooks or Spark jobs.

• Utilize Apache Airflow for more complex pipeline orchestration with dependencies and monitoring.

• Leverage Databricks Delta for managing data pipelines with ACID transactions and versioning.
Answered by AI
Add your answer
Q3. Palindrome, 2nd char in every word make is to upper case, sql rank and dense rank releated questions , given 2 tables country and city we need to calculate total population in each continent by joining the...read more
Add your answer
Q4. String manuplation questions inpython
Add your answer

Q1. What is an abstract class?
Ans. 
An abstract class is a class that cannot be instantiated and may contain abstract methods that must be implemented by its subclasses.
• Cannot be instantiated directly

• May contain abstract methods

• Used as a blueprint for other classes
Answered by AI
Add your answer
Q2. What is abstraction?
Ans. 
Abstraction is the process of hiding complex details and showing only the essential features of an object or system.
• Abstraction allows us to focus on what an object does, rather than how it does it

• It helps in simplifying complex systems by breaking them down into smaller, more manageable parts

• Examples of abstraction include using a car without needing to understand its internal combustion engine, or using a smartphone
Answered by AI
Add your answer
Q3. Best sorting algo?time complexity of it?
Ans. 
QuickSort is one of the best sorting algorithms with an average time complexity of O(n log n).
• QuickSort is a divide and conquer algorithm that works by selecting a 'pivot' element and partitioning the array around the pivot.

• It has an average time complexity of O(n log n) and a worst-case time complexity of O(n^2).

• Example: ['apple', 'banana', 'cherry', 'date', 'fig'] can be sorted using QuickSort.

• Example: ['3', '1', '4'...read more
Answered by AI
Add your answer
Q4. You have been provided a sorted list time complexity achieved after we apply bubble sorting
Ans. 
Bubble sorting has a time complexity of O(n^2) for a sorted list.
• Bubble sorting has a worst-case time complexity of O(n^2) for a sorted list.

• The time complexity does not change even if the list is already sorted.

• Example: If we have a sorted list of size n, bubble sorting will still take O(n^2) time.
Answered by AI
Add your answer

Q1. Have you ever been to a state other than jharkhand?
Ans. 
Yes, I have been to multiple states other than Jharkhand.
• I have traveled to states like Maharashtra, Karnataka, and Tamil Nadu for work and leisure.

• I have visited tourist destinations in states like Rajasthan, Kerala, and Himachal Pradesh.

• I have family in states like Uttar Pradesh, Bihar, and West Bengal, which I have visited multiple times.
Answered by AI
Add your answer

Q1. What is the Java code for reversing a linked list?
Ans. 
Reversing a linked list in Java using iterative approach.
• Create three pointers: prev, current, and next.

• Iterate through the list, updating pointers to reverse the links.

• Return the new head of the reversed list.
Answered by AI
Add your answer
Q2. How do you handle the StaleElementReferenceException in your code?
Ans. 
Handle StaleElementReferenceException by re-locating the element before interacting with it.
• Use try-catch block to catch StaleElementReferenceException

• Re-locate the element using findElement method before interacting with it

• Use WebDriverWait to wait for the element to become stale
Answered by AI
Add your answer

Q1. Can you describe your project experiences?
Ans. 
I have worked on various projects involving test automation, performance testing, and quality assurance processes.
• Developed automated test scripts using Selenium WebDriver for web applications

• Conducted performance testing using JMeter to identify bottlenecks and optimize system performance

• Implemented quality assurance processes to ensure software meets requirements and standards

• Collaborated with cross-functional teams ...read more
Answered by AI
Add your answer
Q2. What is your strategy for designing an automation framework?
Ans. 
My strategy for designing an automation framework involves identifying key functionalities, selecting appropriate tools, creating reusable components, implementing robust error handling, and integrating with CI/CD pipelines.
• Identify key functionalities to be automated based on priority and impact on testing.

• Select appropriate tools and technologies based on the application under test and team expertise.

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

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