AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Virtusa Consulting Services Oracle SQL and PLSQL Developer Interview Questions and Answers
Virtusa Consulting Services Oracle SQL and PLSQL Developer Interview Experiences
2 interviews found
I appeared for an interview in Mar 2025, where I was asked the following questions.
- Q1. Has AI generative interview
- Q2. Asked about performance tunning
(5 Questions)
- Q1. How to use Reference cursor in procedure
- Ans.
Reference cursor in procedure is used to return result sets from a stored procedure.
Declare a cursor variable in the procedure using TYPE keyword
Open the cursor variable using OPEN keyword
Fetch data from the cursor using FETCH keyword
Close the cursor using CLOSE keyword after fetching all data
- Q2. Use of lead ,lag functions
- Ans.
Lead and lag functions are used to access data from a subsequent or previous row in a result set.
Lead function is used to access data from the next row in the result set.
Lag function is used to access data from the previous row in the result set.
Both functions can be used to compare values between rows or calculate differences.
- Q3. Can you update in function
- Ans.
Yes, you can update in a function in Oracle SQL and PLSQL.
You can use the UPDATE statement within a PLSQL function to update data in a table.
Make sure to commit the changes using COMMIT statement.
Example: CREATE OR REPLACE FUNCTION update_employee_salary(emp_id IN NUMBER, new_salary IN NUMBER) RETURN NUMBER IS BEGIN UPDATE employees SET salary = new_salary WHERE employee_id = emp_id; COMMIT; RETURN 1; END;
- Q4. Can you commit in trigger
- Ans.
No, you cannot commit in a trigger as it can cause mutating table errors.
Triggers cannot contain COMMIT or ROLLBACK statements.
Committing in a trigger can lead to mutating table errors.
Instead, use triggers for data validation, not for committing transactions.
- Q5. What is autonomous transaction
- Ans.
Autonomous transaction is a separate transaction that is independent of the main transaction.
Autonomous transactions are used to perform certain tasks independently of the main transaction.
They are useful for logging, auditing, or error handling purposes.
Autonomous transactions are started with the PRAGMA AUTONOMOUS_TRANSACTION statement.
Changes made in an autonomous transaction are not visible to the main transaction ...
Skills evaluated in this interview
Interview questions from similar companies
Interview Questionnaire
4 Questions
- Q1. All questions about java only. 1. Different between interface and abstract class . 2.questions on rest Threads 3.java object on hashcode 4. Previous company projects
- Q2. All about java 1. Explain collection hierarchy 2.Explain exception hierarchy 3.how many of classes in java 4.what are problem u faced while deploying the project and etc on deployment
- Ans.
Collection hierarchy in Java includes interfaces like Collection, List, Set, Queue, and Map with their respective implementations.
Collection interface is the root interface in the collection hierarchy
List interface extends Collection and allows duplicate elements, with implementations like ArrayList and LinkedList
Set interface extends Collection and does not allow duplicate elements, with implementations like HashSet a...
- Q3. What will be work if hire . And
- Q4. All about package and joining date
I appeared for an interview in Jun 2017.
Interview Questionnaire
2 Questions
- Q1. What is use of OOO programming?
- Ans.
Object-oriented programming (OOP) is a programming paradigm that uses objects to represent and manipulate data.
Encourages modular and reusable code
Provides a clear structure and organization to the code
Allows for easier maintenance and updates
Supports code reusability through inheritance and polymorphism
Enables encapsulation, hiding the internal details of an object
Promotes code extensibility and scalability
Facilitates...
- Q2. Why do you want to join ATOS?
- Ans.
I want to join ATOS because of their reputation for innovation and their commitment to employee growth and development.
ATOS is known for its innovative solutions in the software development industry.
I am impressed by ATOS's focus on employee growth and development through training programs and career advancement opportunities.
ATOS has a strong reputation for delivering high-quality software solutions to its clients.
I b...
Interview Preparation Tips
Experience: He asked about technical topics and I gave answer with example.
Tips: Be ready with what you have written in CV with real scenario.
Round: HR Interview
Experience: She asked about reason to join, why leaving previous comp.etc
Tips: Explain your ambition and this company will provide me opportunities to fulfill those. Be realstic in answer. Should know about the company.
What people are saying about Virtusa Consulting Services
I applied via Approached by Company and was interviewed before May 2018. There was 1 interview round.
Interview Questionnaire
2 Questions
- Q1. Core Java questions except multi threading. New features in java 8. Basic spring boot questions. Sorting algorithm. Comparable and comparator interface. Focus on core java
- Q2. Core java. Custom hasmmap implementation.
Interview Preparation Tips
Skills: Problem Solving, Analytical Skills
Duration: <1 week
I applied via Naukri.com and was interviewed before Jul 2021. There were 2 interview rounds.
(1 Question)
- Q1. Java 8, Collection, Multithreading
(1 Question)
- Q1. Spring boot, HIbernate, Microservices
Interview Preparation Tips
I applied via Campus Placement and was interviewed in Sep 2020. There were 3 interview rounds.
Interview Questionnaire
4 Questions
- Q1. 1. Introduce yourself?
- Q2. 2.Why DXC?
- Q3. 3.As a non-IT why to software? (I'm from ece)
- Q4. 4. About your weakness and how you overcome it?
Interview Preparation Tips
All the best ✊
Thankyou 😊
Software Developer Interview Questions & Answers
Optum Global Solutions
Anonymous
posted on 12 Dec 2021
I appeared for an interview before Dec 2020.
(1 Question)
Round duration - 75 minutes
Round difficulty - Medium
- Q1.
Array Intersection Problem Statement
Given two integer arrays/ lists
ARR1andARR2of sizesNandMrespectively, you are required to determine their intersection. An intersection is defined as the set of... - Ans.
Find the intersection of two integer arrays/lists in the order they appear in the first array/list.
Iterate through the elements of the first array/list and check if they exist in the second array/list.
Use a hash set to store elements of the first array/list for efficient lookups.
Print the common elements in the order they appear in the first array/list.
(1 Question)
Round duration - 40 minutes
Round difficulty - Medium
- Q1.
Longest Palindromic Substring Problem Statement
You are provided with a string
STRof length N. The task is to find the longest palindromic substring withinSTR. If there are several palindromic substring... - Ans.
Find the longest palindromic substring in a given string.
Iterate through the string and expand around each character to find palindromes
Keep track of the longest palindrome found so far
Return the longest palindromic substring
Round duration - 30 minutes
Round difficulty - Medium
Interview Preparation Tips
Tip 1 : Practice coding questions
Tip 2 : Prepare data structures well
Tip 1 : Mention good projects
Tip 2 : Do not put false information
Skills evaluated in this interview
Software Developer Interview Questions & Answers
Sutherland Global Services
Gayathri
posted on 9 Jan 2022
I applied via Company Website and was interviewed in Dec 2021. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. How will be the self learn and growth
- Ans.
I believe in continuous learning and growth through self-study, online courses, and attending conferences.
I regularly read technical blogs and articles to stay updated with the latest trends and technologies.
I take online courses and tutorials to learn new skills and improve my existing ones.
I attend conferences and meetups to network with other professionals and learn from their experiences.
I also participate in hacka...
Interview Preparation Tips
I applied via Referral and was interviewed before Nov 2021. There were 3 interview rounds.
(3 Questions)
- Q1. Javascript basic questions
- Q2. React js basic questions
- Q3. Html and css questions?
(2 Questions)
- Q1. Tell me about urself?
- Q2. Good and Bad quality
Interview Preparation Tips
- Javascript
Answer only what Is required
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 Lead Consultant Interview Questions
- Virtusa Consulting Services Senior Consultant Interview Questions
- Virtusa Consulting Services Associate Software Engineer Interview Questions
- Virtusa Consulting Services Associate Consultant Interview Questions
- Virtusa Consulting Services Senior Software Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
- Software Developer Interview Questions
- Java Developer Interview Questions
- Project Engineer Interview Questions
- Web Developer Interview Questions
- Senior Software Developer Interview Questions
- Application Developer Interview Questions
- Salesforce Developer Interview Questions
- Developer Interview Questions
- Show more
Overall Interview Experience Rating
based on 2 interview experiences
Difficulty level
Interview Questions from Similar Companies
|
Senior Consultant
3.7k
salaries
|  ₹14 L/yr - ₹26 L/yr |
|
Software Engineer
3.5k
salaries
| ₹4.3 L/yr - ₹13.3 L/yr |
|
Lead Consultant
3.3k
salaries
| ₹17.1 L/yr - ₹29 L/yr |
|
Consultant
3.2k
salaries
| ₹9.7 L/yr - ₹16.8 L/yr |
|
Associate Consultant
2.6k
salaries
| ₹8.1 L/yr - ₹14 L/yr |
Cognizant
TCS
Infosys
Accenture
- Home >
- Interviews >
- Virtusa Consulting Services Interview Questions
