AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Virtusa Consulting Services SQL Developer Interview Questions and Answers for Freshers
Virtusa Consulting Services SQL Developer Interview Experiences for Freshers
1 interview found
Manshi
Simple coding not that much tough
(2 Questions)
- Q1. Question related to your skills
- Q2. Just basic questions
(1 Question)
- Q1. Why u want to join
Interview questions from similar companies
Software Developer Interview Questions & Answers
Publicis Sapient
Bala Krishna
posted on 16 Aug 2015
Interview Questionnaire
4 Questions
- Q1. Explain Network Layers?
- Ans.
Network layers are a hierarchical way of organizing communication protocols.
Network layers provide a modular approach to networking.
Each layer has a specific function and communicates with adjacent layers.
The OSI model has 7 layers, while the TCP/IP model has 4 layers.
Examples of layers include the physical layer, data link layer, network layer, transport layer, and application layer.
- Q2. What is a Dead Lock?
- Ans.
Deadlock is a situation where two or more processes are unable to proceed because they are waiting for each other to release resources.
Occurs in multi-threaded/multi-process environments
Can lead to system freeze or crash
Prevention techniques include resource ordering and timeouts
Example: Process A holds resource X and waits for resource Y, while Process B holds resource Y and waits for resource X
- Q3. Explain Paging and Segmentation
- Ans.
Paging and Segmentation are memory management techniques used by operating systems.
Paging divides memory into fixed-size pages and stores them in physical memory.
Segmentation divides memory into logical segments and stores them in physical memory.
Paging allows for efficient use of physical memory and reduces fragmentation.
Segmentation allows for protection and sharing of memory between processes.
Examples of operating s...
- Q4. Pirates of different ages have a treasure of 100 gold coins. On their ship, they decide to split the coins using this scheme: The oldest pirate proposes how to share the coins, the OTHER pirates (not inc...
Interview Preparation Tips
Experience: It would quite a simple test, covering basic questions from general mathematics and algebra
Tips: Practice "Aptitude" on daily basis
Round: Technical Interview
Experience: Technical Interview in sapient will be quite related to understand of your basic concepts. The round also includes Puzzles. Try Practising some random puzzles from internet.
Tips: Be active and Interactive. Even, if you do not know the answer, try explaining your approach. That would get you marks.
Round: HR Interview
Experience: The HR carries larger wait-age in Sapient. Do not panic. He will give you enough time to settle down by asking background questions. He will only try to analyse the kind of person you are. Be true to yourself and your are sure to be successful
Skills: Basic Concepts of Launguages, Operating System, Networks
College Name: NIT JALANDHAR
Skills evaluated in this interview
Anonymous
Interview Preparation Tips
Experience: Technical sections had questions from almost all the sections through AMCAT(C, C++, DBMS, DS, OS)(level :moderate)Quantitative aptitude’s questions were good.. All were almost of R. S. Aggarwal level though few exceptions were there tooLogical reasoning and verbal ability was good.. Some questions were tough.
Round: HR Interview
Experience: Overall enjoyed. But not selected because of my less market knowledge.
College Name: NA
Interview Questionnaire
6 Questions
- Q1. INPUT : "HI MY NAME IS : ANIRUDDHA , CALL ME MAYBE :)" OUTPUT : "MAYBE ME CALL ANIRUDDHA IS NAME MY HI
- Q2. Reverse a linked list (iterative AND Recursive)
- Ans.
Reverse a linked list using iterative and recursive methods.
Iterative method involves traversing the list and changing the pointers to reverse the order.
Recursive method involves calling the function recursively on the next node and changing the pointers.
Both methods have O(n) time complexity and O(1) space complexity.
Example: 1->2->3->4->5 becomes 5->4->3->2->1.
- Q3. Clone a FULL linked list given a pointer and a random pointer
- Ans.
Clone a linked list with a random pointer.
Create a new node for each node in the original list.
Use a hash table to map the original nodes to their clones.
Iterate through the original list again and update the random pointers of the clone nodes.
- Q4. TELL ME ABOUT YOURSELF
- Q5. QUOTE YOUR STRENGHTS AND WEAKNESS
- Q6. WHY SHOULD I HIRE YOU?
Interview Preparation Tips
Experience: 50 QUANTITATIVE APTITUDE QUESTIONS CUTOFF 30 out of 50
Total Questions: 50
Round: Test
Experience: WRITTEN ON PAPER CODING QUESTIONS
1) Given a string like
INPUT : ( ( TRUE OR FALSE ) AND ( FALSE OR TRUE ) ) OR FLASE
OUTPUT: TRUE
EVALUATE THE GIVEN EXPRESSION
2) Print all sub strings of maximum length having 2 unique characters
e.g:
INPUT : "hellomorning"
OUTPUT : "ell","llo","omo","nin"
3) Find the max length of subarray having ZERO SUM
INPUT : {3,2,1,1,0,-2,1,3,-5,1,2,1,4} OUTPUT: 7
Round: Test
Experience: 1) An array has 2N elements with N elements are same and another n are mutually different.
So find this repeating element in O(N) time with O(1) space
INPUT : {1,2,3,1}
OUTPUT: 1
2) Print the common words from given two sentences
AND YOU HAVE TO CONSIDER ALL CASES LIKE Colon, Hyphen, Dash, and Semicolons may be EMBEDDED IN BOTH SENTENCES
INPUT: sentence:1:: "HI ALL,RAMESH is mt brother,he has topped in the exam AND MY NAME IS NOT IN THE LIST"
sentence:2:: "all students are advised to READ THE LIST and say hi to RAMESH"
OUTPUT: "HI","ALL","RAMESH","THE","AND","LIST"
3) Sort the give dates collection given in special format like 10-04-2013,10-05-2005,29-02-2000 IN ASCENDING ORDER
OUTPUT: 29-02-2000,10-05-2005,10-04-2013
Round: Technical Interview
Experience: Then he started talking about my projects,Again jumped into coding questions
1. INPUT : "HI MY NAME IS : ANIRUDDHA , CALL ME MAYBE :)"
OUTPUT : "MAYBE ME CALL ANIRUDDHA IS NAME MY HI"
2. Reverse a linked list (iterative AND Recursive)
3. Clone a FULL linked list given a pointer and a random pointer
Round: HR Interview
Experience: TELL ME ABOUT YOURSELF.
QUOTE YOUR STRENGHTS AND WEAKNESS
WHY SHOULD I HIRE YOU?
College Name: NA
Skills evaluated in this interview
Interview Preparation Tips
Experience: This interview is meant to check candidate's background and candidates's interest towards the company.
College Name: NIT BHOPAL
Interview Questionnaire
9 Questions
- Q1. Input an array and then print the repeating characters?? Example: Input:1,3,23,11,44,3,23,2,3. Output:3,23
- Ans.
The question asks to input an array and print the repeating characters.
Iterate through the array and store each element in a hash table or dictionary.
If an element already exists in the hash table, it is a repeating character.
Print all the repeating characters found.
- Q2. Input an array and prints the second minimum in an array?? Example Input:34,45,21,12,54,67,15 Output:15
- Ans.
Program to find the second minimum in an array.
Sort the array and return the second element.
Initialize two variables to store minimum and second minimum values.
Loop through the array and update the variables accordingly.
- Q3. Find the longest palendrom in a string? Example Input: abfgerccdedccfgfer Output: ccdedcc
- Ans.
To find the longest palindrome in a given string.
Iterate through the string and check for palindromes of odd and even lengths.
Keep track of the longest palindrome found so far.
Use two pointers to check if the substring is a palindrome.
If the substring is a palindrome and its length is greater than the current longest palindrome, update the longest palindrome.
- Q4. Input a number and then find the next higher number such that for both the number (inputted and the next higher number) in binary representation contains equal number os ones. Example: Input:3(000000000000...
- Ans.
Find the next higher number with equal number of ones in binary representation.
Convert input number to binary
Count number of ones in binary representation
Increment input number until binary representation has equal number of ones
Convert incremented number to decimal
- Q5. An array contain 6 different numbers, only 1 number is repeated for 5 times. So now total 10 numbers in array, Find that duplicate number in 2 steps only?
- Ans.
Find the duplicate number in an array of 10 numbers with only 2 steps.
Use a hash set to keep track of visited numbers.
Iterate through the array and check if the number is already in the set.
If it is, then it is the duplicate number.
If not, add it to the set.
At the end, the duplicate number will be found.
- Q6. Write a program to print elements of a linked list in reverse order by using same single linked list?
- Ans.
Program to print elements of a linked list in reverse order using same single linked list
Traverse the linked list and push each element onto a stack
Pop elements from the stack and print them in reverse order
- Q7. Questions on improving complexity of questions given in coding round
- Q8. Html tags & ct their no of occurance of each tag & also check whether it correct or not?
- Ans.
To check the occurrence and correctness of HTML tags, we can use various tools and techniques.
One way is to use a browser's developer tools to inspect the HTML code and see the tags and their frequency.
Another way is to use an online HTML validator tool that checks for correct syntax and tag usage.
We can also use programming languages like Python to parse HTML and count the occurrence of each tag.
Regular expressions ca...
- Q9. Few questions were on database tables and sql queries?
Interview Preparation Tips
College Name: na
Skills evaluated in this interview
Rachit Vij
Interview Questionnaire
1 Question
- Q1. Questions based on previous written test are asked. Most common being to optimize the solution further
Interview Preparation Tips
Experience: The quantitative section was tougher than usual. There were tricky questions from Trigonometry and Mensuration.
3 Coding Questions were asked. Any programming language including pseudo-code was allowed.
String Manipulation seemed to be a favorite topic
Tips: Go through formulas and shortcuts for the Quantitative Section
Duration: 120 minutes
Total Questions: 40
Round: Test
Experience: 3 Questions. 30 minutes for each. This test was at the company premises.
Tips: Try to have more than one approach figured out.
Duration: 90 minutes
Total Questions: 3
Round: Technical Interview
Experience: Nice and Interactive interview. Interview to test flexibility in approach.
General Tips: Try to communicate well with the Interviewer. Don't hesitate in asking for feedback and advice after the interview is over with.
Skills: Coding, Problem Solving
College Name: NIT BHOPAL
Interview Questionnaire
17 Questions
- Q1. Tell me about yourself?
- Ans.
I am a software developer with experience in multiple programming languages and a passion for problem-solving.
Experienced in Java, C++, and Python
Strong knowledge of data structures and algorithms
Proficient in web development using HTML, CSS, and JavaScript
Familiar with agile development methodologies
Excellent problem-solving and analytical skills
- Q2. Define Automation framework?
- Ans.
Automation framework is a set of guidelines, standards, and coding practices used to create automated test scripts.
It provides a structured way to develop and maintain automated tests
It includes tools, libraries, and reusable components
It helps in reducing the time and effort required for testing
Examples include Selenium, Appium, and Robot Framework
- Q3. Difference between High severity and low severity with example, what is important as QA point of view?
- Ans.
High severity refers to critical defects that impact the core functionality of the software, while low severity refers to minor issues that have minimal impact on functionality.
High severity issues can cause the software to crash or result in data loss.
Low severity issues are cosmetic or minor usability problems.
From a QA point of view, high severity issues are more critical as they can significantly impact the user ex...
- Q4. There one form where username and password and remember-me field is given, write the test scenarios?
- Q5. Around 5-6 more questions
- Q6. Automation architecture?
- Q7. Difference between class and interface?
- Ans.
Class is a blueprint for creating objects while interface defines a contract for classes to implement.
A class can have attributes and methods while an interface only has method signatures.
A class can be instantiated while an interface cannot.
A class can only inherit from one class while it can implement multiple interfaces.
Example: Class - Animal, Interface - Flyable
Animal can have attributes like name, age, etc. and m...
- Q8. What is static keyword?
- Ans.
Static keyword is used to declare a variable or method that belongs to the class rather than an instance of the class.
Static variables are shared among all instances of a class
Static methods can be called without creating an instance of the class
Static blocks are used to initialize static variables
Static keyword can also be used to create nested classes
Example: public static int count;
- Q9. What are the different access modifiers and what is there uses?
- Ans.
Access modifiers control the visibility and accessibility of class members.
Public: accessible from anywhere
Private: accessible only within the class
Protected: accessible within the class and its subclasses
Default: accessible within the same package
Used to enforce encapsulation and prevent unauthorized access
- Q10. Difference between interface and abstract?
- Ans.
Interface defines only method signatures while abstract class can have both method signatures and implementations.
An interface can be implemented by multiple classes while an abstract class can only be extended by one class.
An abstract class can have constructors while an interface cannot.
An abstract class can have instance variables while an interface cannot.
An abstract class can provide default implementations for so...
- Q11. Write a program for given login scenario using defined automation architecture?
- Ans.
A program for login scenario using defined automation architecture.
Identify the elements on the login page such as username, password, and login button
Use automation tools like Selenium to interact with the elements and input data
Verify successful login by checking for expected elements on the landing page
Implement error handling for incorrect login credentials
Use a modular and scalable architecture for maintainability
- Q12. Take an array, store the numbers and print the numbers using arrayList?
- Ans.
To store and print numbers from an array using arrayList.
Create an arrayList object
Loop through the array and add each element to the arrayList using add() method
Print the arrayList using toString() method
Example: int[] arr = {1, 2, 3}; ArrayList
list = new ArrayList<>(); for(int num : arr) { list.add(num); } System.out.println(list.toString());
- Q13. Write test scenario for download functionality of a songs website?
- Ans.
Test scenario for download functionality of a songs website
Verify that the download button is visible and clickable
Check that the downloaded file is in the correct format
Ensure that the downloaded file is not corrupted
Test the download speed for different file sizes
Verify that the download progress is displayed to the user
- Q14. Difference between cache and cookies?
- Ans.
Cache stores data temporarily to reduce server load while cookies store user information for website personalization.
Cache stores frequently accessed data to reduce server load and improve website performance.
Cookies store user information such as login credentials, preferences, and shopping cart items.
Cache is temporary and can be cleared at any time, while cookies can have an expiration date.
Cache is stored on the us...
- Q15. Solve the aptitude questions(2 – 3), she wanted to see the approach?
- Q16. Make a 3*3 cube where you need to fill the numbers using 1-9, rows, columns and diagonal sum should be equal to 15
- Q17. One more puzzle
Interview Preparation Tips
Total Questions: 2
General Tips: Interview Experience was very good
Skills: Algorithm, data structure
College Name: na
Skills evaluated in this interview
Nihal Bisen
Interview Questionnaire
13 Questions
- Q1. Indroduce yourself ?
- Ans.
I am a software developer with experience in various programming languages and frameworks.
Proficient in Java, C++, and Python
Familiar with web development using HTML, CSS, and JavaScript
Experience with database management systems such as MySQL and MongoDB
Strong problem-solving and analytical skills
Worked on projects involving machine learning and artificial intelligence
- Q2. Difference between method overloading and methode overriding ?
- Ans.
Method overloading is having multiple methods with the same name but different parameters. Method overriding is having a subclass method with the same name and parameters as a superclass method.
Method overloading is used to provide different ways of calling the same method with different parameters.
Method overriding is used to provide a specific implementation of a method in a subclass that is already defined in the su...
- Q3. Difference between switch case and if else statement?
- Ans.
Switch case is used for multiple conditions while if else is used for binary conditions.
Switch case is faster than if else for multiple conditions.
If else can handle complex conditions while switch case cannot.
Switch case can only compare values of the same data type.
If else can handle null values while switch case cannot.
Example: switch (day) { case 1: console.log('Monday'); break; case 2: console.log('Tuesday'); brea...
- Q4. What is interface and abstract class?
- Ans.
Interface and abstract class are both used for abstraction in object-oriented programming.
An interface is a collection of abstract methods that define a contract for a class to implement.
An abstract class is a class that cannot be instantiated and may contain abstract methods.
Interfaces are used to achieve multiple inheritance in Java.
Abstract classes can have non-abstract methods and instance variables.
An example of a...
- Q5. Whats is polymorphisom?
- Ans.
Polymorphism is the ability of an object to take on many forms.
It allows objects of different classes to be treated as if they were objects of the same class.
It is achieved through method overriding and method overloading.
Example: A shape class can have multiple subclasses like circle, square, etc. and all can be treated as shapes.
Example: A method can have different implementations in different classes but with the sa
- Q6. What is inherritance ?
- Ans.
Inheritance is a mechanism in object-oriented programming where a new class is created by inheriting properties of an existing class.
Inheritance allows code reusability and saves time and effort in writing new code.
The existing class is called the parent or base class, and the new class is called the child or derived class.
The child class inherits all the properties and methods of the parent class and can also add its ...
- Q7. Default case in switch case
- Ans.
Default case in switch case statement
Default case is executed when no other case matches the switch expression
It is optional and can be placed anywhere in the switch statement
It is often used to handle unexpected input or errors
It should always be the last case in the switch statement
- Q8. Introduce yourself apart from resume?
- Ans.
I am a passionate software developer with a strong background in web development and a love for problem-solving.
Experienced in HTML, CSS, JavaScript, and various web development frameworks
Proficient in backend development using languages like Java, Python, and Node.js
Familiar with database management systems such as MySQL and MongoDB
Strong problem-solving skills and ability to work well in a team environment
- Q9. What is your weaknesses ?
- Ans.
I tend to get overly focused on details, which can sometimes slow down my progress.
I have a tendency to spend too much time on perfecting small details
I sometimes struggle with prioritizing tasks due to my focus on details
I am working on improving my time management skills to balance detail-oriented work with efficiency
- Q10. Do you have any offer from any other company ?
- Ans.
Yes, I have received offers from two other companies.
Received offers from Company A and Company B
Currently evaluating all offers to make an informed decision
Considering factors like company culture, growth opportunities, and compensation
- Q11. Which company would you like to join apart from sapient ?
- Ans.
I would like to join Google because of their innovative projects and work culture.
Google is known for its cutting-edge technology and innovative projects.
They have a strong focus on employee well-being and work-life balance.
Google offers opportunities for career growth and development.
The company has a diverse and inclusive work culture.
Google is a leader in the tech industry with a global presence.
- Q12. Have you ever worked in a team?
- Ans.
Yes, I have worked in multiple teams in various projects.
Worked in a team of developers to create a new software application
Collaborated with designers, testers, and project managers to meet project deadlines
Participated in daily stand-up meetings to discuss progress and roadblocks
- Q13. 8 metals bolls are similar ?
- Ans.
Yes, they are similar.
All 8 metal balls are of the same material.
They have the same size and weight.
They have the same physical properties.
They are interchangeable in any given situation.
Interview Preparation Tips
Skills evaluated in this interview
Interview Questionnaire
11 Questions
- Q1. What is the difference between C and C++?
- Ans.
C++ is an extension of C with object-oriented programming features.
C++ supports classes and objects while C does not.
C++ has better support for polymorphism and inheritance.
C++ has a standard template library (STL) which C does not have.
C++ allows function overloading while C does not.
C++ has exception handling while C does not.
- Q2. What is the difference between for and while loop?
- Ans.
For loop is used for iterating over a sequence while while loop is used for iterating until a condition is met.
For loop is used when the number of iterations is known beforehand
While loop is used when the number of iterations is not known beforehand
For loop is faster than while loop for iterating over a sequence
While loop is useful for iterating until a specific condition is met
For loop can be used with range() functio...
- Q3. Write a program to add two numbers without using + operator
- Q4. How to you reverse a string without using any looping and inbuilt functions?
- Ans.
To reverse a string without using any looping and inbuilt functions, we can use recursion.
Create a function that takes a string as input.
If the length of the string is 0 or 1, return the string.
Otherwise, call the function recursively with the substring starting from the second character and concatenate the first character at the end.
Return the reversed string.
Example: reverseString('hello') returns 'olleh'.
- Q5. How many queues will you use to implement a priority queue?
- Ans.
A priority queue can be implemented using a single queue or multiple queues.
One approach is to use a single queue and assign priorities to elements using a separate data structure.
Another approach is to use multiple queues, each representing a different priority level.
For example, if there are three priority levels, three queues can be used to implement the priority queue.
- Q6. Which datastructure would you use to implement an heteregenous array?
- Ans.
An array of objects can be used to implement a heterogeneous array.
Each element in the array can be an object that represents a different data type.
The objects can have different properties and methods based on their respective data types.
For example, an element can be an object representing a string with a 'value' property and a 'length' method.
- Q7. Tell me about yourself?
- Q8. Describe your project?
- Ans.
Developed a web-based inventory management system for a retail company.
Used HTML, CSS, and JavaScript for the front-end development.
Implemented a RESTful API using Node.js and Express for the back-end.
Utilized a MySQL database to store and manage inventory data.
Implemented features like product search, order management, and reporting.
Ensured data security and user authentication using encryption and JWT.
Collaborated wi...
- Q9. You are given a match-box and two candles of equal size, which can burn 1 hour each. You have to measure 90 minutes with these candles. (There is no scale or clock). How do you do?
- Q10. You have 8 balls which are identical(completely). You are given a weighing scale. How many times would you measure to get the odd ball out?
- Q11. Three friends rent a room for Rs.30 by paying Rs.10 each. The owner decides to give them a discount Rs.5 and gives it to the broker. The broker who a cunning man takes Rs.2. and returns one rupee to each ...
- Ans.
The missing rupee is not actually missing. The calculation is misleading and does not account for the total amount paid.
The initial amount paid by each person was Rs.10, totaling Rs.30.
The owner gave them a discount of Rs.5, so they paid Rs.25 in total.
The broker took Rs.2, leaving them with Rs.23.
When the broker returned Rs.1 to each person, they each received Rs.1 back, totaling Rs.3.
So, the total amount paid by the ...
Interview Preparation Tips
Experience: Let me share my interview process with Sapient. As I did not find any helpful papers before attending interview.The initial test was amcat test, which consisted of aptitude, english comprehension(which was annoying because they ask a lot of unknown word meanings), C and C++ basic concepts. I cleared that test.
Round: Technical Interview
Experience: There are 2 interviews round
1) Technical
2) HR
General Tips: Bond: 1.5 yearEligibility Criteria : Greater than 6.5 CGPA
Skills: C++, Java, Algorithm
College Name: NA
Motivation: Sapient, Trust me it’s an awesome company .Be strong in technical area.
Skills evaluated in this interview
Virtusa Consulting Services Interview FAQs
Tell us how to improve this page.
Virtusa Consulting Services Interviews By Designations
- Virtusa Consulting Services Associate Engineer Interview Questions
- Virtusa Consulting Services Software Engineer Interview Questions
- Virtusa Consulting Services Software Developer Interview Questions
- Virtusa Consulting Services Senior Consultant Interview Questions
- Virtusa Consulting Services Lead Consultant Interview Questions
- Virtusa Consulting Services Associate Software Engineer Interview Questions
- Virtusa Consulting Services Associate Consultant Interview Questions
- Virtusa Consulting Services Consultant Interview Questions
- Show more
Interview Questions for Popular Designations
- Front end Developer Interview Questions
- Web Developer Interview Questions
- Backend Developer Interview Questions
- Software Developer Intern Interview Questions
- Junior Software Developer Interview Questions
- Full Stack Software Developer Interview Questions
- PHP Developer Interview Questions
- UI Developer Interview Questions
- Show more
Virtusa Consulting Services SQL Developer Interview Process for Freshers
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
Virtusa Consulting Services SQL Developer Reviews and Ratings
based on 4 reviews
Rating in categories
|
Senior Consultant
3.8k
salaries
|  ₹8 L/yr - ₹30 L/yr |
|
Lead Consultant
3.5k
salaries
| ₹10.5 L/yr - ₹34.6 L/yr |
|
Software Engineer
3.3k
salaries
| ₹3.5 L/yr - ₹13.3 L/yr |
|
Consultant
3.3k
salaries
| ₹6 L/yr - ₹20 L/yr |
|
Associate Consultant
2.7k
salaries
| ₹4.6 L/yr - ₹15.2 L/yr |
Cognizant
TCS
Infosys
Accenture
- Home >
- Interviews >
- Virtusa Consulting Services Interview Questions >
- Virtusa Consulting Services SQL Developer Interview Questions for Fresher
