Mastech InfoTrellis Associate Interview Questions and Answers

Q1. Sql is the most important , Focus on Joins ,Sub query and Sql basics
Add your answer
Q2. Joining tables with different joins
Ans. 
Joining tables with different joins in SQL
• Use INNER JOIN to return rows when there is at least one match in both tables

• Use LEFT JOIN to return all rows from the left table and the matched rows from the right table

• Use RIGHT JOIN to return all rows from the right table and the matched rows from the left table

• Use FULL JOIN to return rows when there is a match in one of the tables
Answered by AI
Add your answer

Q1. What is zero coupon bond?
Ans. 
A zero coupon bond is a bond that pays no interest and is sold at a discount to its face value.
• Zero coupon bonds are also known as discount bonds.

• Investors buy these bonds at a price lower than their face value and receive the full face value at maturity.

• The difference between the purchase price and the face value is the investor's return.

• Zero coupon bonds are often used for long-term investments, such as retirement sa...read more
Answered by AI
Add your answer
Q2. What is corporate actions and how you record those in books?
Ans. 
Corporate actions are events initiated by a company that can affect its stock price and shareholders. They are recorded in books through various accounting entries.
• Corporate actions include stock splits, dividends, mergers, acquisitions, and spin-offs.

• These actions are recorded in books through journal entries and adjustments to accounts such as retained earnings and stockholders' equity.

• For example, if a company decla...read more
Answered by AI
Add your answer

Given a list of integer find the longest increase sequence

Q1. Given a list of integer find the first non repeating integer using stream API of Java 8.
Ans. 
Find the first non-repeating integer in a list using Java 8 stream API.
• Use Java 8 stream API to group integers by count

• Filter out integers with count greater than 1

• Return the first non-repeating integer
Answered by AI
Add your answer
Q2. Questions on core java like how internationally string works, hashmap etc And questions on database like what is indexing How to optimize SQL queries etc
Add your answer

Q1. Given a Map of fruits with there price as a key value pair respectively, find the fruit whose price is maximum using Java 8 Stream API.
Ans. 
Using Java 8 Stream API to find the fruit with maximum price in a Map of fruits.
• Use entrySet() method to get a stream of key-value pairs from the Map.

• Use max() method with Comparator.comparing() to find the entry with maximum price.

• Extract the key (fruit) from the entry with maximum price.
Answered by AI
Add your answer
Q2. Write a program to check whether the parenthesis are properly balanced or not, means for every opening brace these should be a closing brace present.
Ans. 
Program to check if parenthesis are properly balanced
• Use a stack data structure to keep track of opening parenthesis

• Iterate through the input string and push opening parenthesis onto the stack

• When a closing parenthesis is encountered, pop from the stack and check if it matches the corresponding opening parenthesis

• If stack is empty at the end and all parenthesis are matched, then the input has properly balanced parenthe
Answered by AI
Add your answer
Q3. Questions on core Java, Spring Boot, JPA, and Microservices you should have strong foundation in these topics questions asked like 1) what is API gateway 2) how 2 services communicate with eachother 3) ...read more
Add your answer

Easy applitute question with 1 coding question at the end

Q1. String builder vs string buffer
Ans. 
String builder is faster but not thread-safe, while string buffer is slower but thread-safe.
• String builder is recommended for single-threaded applications for better performance.

• String buffer is recommended for multi-threaded applications to ensure thread safety.

• Example: StringBuilder sb = new StringBuilder(); StringBuffer sbf = new StringBuffer();
Answered by AI
Add your answer
Q2. Final keyword in oops
Ans. 
The final keyword in OOP is used to restrict the user from changing the value of a variable, overriding a method, or inheriting from a class.
• Final variable: value cannot be changed once assigned

• Final method: cannot be overridden in child classes

• Final class: cannot be inherited by other classes
Answered by AI
Add your answer
Q3. Bsf graph explanation
Ans. 
BSF graph explanation
• BFS (Breadth-First Search) is a graph traversal algorithm that explores all the neighbor nodes at the present depth before moving on to the nodes at the next depth.

• It uses a queue data structure to keep track of the nodes to visit next.

• BFS is often used to find the shortest path in an unweighted graph.

• Example: BFS can be used to find the shortest path in a maze from the starting point to the exit.
Answered by AI
Add your answer

Its a sectional round. It has 4 sections. Quants, Logical, pseudo code, Reasoning, Gaming

Q1. Aptitude question solving
Add your answer
Q2. Resume related questions
Add your answer

Basic aptitude question

Based on puzzle comprehension

25 MCQ , 2 short essays

Q1. Walk me through your profile
Add your answer

Q1. Why should we hire you ?
Add your answer