Trend Micro Interview Questions and Answers

Easy problem on java

Q1. Technical discussion
Add your answer

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

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

Q1. Array related questions
Add your answer
Q2. OOPS Concept like multithreading
Add your answer

Some advanced linked list questions