Upload Button Icon Add office photos

Filter interviews by

Headstream Technologies Interview Questions, Process, and Tips

Updated 1 Mar 2022

Headstream Technologies Interview Experiences

1 interview found

I applied via Naukri.com and was interviewed in Feb 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(24 Questions)

  • Q1. How do you create a Vehicle management application? There we need to manage Car, Van, Bus, Truck, Bike and Bicycle
  • Q2. What is Garbage collection? Explain
  • Ans. 

    Garbage collection is an automatic memory management process that frees up memory occupied by objects that are no longer in use.

    • Garbage collection is a process of identifying and freeing up memory that is no longer in use by the program.

    • It is done automatically by the programming language runtime environment.

    • Garbage collection helps prevent memory leaks and improves program performance.

    • Examples of programming languages...

  • Answered by AI
  • Q3. What is SOLID Principle and explain about it....
  • Ans. 

    SOLID is a set of principles for object-oriented programming to make software more maintainable, scalable, and robust.

    • S - Single Responsibility Principle: A class should have only one reason to change.

    • O - Open-Closed Principle: A class should be open for extension but closed for modification.

    • L - Liskov Substitution Principle: Subtypes should be substitutable for their base types.

    • I - Interface Segregation Principle: A c...

  • Answered by AI
  • Q4. What is CLR, and what will do
  • Ans. 

    CLR stands for Common Language Runtime. It is a component of .NET framework that manages execution of .NET programs.

    • CLR is responsible for memory management, security, and exception handling.

    • It compiles the intermediate language code into machine code.

    • CLR provides a common type system and runtime environment for all .NET languages.

    • It allows for cross-language integration and interoperability.

    • Examples of languages that

  • Answered by AI
  • Q5. Why do we go for an abstract class and how do you implement it
  • Ans. 

    Abstract classes provide a blueprint for other classes to follow and cannot be instantiated.

    • Abstract classes are used when we want to provide a common interface for a group of related classes.

    • They cannot be instantiated and must be extended by a subclass.

    • Abstract methods are declared in the abstract class and implemented in the subclass.

    • They can have both abstract and non-abstract methods.

    • Example: Animal is an abstract...

  • Answered by AI
  • Q6. What is Association, Composition and Aggregation
  • Ans. 

    Association, Composition and Aggregation are three types of relationships between classes in object-oriented programming.

    • Association is a relationship between two classes where one class uses the other class as a parameter or return type.

    • Composition is a relationship between two classes where one class owns the other class and is responsible for its creation and destruction.

    • Aggregation is a relationship between two cla...

  • Answered by AI
  • Q7. In a stored procedure there are 1000 lines of statement, how do you identify a slow running query
  • Ans. 

    Identifying slow running query in a 1000 line stored procedure

    • Use SQL Server Profiler to trace the stored procedure and identify the slow running query

    • Check the execution plan of the stored procedure to identify the slow running query

    • Use SET STATISTICS TIME ON to measure the execution time of each query in the stored procedure

    • Divide the stored procedure into smaller parts and test each part to identify the slow running

  • Answered by AI
  • Q8. Why the clustered index is only one for a table
  • Ans. 

    Clustered index is only one for a table to ensure efficient data retrieval and storage.

    • Clustered index determines the physical order of data in a table.

    • Only one clustered index can be created per table.

    • It is recommended to choose a column with unique and sequential values as the clustered index.

    • Clustered index is used for range searches and sorting.

    • Non-clustered indexes can be created for additional search paths.

  • Answered by AI
  • Q9. What is a temporary table, where it is stored, what is the lifetime
  • Ans. 

    Temporary table is a table that exists temporarily in the database and is used to store intermediate results.

    • Temporary tables are created and used within a single session or transaction.

    • They are stored in the tempdb database in SQL Server.

    • They can be used to store intermediate results during complex queries or to simplify complex joins.

    • They are automatically dropped when the session or transaction ends or when they are...

  • Answered by AI
  • Q10. What is SQL covered index
  • Ans. 

    SQL covered index is an index that contains all the columns needed for a query, reducing the need for table lookups.

    • A covered index can improve query performance by reducing the number of disk I/O operations.

    • It is created by including all the columns needed for a query in the index.

    • Covered indexes are particularly useful for queries that involve large tables or complex joins.

    • Example: CREATE INDEX idx_name ON table_name

  • Answered by AI
  • Q11. What is table variable and its lifetime
  • Ans. 

    Table variable is a variable that holds a table-like structure in memory for temporary use.

    • Table variables are declared using the DECLARE keyword in SQL Server.

    • They can be used to store temporary data within a stored procedure or a batch of SQL statements.

    • Table variables have a scope limited to the batch or stored procedure in which they are declared.

    • They are automatically dropped when the batch or stored procedure com...

  • Answered by AI
  • Q12. There are 1 lakh records on an employee table. How do we can optimize the below query? SELECT * FROM dbo.Employees WHERE City="Chennai"
  • Ans. 

    Optimizing query to fetch records from employee table based on city

    • Create an index on the City column

    • Use a WHERE clause with an index hint

    • Use a stored procedure to cache the query results

    • Use a materialized view to precompute the query results

  • Answered by AI
  • Q13. Can we create the index for a varchar column (based on the previous question)?
  • Q14. How the URL acts in MVC, Which one called first (Model, View and Controller)
  • Q15. What is MSDB in SQL Server
  • Ans. 

    MSDB is a system database in SQL Server used for managing SQL Server Agent jobs, alerts, and operators.

    • MSDB stands for Microsoft SQL Server Database

    • It stores metadata and configuration information for SQL Server Agent

    • It contains tables for job scheduling, alerts, and operators

    • It also stores backup and restore history information

  • Answered by AI
  • Q16. What is SQL NOLOCK..?
  • Ans. 

    SQL NOLOCK is a query hint used to allow a SELECT statement to read data from a table without acquiring a shared lock.

    • NOLOCK is used to improve query performance by allowing dirty reads

    • It is not recommended to use NOLOCK in production environments

    • Other query hints include UPDLOCK, ROWLOCK, and XLOCK

  • Answered by AI
  • Q17. What is Async and Await
  • Ans. 

    Async and Await are keywords used in asynchronous programming in JavaScript.

    • Async and Await are used to handle asynchronous operations in JavaScript.

    • Async is used to define a function that returns a promise.

    • Await is used to wait for the promise to resolve before continuing the execution.

    • Async and Await make asynchronous code look like synchronous code.

    • Async and Await are supported in modern browsers and Node.js.

  • Answered by AI
  • Q18. Explain about Collections Vs Dictionary Vs KeyValuePair
  • Ans. 

    Collections are generic classes to store and manipulate groups of objects. Dictionary is a collection of key-value pairs. KeyValuePair is a struct that represents a key-value pair.

    • Collections are used to store and manipulate groups of objects.

    • Dictionary is a collection of key-value pairs where each key is unique.

    • KeyValuePair is a struct that represents a key-value pair and is used in Dictionary.

    • Collections and Dictiona...

  • Answered by AI
  • Q19. Can we use SQL Functions on the JOIN Clause
  • Ans. 

    Yes, SQL Functions can be used on the JOIN Clause.

    • SQL Functions can be used on the JOIN Clause to manipulate the data before joining.

    • Examples of SQL Functions that can be used on the JOIN Clause are CONCAT, SUBSTRING, and DATE_FORMAT.

    • Using SQL Functions on the JOIN Clause can improve query performance and reduce the amount of data transferred.

  • Answered by AI
  • Q20. What a SQL Function returns (what are the return type of function)
  • Ans. 

    SQL functions return a single value of a specified data type.

    • SQL functions can return various data types such as integer, string, date, etc.

    • The return type of a function is specified in the function declaration.

    • Functions can be used in SELECT, WHERE, and other SQL statements to manipulate data.

    • Examples of SQL functions include COUNT, AVG, MAX, MIN, and CONCAT.

    • Functions can also be user-defined using the CREATE FUNCTION

  • Answered by AI
  • Q21. What is MVC Data Annotations
  • Ans. 

    MVC Data Annotations are attributes used to define validation rules and metadata for model properties in ASP.NET MVC applications.

    • Used to validate user input on the server-side

    • Can be used to specify display names, format strings, and more

    • Examples include [Required], [StringLength], and [RegularExpression]

  • Answered by AI
  • Q22. Form validations and model validation
  • Q23. What is partial views and how it is differs from View
  • Ans. 

    Partial views are reusable components of a view that can be rendered within other views.

    • Partial views are used to break down complex views into smaller, more manageable pieces.

    • They can be used to display common elements across multiple views, such as headers or footers.

    • Partial views can be rendered within other views using the @Html.Partial() method in ASP.NET MVC.

    • They can also be passed data from the parent view using...

  • Answered by AI
  • Q24. How to transfer data from controller to controller
  • Ans. 

    Data can be transferred between controllers using various methods such as delegation, notifications, or segues.

    • Delegation pattern can be used to transfer data between controllers

    • Notifications can be used to broadcast data to multiple controllers

    • Segues can be used to pass data between controllers during a transition

    • Data can also be stored in a shared data model or database for access by multiple controllers

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Headstream Technologies Senior Software Engineer interview:
  • ASP.Net MVC
  • OOPS
  • SQL Server
Interview preparation tips for other job seekers - Was interviewed by Tamil persons.
Was asked based on the working experience, how do you implement this?

Skills evaluated in this interview

Top Headstream Technologies Senior Software Engineer Interview Questions and Answers

Q1. There are 1 lakh records on an employee table. How do we can optimize the below query? SELECT * FROM dbo.Employees WHERE City="Chennai"
View answer (1)

Senior Software Engineer Interview Questions asked at other Companies

Q1. Tell me about yourself. What technology are you using? What is a Collection? What are the different types of collection there? What is the difference between ArrayList and LinkedList What are the basic building blocks of Stream operators, s... read more
View answer (2)

Jobs at Headstream Technologies

View all

Interview questions from similar companies

I applied via Naukri.com and was interviewed before May 2021. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. Discuss 4 case study related to supply chain management.

Interview Preparation Tips

Topics to prepare for Tech Mahindra Senior Software Engineer interview:
  • Supply Chain Management
Interview preparation tips for other job seekers - Develop some case study of your own and also deep analysis for each.

I applied via Walk-in and was interviewed before Apr 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. What is Excel what is vlookup what is your strength and weakness

Interview Preparation Tips

Interview preparation tips for other job seekers - Be honest and bold

I was interviewed before Sep 2020.

Round 1 - Coding Test 

(1 Question)

Round duration - 140 minutes
Round difficulty - Medium

Test timing was at 2:00 pm , it was conducted in a college and the environment was good for the test. Camera was a primary part of test, so no suspicious activity.

  • Q1. 

    Sum of Two Numbers Represented as Arrays

    Given two numbers in the form of two arrays where each element of the array represents a digit, calculate the sum of these two numbers and return this sum as an ar...

  • Ans. 

    Given two numbers represented as arrays, calculate their sum and return the result as an array.

    • Iterate through the arrays from right to left, adding digits and carrying over if necessary

    • Handle cases where one array is longer than the other by considering the remaining digits

    • Ensure the final sum array does not have any leading zeros

  • Answered by AI
Round 2 - Face to Face 

Round duration - 20 minutes
Round difficulty - Easy

The round was conducted at around 12 p.m. I was called at the college location and then it was conducted. The interviewer was quite polite and frank.

Round 3 - HR 

Round duration - 8 minutes
Round difficulty - Easy

This round was conducted right after finishing and clearing the technical round at the same place and on the same day.

Interview Preparation Tips

Eligibility criteriaAbove 60 %Wipro Limited interview preparation:Topics to prepare for the interview - OOPS, Data Structures, Database Concepts, Coding problemsTime required to prepare for the interview - 2-3 monthsInterview preparation tips for other job seekers

Tip 1 : Practice atleast 2-3 Coding problems daily so your logic building becomes stronger.
Tip 2 : Exercise problems based on OOPS concepts and others too.
Tip 3 : If you can have your own project built, then it's the major point and will act as a plus point.

Application resume tips for other job seekers

Tip 1 : Your resume should be in standard form, short and simple will be more effective.
Tip 2 : Whatever you have learned, you need to mention it in your resume as that will be your primary source of selection and having project on your resume is important.

Final outcome of the interviewSelected

Skills evaluated in this interview

I applied via Naukri.com and was interviewed in Jul 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. SOLID principals, oops, c# basics, SQL server, azure, design pattern

Interview Preparation Tips

Interview preparation tips for other job seekers - Clear basics of oops and design pattern

I applied via Naukri.com and was interviewed before Apr 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basic questions only ... regarding job and experience

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident ... always say the truth ... never try to fake your details

I applied via Campus Placement and was interviewed before Jan 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. First question in hr interview is tell about yourself then the hr asked questions what I mentioned in my resume. So put the information in resume what you known well. My unique talent is I'm a stage spea...

Interview Preparation Tips

Interview preparation tips for other job seekers - Be bold, be confident, don't put irrelevant information in your resume update yourself relating to your studies

I applied via Walk-in and was interviewed before May 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Add your question

Interview Preparation Tips

Interview preparation tips for other job seekers - Share your interview advice and tips

I applied via Campus Placement and was interviewed before Feb 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Hr

Interview Preparation Tips

Interview preparation tips for other job seekers - You should be true to what you are putting before the interviewer . Try to put your ideas Add something you did well in your career like in projects /research which you know very well and versed in concepts about it for open interview so that interviewer can get bandwidth where he can ask questions from. This is simply a key .

I applied via Campus Placement and was interviewed in Jul 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Why Java is platform independent?
  • Ans. 

    Java is platform independent due to its bytecode and JVM.

    • Java code is compiled into bytecode which is platform-independent.

    • JVM (Java Virtual Machine) interprets the bytecode and executes it on any platform.

    • JVM acts as an abstraction layer between the Java code and the underlying hardware.

    • This allows Java programs to run on any platform that has a JVM installed.

    • For example, a Java program written on a Windows machine ca...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Java is platform-independent because it does not depend on any type of platform. Hence, Java is platform-independent language. In Java, programs are compiled into byte code and that byte code is platform-independent. ... Any machine to execute the byte code needs the Java Virtual Machine.

Skills evaluated in this interview

Headstream Technologies Interview FAQs

How many rounds are there in Headstream Technologies interview?
Headstream Technologies interview process usually has 2 rounds. The most common rounds in the Headstream Technologies interview process are Resume Shortlist and One-on-one Round.
How to prepare for Headstream Technologies interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Headstream Technologies. The most common topics and skills that interviewers at Headstream Technologies expect are Business Development, .Net, ASP.Net, Client Management and MVC.
What are the top questions asked in Headstream Technologies interview?

Some of the top questions asked at the Headstream Technologies interview -

  1. There are 1 lakh records on an employee table. How do we can optimize the belo...read more
  2. Why do we go for an abstract class and how do you implement...read more
  3. In a stored procedure there are 1000 lines of statement, how do you identify a ...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.4k Interviews
Infosys Interview Questions
3.6
 • 7.6k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
LTIMindtree Interview Questions
3.8
 • 2.9k Interviews
Mphasis Interview Questions
3.4
 • 791 Interviews
HCL Infosystems Interview Questions
3.9
 • 140 Interviews
View all

Headstream Technologies Reviews and Ratings

based on 4 reviews

3.8/5

Rating in categories

3.0

Skill development

3.8

Work-life balance

4.0

Salary

3.0

Job security

3.4

Company culture

3.0

Promotions

3.0

Work satisfaction

Explore 4 Reviews and Ratings
Software Engineer
4 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

HR Manager
4 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Technical Writer
4 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Quality Analyst
4 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Technical Developer Lead
4 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Headstream Technologies with

Infosys

3.6
Compare

TCS

3.7
Compare

Wipro

3.7
Compare

HCLTech

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview