AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
VHS Consulting
Compare
Filter interviews by
VHS Consulting Software Programmer Interview Questions and Answers
VHS Consulting Software Programmer Interview Experiences
1 interview found
Anonymous
Selected
I applied via Recruitment Consulltant and was interviewed before Dec 2021. There were 2 interview rounds.
(3 Questions)
- Q1. I was selected for contact to hire role.Team lead from parent company interviewed me .The questions where of basics of oops concepts in detail.As I was interviewed for asp.net c# projects I was asked abou...
- Q2. In the SQL server diff between delete truncate and drop functions.what is stored procedure and it's advantages.diff between function and stored procedure.
- Ans.
Explaining SQL server functions and stored procedures
DELETE removes specific rows from a table, TRUNCATE removes all rows from a table, DROP removes a table from the database
Stored procedures are precompiled SQL statements that can be reused, improving performance and security
Functions return a single value, while stored procedures can return multiple values or none at all
Stored procedures can also have input and outpu...
- Q3. Interviewer expects you are thorough in fundamental concepts and it's implementation in your area of expertise
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
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
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 Preparation Tips
Interview preparation tips for other job seekers - they ask question on basics and concepts more, rest interview is easy. I applied via Campus Placement and was interviewed before May 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Basic coding questions
Add your answerInterview Preparation Tips
Interview preparation tips for other job seekers - Just be confident , easy to crack Interview Questionnaire
1 Question
- Q1. Mostly related to the technology I applied for. Some coding related questions. Questions related to our expertise to test us.
Add your answer I applied via Company Website and was interviewed before Oct 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. String manipulation , collections, framework understanding
Add your answerInterview Preparation Tips
Interview preparation tips for other job seekers - For QA Automation - Basics of OOPS concept,collections,strings are enough I applied via Company Website and was interviewed before Oct 2019. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. Basics of c, matrix multiplication, sql,he said to write group by query and swapping program without using third variable
Add your answerInterview Preparation Tips
Interview preparation tips for other job seekers - Prepare well with basics of the mentioned languages in the resume. I applied via Campus Placement and was interviewed before Apr 2020. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. Tell me about Yourself?
Add your answerInterview Preparation Tips
Interview preparation tips for other job seekers - Before going to the interview the most important things to be done which works like miracles..
1. Sit in the meditative state for 2-5 mins just before the interview.
2.Think about all the blessings and all that you have and thank for having that.
3. Go with the mind set of being ethical and say to yourself that you are going to crack this interview no matter what (Easy,Medium or difficult)
Thank you
I would be happy if many people can take advantage of these advices. VHS Consulting Interview FAQsHow many rounds are there in VHS Consulting Software Programmer interview?VHS Consulting interview process usually has 2 rounds. The most common rounds in the VHS Consulting interview process are Resume Shortlist and Technical.What are the top questions asked in VHS Consulting Software Programmer interview?Tell us how to improve this page.
VHS Consulting Interviews By Designations
- VHS Consulting Software Engineer Interview Questions
- VHS Consulting Software Programmer Interview Questions
- VHS Consulting Senior System Administrator Interview Questions
- VHS Consulting HR Recruiter Interview Questions
- VHS Consulting Software Developer Interview Questions
- VHS Consulting SAP Consultant Interview Questions
- VHS Consulting Test Engineer Interview Questions
- VHS Consulting Business Development Manager Interview Questions
- Show more
Interview Questions for Popular Designations
- Specialist Programmer Interview Questions
- Programmer Analyst Interview Questions
- Programmer Analyst Trainee Interview Questions
- Java Programmer Interview Questions
- Programmer Interview Questions
- Senior Programmer Interview Questions
- Associate Software Programmer Interview Questions
- Trainee Programmer Interview Questions
- Show more
VHS Consulting Software Programmer Interview Process
based on 1 interview
Interview experience
View more
View allInterview Questions from Similar Companies
VHS Consulting Software Programmer Reviews and Ratings
based on 1 review
Rating in categories
Explore 1 Review and Rating
Explore more salariesSoftware Engineer 178 salaries
₹0 L/yr - ₹0 L/yr
Information Technology Recruiter 155 salaries ₹0 L/yr - ₹0 L/yr
Software Developer 65 salaries ₹0 L/yr - ₹0 L/yr
Senior Software Engineer 63 salaries ₹0 L/yr - ₹0 L/yr
Technical Recruiter 38 salaries ₹0 L/yr - ₹0 L/yr
Compare VHS Consulting with
KPMG India
CompareDeloitte
ComparePwC
CompareErnst & Young
ComparePopular CalculatorsDid you find this page helpful?Yes No- Home >
- Interviews >
- VHS Consulting Interview Questions >
- VHS Consulting Software Programmer Interview Questions
Share an Interview
