EVRY India Intern Interview Questions and Answers

CTE and temp tables are used to store intermediate results in SQL queries.

• CTE stands for Common Table Expression and is defined within a query.

• Temp tables are created in the tempdb database and can be accessed across sessions.

• CTEs are generally faster and more readable than temp tables.

• Temp tables are useful for complex queries with multiple steps or when data needs to be manipulated.

• CTEs are useful for recursive queri...read more

Asynchronous programming in .NET allows for non-blocking execution of code, improving performance and responsiveness.

• Async and Await keywords used to implement asynchronous programming

• Allows for parallel execution of multiple tasks

• Improves performance and responsiveness of applications

• Examples include web applications, file I/O operations, and database queries

Threading in .NET allows for concurrent execution of code, improving performance and responsiveness.

• Threading allows for multiple threads of execution to run concurrently

• Thread class is used to create and manage threads

• Thread synchronization is important to prevent race conditions and deadlocks

• Async/await is a newer approach to concurrency in .NET

• TPL (Task Parallel Library) provides higher-level abstractions for concur...read more

Performance tuning of SQL stored procedure involves optimizing query execution time and reducing resource usage.

• Identify and optimize the most resource-intensive queries

• Use appropriate indexing and partitioning techniques

• Minimize network round trips and data transfers

• Avoid using cursors and temporary tables

• Use query hints and plan guides to influence query execution plan

• Regularly monitor and analyze query performance u...read more

Joining two tables in SQL allows you to combine related data for more comprehensive queries.

• Use INNER JOIN to return records with matching values in both tables.

• Example: SELECT * FROM TableA INNER JOIN TableB ON TableA.id = TableB.a_id;

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

• Example: SELECT * FROM TableA LEFT JOIN TableB ON TableA.id = TableB.a_id;

• Use RIGHT JOIN ...read more

Classes are blueprints for objects; they encapsulate data and behavior in programming.

• A 'Car' class can have attributes like 'color', 'model', and methods like 'drive()' and 'stop()'.

• An 'Employee' class might include properties like 'name', 'id', and methods like 'work()' and 'takeLeave()'.

• In a game, a 'Player' class could have attributes like 'score' and 'level', with methods like 'jump()' and 'attack()'.

In five years, I envision myself as a lead software engineer at TietoEvry, driving innovative projects and mentoring junior developers.

• Lead a team of developers on impactful projects, such as developing a new healthcare application that improves patient care.

• Contribute to the company's strategic direction by proposing and implementing new technologies, like AI-driven solutions for data analysis.

• Mentor junior engineers,...read more

Developed a web-based project management system for a construction company.

• Used PHP and MySQL for backend development.

• Implemented a responsive UI using Bootstrap and jQuery.

• Incorporated features such as task assignment, progress tracking, and document management.

• Conducted user testing and made improvements based on feedback.

• Completed the project within the given timeline and budget.