Infosys Public Services Interview Questions, Process, and Tips

The aptitude test included logical reasoning, numerical ability, and basic database concepts. Questions covered set theory, data interpretation, and SQL fundamentals like joins and indexes. The test was timed and had multiple-choice questions.

The coding test focused on SQL queries and database optimization. Some of the tasks included:

Writing queries to retrieve data using JOIN, GROUP BY, and HAVING clauses.
Optimizing a slow query by indexing and query refactoring.
Creating stored procedures and triggers for a given scenario.
Writing a query to find the second-highest salary from an Employee table

Q1. Tell me about yourself and your experience with SQL Server. 1.Why do you want to join our company? 2.What are your strengths and weaknesses? 3.How do you handle pressure and deadlines? 4.Are you open to re...read more
Ans. 
Experienced SQL Server Developer with a passion for data management and optimization, eager to contribute to your team.
• Over 5 years of experience in SQL Server development and administration.

• Proficient in writing complex SQL queries, stored procedures, and triggers.

• Successfully optimized database performance, reducing query execution time by 30%.

• Experience in data migration and ETL processes using SQL Server Integratio...read more
Answered by AI
Add your answer

Q1. What is metaspace?
Ans. 
Metaspace is a memory space in Java that stores metadata about classes and methods.
• Metaspace replaces the permanent generation (PermGen) in Java 8 and later versions.

• It is used to store class metadata, such as class names, method names, field names, annotations, etc.

• Metaspace is dynamically allocated and resized by the JVM as needed.

• It helps prevent OutOfMemoryError caused by PermGen space exhaustion.
Answered by AI
Add your answer

Q1. No hr round taken by you by me
Add your answer
Q2. No question ask by your hr
Add your answer
Q3. No any questions from you
Add your answer
Q4. No test is taken from you
Add your answer
Q5. No round from you to me
Add your answer
Q6. No any test about the working
Add your answer
Q7. How was your interview
Add your answer
Q8. How much experience would you like to be able tell
Add your answer
Q9. How are you currently working on
View 1 more answer
Q10. Is this final round and are ready to do job
Add your answer
Q11. What is the salary range for
View 1 more answer
Q12. Which shift is the most
Add your answer
Q13. What is your the shift
Add your answer
Q14. How to work from home
Ans. 
Working from home requires discipline, a dedicated workspace, and effective communication.
• Set up a designated workspace with minimal distractions

• Create a schedule and stick to it

• Communicate regularly with colleagues and managers

• Take breaks and prioritize self-care

• Utilize technology for virtual meetings and collaboration

• Stay organized and track progress towards goals
Answered by AI
View 1 more answer
Q15. I want to work from
Add your answer