Infosys Spark Developer Interview Questions and Answers

Q1. Tell about your self
Add your answer
Q2. Interested Technology
Add your answer

Q1. What is SQL where it use
Ans. 
SQL is a programming language used for managing and manipulating relational databases.
• SQL stands for Structured Query Language

• It is used to communicate with databases to perform tasks such as querying data, updating records, and creating tables

• Examples of SQL commands include SELECT, INSERT, UPDATE, DELETE
Answered by AI
Add your answer
Q2. What is Join and Procedure
Ans. 
Join is used to combine rows from two or more tables based on a related column, while Procedure is a set of SQL statements that perform a specific task.
• Join is used to retrieve data from multiple tables based on a related column

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Procedure is a set of SQL statements stored in the database and executed when called

• Procedures can accept input parameters
Answered by AI
Add your answer

Q1. Array qs reverse
Add your answer
Q2. Question about angular and react
Add your answer

Q1. What is AOT And JIT How angular different from react Route guard
Ans. 
AOT (Ahead-of-Time) and JIT (Just-in-Time) are compilation techniques used in Angular. Angular and React differ in their architecture and data binding approach. Route guards in Angular are used to control access to routes.
• AOT compilation in Angular converts TypeScript code into efficient JavaScript code during the build process, resulting in faster rendering and smaller bundle sizes.

• JIT compilation in Angular compiles ...read more
Answered by AI
Add your answer
Q2. How angular application build
Ans. 
Angular applications are built using the Angular CLI, which provides a command-line interface for creating, building, and serving Angular projects.
• Angular applications are built using the Angular CLI (Command Line Interface)

• The Angular CLI provides commands for creating new projects, generating components, services, modules, etc.

• To build an Angular application, you can use the 'ng build' command which compiles the appl
Answered by AI
Add your answer
Q3. Project discussion
Add your answer

Performance tunning and sql profiler

Basic General knowledge questions in Aptitude test

Q1. My personal details Hobbies Job purpose Salary expectation
Add your answer
Q2. My personal detailsî
Add your answer
Q3. Job purpose in daily life
Ans. 
The job purpose of a Junior Software Developer is to develop and maintain software applications.
• Developing and coding software applications

• Testing and debugging software

• Collaborating with team members to design and implement software solutions

• Maintaining and updating existing software

• Troubleshooting and resolving software issues

• Learning and adapting to new technologies and programming languages
Answered by AI
Add your answer
Q4. What are my hobbies
Add your answer
Q5. Salary Expectations
Add your answer

It wa easy , there were 20 mcq and 2 coding question .

Q1. In the first round of interview it was all techical based question . Topics like OOPs , Data structures were covered.
Add your answer

Q1. This round was a technical+managerial round. I was given senarious ans situations and asked for solutions for them.
Add your answer

Q1. This was the last round , and was purely HR based.
Add your answer

My best past is the core java and oops concepts also

Any one topic I can accept it.

Q1. Tell me about yourself
Ans. 
I am an experienced SQL Developer with a strong background in database management and query optimization.
• Over 5 years of experience in SQL development

• Proficient in writing complex SQL queries and stored procedures

• Expertise in database performance tuning and optimization

• Familiarity with various database management systems such as Oracle, MySQL, and SQL Server

• Strong problem-solving and analytical skills

• Ability to work ef
Answered by AI
Add your answer

Q1. What is your strength
Ans. 
My strength is my ability to write efficient and optimized SQL queries.
• Proficient in writing complex SQL queries

• Optimizing queries for better performance

• Strong understanding of database design principles

• Experience with query tuning and indexing

• Ability to analyze and optimize query execution plans
Answered by AI
Add your answer