AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
ExpertLancing Research Services
Compare
Filter interviews by
ExpertLancing Research Services Software Engineer Interview Questions and Answers
ExpertLancing Research Services Software Engineer Interview Experiences
1 interview found
Anonymous
I was interviewed in Dec 2020.
(1 Question)
Round duration - 120 Minutes
Round difficulty - Easy
Coding questions
- Q1. What can you tell me about queries related to SQL joins?
- Ans.
SQL joins are used to combine rows from two or more tables based on a related column between them.
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
INNER JOIN returns rows when there is at least one match in both tables.
LEFT JOIN returns all rows from the left table and the matched rows from the right table.
RIGHT JOIN returns all rows from the right table and the matched rows from the left table.
F...
(2 Questions)
Round duration - 140 Minutes
Round difficulty - Hard
Group Anagrams
Valid Parenthesis
- Q1.
Valid Parentheses Problem Statement
Given a string 'STR' consisting solely of the characters “{”, “}”, “(”, “)”, “[” and “]”, determine if the parentheses are balanced.
Input:
The first line contains an... - Ans.
The task is to determine if a given string consisting of parentheses is balanced or not.
Iterate through the characters of the string and use a stack to keep track of opening parentheses.
When encountering an opening parenthesis, push it onto the stack. When encountering a closing parenthesis, check if it matches the top of the stack.
If the stack is empty when encountering a closing parenthesis or if there are unmatched ...
- Q2.
Group Anagrams Problem Statement
Given an array or list of strings called
inputStr, your task is to return the strings grouped as anagrams. Each group should contain strings that are anagrams of one anoth... - Ans.
Group anagrams in an array of strings based on their characters.
Iterate through the array of strings and sort each string to group anagrams together.
Use a hashmap to store the sorted string as key and the list of anagrams as value.
Return the values of the hashmap as the grouped anagrams.
Round duration - 20 Minutes
Round difficulty - Easy
Some technical questions were asked by HR to check my confidence
Interview Preparation Tips
Tip 1 : You need to have a great aptitude for knowledge
Tip 2 : Should practice top 50 frequently asked coding questions
Tip 1 : Have a plain and simple resume.
Tip 2 : Add things to resume which you're 100% sure of
Skills evaluated in this interview
Interview questions from similar companies
I was interviewed before Sep 2020.
(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
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 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
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.
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.
Skills evaluated in this interview
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
I applied via Campus Placement and was interviewed in Dec 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. 1.Describe a situation where you have taken a quick decision and failed, and a situation where you succeeded. 2. What is a skill you have tried to achieve but failed? 3. Describe a decision you have taken ...
Interview Preparation Tips
2. Every skill you learn, even if you didn't excel in it is not to be considered a waste of time/failure, you learn something simply by participating.
I applied via Campus Placement and was interviewed before Jun 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Tell me about Yourself, some questions related to machine learning, and I was asked more questions to differentiate like differences between ml and ai, python and c, c and java and procedural and functiona...
Interview Preparation Tips
I was interviewed before Jun 2021.
(2 Questions)
Round duration - 180 minutes
Round difficulty - Easy
It was an mcq + coding round. There were aptitude and ouput based question in mcq. And coding questions were easy
- Q1.
Find the Duplicate Number Problem Statement
Given an integer array 'ARR' of size 'N' containing numbers from 0 to (N - 2). Each number appears at least once, and there is one number that appears twice. Yo...
- Ans.
Find the duplicate number in an array of integers from 0 to (N-2).
Iterate through the array and keep track of the frequency of each number using a hashmap.
Return the number with a frequency greater than 1 as the duplicate number.
Time complexity can be optimized to O(N) using Floyd's Tortoise and Hare algorithm.
- Q2.
Reverse String Operations Problem Statement
You are provided with a string
Sand an array of integersAof sizeM. Your task is to performMoperations on the string as specified by the indices in arrayA... - Ans.
Given a string and an array of indices, reverse substrings based on the indices to obtain the final string.
Iterate through the array of indices and reverse the substrings accordingly
Ensure the range specified by each index is non-empty
Return the final string after all operations are completed
Round duration - 60 Minutes
Round difficulty - Easy
It was technical + hr round. there were 2 people as interviewer. They stated from intro and asked some basic puzzles and hr questions. After that they asked about my projects, technologies and some ds algo and dbms questions.
Interview Preparation Tips
Tip 1 : Practice aptitude
Tip 2 : Focus on practicing coding
Tip 3 : Learn from mistakes
Tip 1 : Mention some projects that you have done
Tip 2 : Try to have skills that are required for the role
Skills evaluated in this interview
I applied via Job Portal and was interviewed before Jan 2021. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Oops Concepts,JAVA 8
Interview Preparation Tips
I applied via Campus Placement and was interviewed in Mar 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. How do you get the second to last element from a SQL table?
- Ans.
To get the second to last element from a SQL table, use the OFFSET-FETCH clause.
Use the ORDER BY clause to sort the table in descending order.
Use the OFFSET-FETCH clause to skip the last row and fetch the second to last row.
Example: SELECT column_name FROM table_name ORDER BY column_name DESC OFFSET 1 ROWS FETCH NEXT 1 ROWS ONLY;
Interview Preparation Tips
Skills evaluated in this interview
Interview Questionnaire
6 Questions
- Q1. What is fan trap? How to solve it? Give one example.
- Ans.
Fan trap is a situation in which a query involving multiple tables results in a Cartesian product.
Fan trap occurs when a table is connected to multiple tables in a one-to-many relationship.
It can be solved by creating a bridge table or by using aggregate functions.
For example, if a customer table is connected to an orders table and a products table, a fan trap can occur when trying to retrieve information about custome...
- Q2. Two tables are joined. But joined type are not mentioned, then how much records will retrieve using select statement.
- Q3. How to use dynamic break in report?
- Ans.
Dynamic break in report allows for automatic page breaks based on data.
Define a break field in the report design
Set the break field to trigger a page break when its value changes
Use dynamic break to automatically adjust page breaks based on data
Example: A report on sales by region can use dynamic break to create a new page for each region
- Q4. Use of foreach function in report.
- Ans.
Foreach function is used to iterate through an array of strings in a report.
Foreach function is used to loop through each element in an array of strings.
It can be used to display each element in a report.
Example: foreach(string item in stringArray){ Console.WriteLine(item); }
- Q5. What is Aggregate awareness? When we use it? Syntax of it.
- Ans.
Aggregate awareness is a feature in Business Objects that allows reports to be optimized for performance by using aggregate tables.
Aggregate awareness is used when creating reports in Business Objects
It allows the report to use aggregate tables instead of detailed tables for improved performance
Syntax: AGGR_AWARE(
, , )
Example: AGGR_AWARE(Product, Sum(Sales), Sales_Fact_Table)
Answered by AIAdd your answer- Q6. @prompt function syntax and it's use.
- Ans.
The @prompt function syntax is used to display a prompt message to the user and receive input.
The syntax is @prompt('message', 'default value')
The message is the prompt message to be displayed to the user
The default value is optional and will be displayed in the input field
The function returns the value entered by the user
Answered by AIAdd your answer Interview Questionnaire
1 Question
- Q1. Drupal data migration
Add your answer Tell us how to improve this page.
ExpertLancing Research Services Interviews By Designations
Interview Questions for Popular Designations
- Senior Software Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Softwaretest Engineer Interview Questions
- Software Engineer Trainee Interview Questions
- Software Developer Intern Interview Questions
- Software Developer Interview Questions
- Software Development Engineer Interview Questions
- Junior Software Developer Interview Questions
- Show more
View allSoftware Engineer Interview Questions from Similar Companies
Explore more salariesPatent Research Associate 6 salaries
₹0 L/yr - ₹0 L/yr
Business Development Associate 5 salaries ₹0 L/yr - ₹0 L/yr
Research Associate 5 salaries ₹0 L/yr - ₹0 L/yr
Business Associate 5 salaries ₹0 L/yr - ₹0 L/yr
Senior Research Associate 5 salaries ₹0 L/yr - ₹0 L/yr
Compare ExpertLancing Research Services with
Market Xcel Data Matrix
CompareFrost & Sullivan
CompareKantar
CompareNielsen
ComparePopular CalculatorsDid you find this page helpful?Yes No- Home >
- Interviews >
- ExpertLancing Research Services Interview Questions >
- ExpertLancing Research Services Software Engineer Interview Questions
Share an Interview
