Upload Button Icon Add office photos

Filter interviews by

Virtusa Consulting Services Plsql Developer Interview Questions and Answers for Experienced

Updated 30 Aug 2024

Virtusa Consulting Services Plsql Developer Interview Experiences for Experienced

2 interviews found

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-

I applied via Job Portal

Round 1 - HR 

(1 Question)

  • Q1. What is plsql and sql
  • Ans. 

    PL/SQL is a procedural extension of SQL used for writing stored procedures, functions, triggers, and packages in Oracle databases.

    • PL/SQL stands for Procedural Language/Structured Query Language

    • It is used to write procedural code like stored procedures, functions, triggers, and packages in Oracle databases

    • SQL (Structured Query Language) is a standard language for accessing and manipulating databases

    • SQL is used to query,...

  • Answered by AI
Round 2 - Coding Test 

Questions on plsql and sql in general

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via Naukri.com and was interviewed in Jun 2023. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Coding Test 

3omins of coding knowledge testing

Round 3 - Technical 

(2 Questions)

  • Q1. Client round to check the pervious project knowledge, present requirement testing
  • Q2. Tell me about your current project
Round 4 - HR 

(1 Question)

  • Q1. Basicaly salary negotiation

Plsql Developer Interview Questions Asked at Other Companies for Experienced

asked in TCS
Q1. What is temp table and temp variable in plsql?
asked in TCS
Q2. What is procedure in plsql and it's syntax and difference between ... read more
asked in TCS
Q3. A plsql programme to print 103,99,96...3?
asked in TCS
Q4. What is mutating table or mutating trigger?
asked in Cognizant
Q5. Write a sql to delete duplicate records from a table

Interview questions from similar companies

Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Monster

Round 1 - Technical 

(3 Questions)

  • Q1. Write query to get result based on hughest salary
  • Ans. 

    Use SQL query with ORDER BY clause to get result based on highest salary

    • Use SELECT statement to retrieve data from the table

    • Use ORDER BY clause with DESC keyword to sort salaries in descending order

    • Use LIMIT or FETCH FIRST clause to limit the result to only one row

  • Answered by AI
  • Q2. Writw merge query
  • Q3. Bulk collect and bulk binding difference
  • Ans. 

    Bulk collect is used to fetch multiple rows into collections at once, while bulk binding is used to bind collections to SQL statements for improved performance.

    • Bulk collect fetches multiple rows into collections in a single operation, reducing context switches and improving performance.

    • Bulk binding binds collections to SQL statements, reducing the number of context switches between the PL/SQL engine and SQL engine.

    • Bulk...

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(4 Questions)

  • Q1. Difference between delete, drop and truncate
  • Ans. 

    Delete removes rows from a table, drop removes the entire table, and truncate removes all rows from a table.

    • Delete is a DML operation and can be rolled back, but it is slower than truncate.

    • Drop is a DDL operation and cannot be rolled back. It removes the table and all associated objects.

    • Truncate is a DDL operation and cannot be rolled back. It removes all rows from the table but keeps the table structure.

    • Delete and tru...

  • Answered by AI
  • Q2. Difference between table and view
  • Ans. 

    Table stores data in a structured format while view is a virtual table created from a query.

    • Table is a physical object while view is a logical object.

    • Table can be modified while view cannot be modified directly.

    • Table can have indexes while view cannot have indexes.

    • Table can have constraints while view cannot have constraints.

    • View can be used to simplify complex queries by joining multiple tables.

    • View can be used to res...

  • Answered by AI
  • Q3. What type of cursors did you use
  • Ans. 

    I have used both implicit and explicit cursors in PL/SQL development.

    • Implicit cursors are used for single-row queries while explicit cursors are used for multi-row queries.

    • I have used explicit cursors with parameters to make the query more dynamic.

    • I have also used cursor variables to pass cursors as parameters to procedures and functions.

    • Examples of cursor types I have used include FOR LOOP, FETCH, and UPDATE cursors.

  • Answered by AI
  • Q4. What is primary key and unique key
  • Ans. 

    Primary key uniquely identifies a record in a table, while unique key ensures uniqueness of a column or set of columns.

    • Primary key is a column or set of columns that uniquely identifies each record in a table

    • Unique key ensures that a column or set of columns have unique values

    • Primary key cannot have null values, while unique key can have null values

    • A table can have only one primary key, but multiple unique keys

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident in the interview.
Frame your answer correctly.if you don't know any complex question ask the interviewer at the end

Skills evaluated in this interview

Interview Preparation Tips

Round: Resume Shortlist
Experience: 4 years og experience

Interview Preparation Tips

Round: Test
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 

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.

  • Answered by AI
  • 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

  • Answered by AI
  • 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...

  • Answered by AI
  • 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

Round: Test
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

Interview Preparation Tips

Round: HR Interview
Experience: This interview is meant to check candidate's background and candidates's interest towards the company.

College Name: NIT BHOPAL

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.

  • Answered by AI
  • 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.

  • Answered by AI
  • Q4. TELL ME ABOUT YOURSELF
  • Q5. QUOTE YOUR STRENGHTS AND WEAKNESS
  • Q6. WHY SHOULD I HIRE YOU?

Interview Preparation Tips

Round: Test
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 Questionnaire 

1 Question

  • Q1. Questions based on previous written test are asked. Most common being to optimize the solution further

Interview Preparation Tips

Round: Test
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

Virtusa Consulting Services Interview FAQs

How many rounds are there in Virtusa Consulting Services Plsql Developer interview for experienced candidates?
Virtusa Consulting Services interview process for experienced candidates usually has 3 rounds. The most common rounds in the Virtusa Consulting Services interview process for experienced candidates are Coding Test, HR and Resume Shortlist.
How to prepare for Virtusa Consulting Services Plsql Developer interview for experienced candidates?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Virtusa Consulting Services. The most common topics and skills that interviewers at Virtusa Consulting Services expect are PLSQL, SQL, Performance Tuning, Oracle and Oracle SQL.
What are the top questions asked in Virtusa Consulting Services Plsql Developer interview for experienced candidates?

Some of the top questions asked at the Virtusa Consulting Services Plsql Developer interview for experienced candidates -

  1. What is plsql and ...read more
  2. client round to check the pervious project knowledge, present requirement testi...read more

Tell us how to improve this page.

Virtusa Consulting Services Plsql Developer Interview Process for Experienced

based on 2 interviews

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

Genpact Interview Questions
3.8
 • 3.2k Interviews
DXC Technology Interview Questions
3.7
 • 804 Interviews
Nagarro Interview Questions
4.0
 • 765 Interviews
NTT Data Interview Questions
3.8
 • 629 Interviews
Publicis Sapient Interview Questions
3.5
 • 623 Interviews
GlobalLogic Interview Questions
3.6
 • 594 Interviews
UST Interview Questions
3.8
 • 520 Interviews
CGI Group Interview Questions
4.0
 • 495 Interviews
View all
Virtusa Consulting Services Plsql Developer Salary
based on 113 salaries
₹4 L/yr - ₹14.9 L/yr
43% more than the average Plsql Developer Salary in India
View more details

Virtusa Consulting Services Plsql Developer Reviews and Ratings

based on 11 reviews

3.4/5

Rating in categories

3.8

Skill development

3.3

Work-life balance

3.0

Salary

2.5

Job security

2.9

Company culture

2.7

Promotions

3.0

Work satisfaction

Explore 11 Reviews and Ratings
Senior Consultant
3.8k salaries
unlock blur

₹8 L/yr - ₹30 L/yr

Lead Consultant
3.5k salaries
unlock blur

₹10.5 L/yr - ₹34.6 L/yr

Software Engineer
3.3k salaries
unlock blur

₹3.5 L/yr - ₹13.3 L/yr

Consultant
3.3k salaries
unlock blur

₹6 L/yr - ₹20 L/yr

Associate Consultant
2.7k salaries
unlock blur

₹4.6 L/yr - ₹15.2 L/yr

Explore more salaries
Compare Virtusa Consulting Services with

Cognizant

3.7
Compare

TCS

3.7
Compare

Infosys

3.6
Compare

Accenture

3.8
Compare
Did you find this page helpful?
Yes No
write
Share an Interview