AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
PeopleStrong Interview Questions, Process, and Tips
Top PeopleStrong Interview Questions and Answers
- Q1. Aggressive Cows Problem Statement Given an array representing positions of stalls and an integer ‘K’ representing the number of aggressive cows, determine the largest mi ...read moreasked in Software Developer interview
- Q2. Use of primary key & foreign keyasked in Senior Application Support Engineer interview
- Q3. Minimum Time Problem Statement In a city with ‘N’ junctions and ‘M’ bi-directional roads, each junction is connected to other junctions with specified travel times. No r ...read moreasked in Full Stack Developer interview
PeopleStrong Interview Experiences
51 interviews found
Nidhi Gulia
I was interviewed before Jul 2016.
Interview Questionnaire
6 Questions
- Q1. Use of primary key & foreign key
- Ans.
Primary keys uniquely identify records in a table, while foreign keys establish relationships between tables.
Primary keys ensure data integrity by enforcing uniqueness and preventing duplicate records.
Foreign keys create relationships between tables, allowing data to be linked and referenced across multiple tables.
Primary keys are typically used as foreign keys in related tables to establish relationships.
Foreign keys ...
- Q2. How to use inner joins
- Ans.
Inner joins are used to combine rows from two or more tables based on a related column between them.
Inner joins return only the matching rows from both tables.
The join condition is specified using the ON keyword followed by the column(s) to join on.
Inner joins can be used to retrieve data from multiple tables based on a common column.
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;
- Q3. Use of select command
- Ans.
The SELECT command is used to retrieve data from a database table.
SELECT is a fundamental SQL command used in database management systems.
It allows you to specify the columns and rows you want to retrieve from a table.
You can use various clauses like WHERE, ORDER BY, GROUP BY, etc. to filter and sort the data.
The result of a SELECT query is a result set or a cursor containing the selected data.
Example: SELECT * FROM em...
- Q4. How to create table
- Ans.
To create a table, use the CREATE TABLE statement in SQL.
Specify the table name after the CREATE TABLE keyword.
List the column names and their data types within parentheses.
Add any constraints or indexes as needed.
Example: CREATE TABLE employees (id INT, name VARCHAR(50), age INT);
- Q5. Self introduction
- Q6. Last company job roles
- Ans.
I worked as a Systems Analyst at XYZ Company, where I was responsible for troubleshooting and resolving application issues.
Troubleshooting and resolving application issues
Collaborating with developers to implement fixes
Providing technical support to end users
Interview Preparation Tips
Tips: Basics must be cleared.
Round: HR Interview
Tips: Candidate must be confident
Skills evaluated in this interview
Senior Application Support Engineer Interview Questions asked at other Companies
Anonymous
(2 Questions)
- Q1. Project Discussions
- Q2. Java, Spring boot, Database and Angular
Senior Software Developer Interview Questions asked at other Companies
I applied via Job Portal and was interviewed in Jul 2024. There was 1 interview round.
(2 Questions)
- Q1. Distance bw 2 nodes in binary tree
- Ans.
To find the distance between two nodes in a binary tree, we can find the distance from the root to each node and then calculate the distance between the two nodes.
Calculate the distance from the root to each node using a recursive function
Find the lowest common ancestor of the two nodes
Calculate the distance from each node to the lowest common ancestor and add them together to get the total distance
- Q2. Valid sudoku of 9*9
- Ans.
A valid sudoku of 9*9 is a grid where each row, column, and 3x3 subgrid contains the numbers 1-9 without repetition.
Each row must contain the numbers 1-9 without repetition
Each column must contain the numbers 1-9 without repetition
Each 3x3 subgrid must contain the numbers 1-9 without repetition
Skills evaluated in this interview
Full Stack Software Developer Interview Questions asked at other Companies
Ankita Sharma
(1 Question)
- Q1. Explain normalization in sql?
- Ans.
Normalization in SQL is the process of organizing data in a database to reduce redundancy and improve data integrity.
Normalization is used to eliminate data redundancy by breaking up tables into smaller, related tables.
It helps in reducing data anomalies such as update anomalies, insert anomalies, and delete anomalies.
There are different levels of normalization - 1NF, 2NF, 3NF, BCNF, and 4NF, each with specific rules t...
Skills evaluated in this interview
Technical Specialist Interview Questions asked at other Companies
PeopleStrong interview questions for popular designations
Selected
I was interviewed in Feb 2025.
(2 Questions)
- Q1. Can you tell us about yourself?
- Q2. Can you describe your previous job?
A standard 30-minute aptitude test.
Get interview-ready with Top PeopleStrong Interview Questions
Sudhanshu Ranjan
Binary search
find minium in array.
SDE Interview Questions asked at other Companies
Jobs at PeopleStrong
I applied via Walk-in and was interviewed in Oct 2023. There were 3 interview rounds.
(3 Questions)
- Q1. Excel realated questions and answers
- Q2. Vlookup working formula
- Ans.
Vlookup is a function in Excel used to search for a value in a table and return a corresponding value.
Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
lookup_value: The value to search for in the first column of the table.
table_array: The range of cells that contains the data.
col_index_num: The column number in the table from which to retrieve the value.
range_lookup: Optional. TRUE for approxim...
- Q3. H lookup formula
- Ans.
HLOOKUP is a function in Excel used to search for a value in the top row of a table and return a value in the same column from a specified row.
HLOOKUP stands for Horizontal Lookup.
It is used to search for a value in the top row of a table and return a value in the same column from a specified row.
Syntax: =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
Example: =HLOOKUP(123, A1:D4, 3, FALSE) will searc...
Assignment 1 ,3 and 3
Payroll realated questions and answers
Interview Preparation Tips
- Excel
- Finance
- investment
Intern Interview Questions asked at other Companies
Selected
Normal test with VARC Maths
(1 Question)
- Q1. About Principle consultancy
(1 Question)
- Q1. Tell me about yourself
Principal Consultant Interview Questions asked at other Companies
ammu madhuri
Selected
I applied via Shine and was interviewed in Feb 2024. There were 2 interview rounds.
Genral knowledge questions based on Government
(5 Questions)
- Q1. Introduce yourself
- Q2. What choosed to select this field
- Q3. Education Backround
- Q4. Why role change is required
- Q5. Relocation is comfortable
- Ans.
Relocation can be comfortable with proper planning and support.
Proper planning and research can help make the relocation process smoother
Having a support system in place can ease the transition to a new location
Utilizing relocation services provided by the company can also make the process more comfortable
HR Recruiter Interview Questions asked at other Companies
Kapil Nawhal
(2 Questions)
- Q1. DSA like stack,
- Q2. Framework questions
Senior Software Engineer Interview Questions asked at other Companies
Selected
I applied via Approached by Company and was interviewed in Dec 2023. There was 1 interview round.
23 questions subjective & 6 questions objective
Payroll Specialist Interview Questions asked at other Companies
Top trending discussions
PeopleStrong Interview FAQs
The duration of PeopleStrong interview process can vary, but typically it takes about less than 2 weeks to complete.
Recently Viewed
PHOTOS
InsuranceDekho
3 office photos
LIST OF COMPANIES
Credit Bajaar
Overview
SALARIES
Conneqt Business Solutions
No Salaries
INTERVIEWS
Innovsource Services
No Interviews
INTERVIEWS
Innovsource Services
No Interviews
SALARIES
Spectrum Talent Management
INTERVIEWS
First Advantage
No Interviews
INTERVIEWS
Innovsource Services
No Interviews
INTERVIEWS
IMPACT Infotech
No Interviews
INTERVIEWS
Teamware Solutions
No Interviews
Tell us how to improve this page.
PeopleStrong Interviews By Designations
- PeopleStrong Principal Consultant Interview Questions
- PeopleStrong Senior Software Developer Interview Questions
- PeopleStrong HR Recruiter Interview Questions
- PeopleStrong Payroll Specialist Interview Questions
- PeopleStrong HR Specialist Interview Questions
- PeopleStrong Recruitment Associate Interview Questions
- PeopleStrong Software Engineer Interview Questions
- PeopleStrong Software Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- Principal Consultant Interview Questions
- Executive Interview Questions
- Analyst Interview Questions
- Design Engineer Interview Questions
- Business Analyst Interview Questions
- Senior Engineer Interview Questions
- Graduate Engineer Trainee (Get) Interview Questions
- Accountant Interview Questions
- Show more
PeopleStrong Interview Process
based on 45 interviews
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
PeopleStrong Reviews and Ratings
based on 581 reviews
Rating in categories
3-8 Yrs
Not Disclosed
10-14 Yrs
Not Disclosed
2-8 Yrs
Not Disclosed
|
Senior Recruitment Associate
221
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Recruitment Associate
181
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Recruitment Specialist
126
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Payroll Specialist
94
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Principal Consultant
72
salaries
| ₹0 L/yr - ₹0 L/yr |
Darwinbox
SAP
Ramco Systems
greytHR
- Home >
- Interviews >
- PeopleStrong Interview Questions
