Infinx Senior Associate Interview Questions and Answers

Q1. Self introduction
Add your answer

Q1. What is Pattern Matching in SQL
Ans. 
Pattern matching in SQL is a technique used to search for specific patterns within strings or data.
• Pattern matching is commonly used with the LIKE operator in SQL to search for specific patterns within text data.

• Wildcards such as % (percent sign) and _ (underscore) are used in conjunction with the LIKE operator to represent unknown characters or sequences.

• For example, 'SELECT * FROM table WHERE column LIKE 'A%'' would ...read more
Answered by AI
Add your answer
Q2. What is recursive stored procedure
Ans. 
A recursive stored procedure is a stored procedure that calls itself within its own code.
• Recursive stored procedures are used to perform repetitive tasks that require iteration.

• They can be used to traverse hierarchical data structures like trees or graphs.

• Care must be taken to prevent infinite loops by including a termination condition.

• Example: Factorial calculation using recursion in a stored procedure.
Answered by AI
Add your answer

Aptitude was on simple English vocabulary and basis maths

Q1. What is embedded c and how is it different from normal c
Ans. 
Embedded C is a variant of C programming language used for programming embedded systems.
• Embedded C is used for programming microcontrollers, sensors, and other embedded systems.

• It has limited resources and memory, so it requires efficient coding.

• It has specific libraries and functions for hardware control.

• Normal C is used for general-purpose programming and has no specific hardware dependencies.

• Embedded C is compiled u...read more
Answered by AI
Add your answer

Game based Aptitude test

Multiple choice questions on OPPS and pseudo codes with 2 questions on java and 2 on sql

Q1. Java collections
Add your answer
Q2. Exception Handling
Add your answer
Q3. Some tricky programs output
Add your answer

Q1. Personal Inquiry
Add your answer
Q2. Location confirmation
Add your answer

Q1. Speak on random topics
Ans. 
Speaking on random topics to showcase communication skills and knowledge on various subjects.
• Discussing current events or news

• Sharing personal hobbies or interests

• Talking about favorite books, movies, or TV shows

• Exploring travel experiences or dream destinations
Answered by AI
Add your answer
Q2. Type the topic what they given
Add your answer

Q1. Find the largest no. in arrary
Ans. 
Find the largest number in an array of strings.
• Convert each string in the array to a number using parseInt()

• Use Math.max() to find the largest number in the array
Answered by AI
Add your answer
Q2. Two sum problem directly from leet code
Add your answer

It was easy. Only basic questions were asked.

Q1. What was your project?
Ans. 
Developed a web-based inventory management system for a retail company
• Used HTML, CSS, and JavaScript for front-end development

• Utilized PHP and MySQL for back-end development

• Implemented features such as product tracking, order processing, and reporting

• Collaborated with team members to ensure project completion within deadline
Answered by AI
Add your answer
Q2. How can you improve your website?
Ans. 
Improving a website involves optimizing performance, enhancing user experience, and updating content regularly.
• Optimize website speed by compressing images and minifying code

• Enhance user experience by improving navigation and adding interactive features

• Update content regularly to keep information fresh and relevant
Answered by AI
Add your answer