Microworld Technologies Interview Questions and Answers

Q1. Threading: Write and use a mutex?
Ans. 
A mutex is a synchronization primitive that ensures only one thread can access a resource at a time.
• Create a mutex object using the appropriate library or language-specific function.

• Lock the mutex before accessing the shared resource to prevent other threads from accessing it.

• Unlock the mutex after finishing the operation on the shared resource to allow other threads to access it.

• Example: pthread_mutex_t mutex; pthread...read more
Answered by AI
Add your answer
Q2. Find the memory leak in a given set of code.
Ans. 
Identify memory leak in code
• Check for any dynamically allocated memory that is not being freed

• Look for any infinite loops or recursive functions that consume memory

• Use memory profiling tools like Valgrind to detect leaks

• Check for any global variables that are not properly managed
Answered by AI
Add your answer

Q1. How to check a number is power of 2
Ans. 
To check if a number is a power of 2, we can use bitwise operations.
• A power of 2 has only one bit set to 1, so we can use the bitwise AND operator to check if the number is a power of 2.

• If n is a power of 2, then n & (n-1) will be 0.

• For example, 8 (1000 in binary) is a power of 2, and 8 & 7 (0111 in binary) is 0.
Answered by AI
Add your answer
Q2. Sort a stack without using another data structure
Ans. 
Sort a stack without using another data structure
• Use recursion to pop the top element and insert it at the bottom of the remaining stack

• Repeat until the stack is sorted in ascending order

• Time complexity: O(n^2), space complexity: O(n) due to recursion
Answered by AI
Add your answer
Q3. Check weather array have continuous increasing than decreasing value
Ans. 
Check if array has continuous increasing and decreasing values
• Loop through the array and check if each element is greater than the previous one

• Once you find the maximum element, check if the remaining elements are in decreasing order

• If yes, return true else false
Answered by AI
Add your answer

Q1. Design a cricinfo (LLD)
Ans. 
Design a cricinfo (LLD)
• Identify the entities: players, teams, matches, scorecards, tournaments, etc.

• Define the relationships between entities

• Create a database schema to store the data

• Implement APIs to fetch and update data

• Design a UI to display the information

• Consider scalability and performance

• Ensure data security and privacy
Answered by AI
Add your answer

Q1. Share details of your previous job.
Add your answer
Q2. Why should we hire you?
Add your answer
Q3. What are your strengths and weaknesses?
Add your answer

Logical reasoning And aptitude test

C++, python and Java programming

Q1. Data structures, Algorithm
Add your answer

Tha aptitude exam was not very easy and not that difficult. It was something which one can easily get into.

Q1. Question related to 1. Servers 2. Coding practices 3. Database queries 4. Latest versions syntax
Add your answer

Q1. Windows internals
Add your answer
Q2. Windows apis like loaddll dynamically
Add your answer
Q3. IPC mechanism in windows
Ans. 
IPC mechanism in Windows allows communication between processes through shared memory, message passing, and synchronization.
• IPC mechanisms in Windows include named pipes, mailslots, shared memory, and sockets.

• Named pipes allow communication between processes on the same machine or over a network.

• Mailslots are used for one-way interprocess communication.

• Shared memory allows processes to share data by mapping a region of...read more
Answered by AI
Add your answer
Q4. Multi-threading in windows
Ans. 
Multi-threading in Windows allows multiple threads to run concurrently within a single process.
• Windows provides APIs like CreateThread and CreateProcess to create and manage threads.

• Threads share the same memory space within a process, allowing for efficient communication and resource sharing.

• Windows supports both user-mode and kernel-mode threads, with user-mode threads being more lightweight.

• Synchronization mechanism...read more
Answered by AI
Add your answer
Q5. C++ general questions
Add your answer

Q1. Memory management
Add your answer
Q2. Memory mapping in windows, file mapping
Ans. 
Memory mapping in Windows allows files to be mapped directly into memory for faster access and manipulation.
• Memory mapping allows files to be accessed as if they were in memory

• File mapping can be used for sharing data between processes

• Improves performance by reducing disk I/O operations

• Examples: CreateFileMapping, MapViewOfFile, UnmapViewOfFile
Answered by AI
Add your answer
Q3. Windows internal
Add your answer
Q4. Critical section in windows
Ans. 
Critical section in Windows is a synchronization mechanism used to protect shared resources from concurrent access.
• Critical sections are used to ensure mutual exclusion between threads accessing shared resources.

• They are implemented using the Windows API functions InitializeCriticalSection, EnterCriticalSection, and LeaveCriticalSection.

• Critical sections are more efficient than mutexes for synchronization within a sing...read more
Answered by AI
Add your answer

Q1. I was provided with three tables: 1st table had city wise sales, 2nd table had province_id and name, 3rd table had city_id, city_name, and province_id 1. Get the highest sales value, city, province. Do th...read more
Add your answer
Q2. Can aggregate functions be used with HAVING clause? With WHERE clause? What is the difference between WHERE and HAVING clause? Can HAVING be used without GROUP BY?
Ans. 
Yes, aggregate functions can be used with HAVING and WHERE clauses. WHERE filters rows before grouping, HAVING filters groups after grouping.
• Aggregate functions can be used with HAVING clause to filter groups based on the result of the aggregate function.

• Aggregate functions can also be used with WHERE clause to filter rows before grouping.

• WHERE clause filters rows before grouping, while HAVING clause filters groups aft...read more
Answered by AI
View 1 more answer
Q3. What is the order of execution of a SQL Query?
Ans. 
The order of execution of a SQL query is: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.
• FROM: Specifies the tables involved in the query

• WHERE: Filters the rows based on specified conditions

• GROUP BY: Groups the rows that have the same values into summary rows

• HAVING: Filters the groups based on specified conditions

• SELECT: Selects the columns to be displayed in the result set

• ORDER BY: Sorts the result set based on speci
Answered by AI
View 1 more answer
Q4. What are User Defined Functions? Stored Procedures? Triggers?
Ans. 
User Defined Functions, Stored Procedures, and Triggers are database objects used to perform specific tasks in database management systems.
• User Defined Functions are custom functions created by users to perform specific calculations or operations in a database.

• Stored Procedures are precompiled SQL statements that can be executed by calling the procedure name.

• Triggers are special types of stored procedures that are auto...read more
Answered by AI
Add your answer

Q1. This was a managerial round
Add your answer