Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by GlobalLogic Team. If you also belong to the team, you can get access from here

GlobalLogic Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

GlobalLogic Plsql Developer Interview Questions, Process, and Tips

Updated 12 Jan 2023

GlobalLogic Plsql Developer Interview Experiences

1 interview found

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 questions from similar companies

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Job Portal and was interviewed before Mar 2023. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Sql questions basic
Round 2 - Technical 

(1 Question)

  • Q1. Sql intermediate questions and jira and other daily tools
Round 3 - HR 

(1 Question)

  • Q1. Salary and other basic

Interview Preparation Tips

Interview preparation tips for other job seekers - as less experienced interview will be easy
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
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
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

Interview Preparation Tips

Round: Resume Shortlist
Experience: 4 years og experience

I appeared for an interview before May 2016.

Interview Questionnaire 

1 Question

  • Q1. I was given a paragraph to read and was asked to narrate the last movie i saw

Interview Preparation Tips

Round: Test
Experience: We were given reasoning questions and topics for essay
Tips: Be calm when solving the reasoning questions and focus on your spellings and vocab while writing the essay
Duration: 5 minutes

Round: Case Study Interview
Experience: I first narrated the paragraph that was given to me then the story of the last movie that i saw
Tips: Patience and story flow is all one needs to concentrate on

Skills: Communication And Confidence
College Name: SD college

Interview Preparation Tips

Round: Test
Experience: In the first round there was an online test. Questions were from aptitude, general English and a simple code( very simple if you have programming skills).
Tips: It was purely a knowledge based round so everything depends on your preparation level and a bit confidence.

Round: Technical Interview
Experience: In technical round interview the process was like this...
I entered in room and greeted interviewer and he asked me to sit down. I handed over my resume to him. His first question was tell me about yourself. Then my projects. After that he came on programming, He asked me very basic concept about C++. Questions were like what is polymorphism, What is encapsulation. He also asked program of fibonacci series. After all these question he again looked at my resume and asked me 'why your CGPA is low?' I said that when i was in my first year i had interest in electronics but later when i encountered with programming i decided to have my career in this field so i could not concentrate on my core subjects.
Tips: C++ is '''''must''''' for Virtusa if you are from electronics . I didn't know data structure but c++ was on my fingers. Answer question with confidence.

Round: HR Interview
Experience: HR interview was really cool. Interview asked me about myself, my family, real life applications of my project. After that he came on real stuff. He asked question like why do you want to join virtusa? I said virtusa is this .. virtusa is this.....and many more..and in last i said this is i want to join virtusa. Next question was ' what do think about dowry?'. At first i was surprised to hear this question but i realized that interview only want to check my ability to speak on random topic. I answered the question by criticizing dowry and he was pleased to hear my answer. After one or two general HR question like location preference , he told me that your interview is over please wait outside for result. It was really nice to meet you . Thank you.
Tips: Never stop speaking in HR interview. They only check your ability to speak on random topics and their general HR question. I was continuously speaking ...please do not bother about grammar while speaking ...just speak with confidence(relevant).

General Tips: prepare c , c++ and ability to speak in front of interviewer.
Skills: Basic Coding, Aptitude, 1)communication
College Name: NIT Jalandhar

Interview Preparation Tips

Round: Test
Experience: Quite easy..It contains mcq and one programming question. MCQ covers databases,sql,software testing,c++
Tips: You can easily pass the test,no need to worry

Round: Interview
Experience: Questions are among databases and java,they will ask u fav subj and asks questions in that
Tips: Through with ur fav subject..be confident, simple anad basic questions,try to solve secreening test question using java language

Round: Interview
Experience: Its better to say technical only,the hr also asks about test pattren.programming question.then normal HR questions
Tips: It better to do some research about the company,overall it's easy and cake walk for those who are strong in java and databases

General Tips: CSE guys can easily clear that test and interview..without any hesitattion
Skills: Java,databases, SQL, C, General Aptitude
College Name: NIT Warangal
Motivation: Virtusa is emerging company
Funny Moments: In interview they asked about my girl friend,her name andwhen ur are going to marry. answer them in a funny way with smile in your face

Interview Questionnaire 

2 Questions

  • Q1. What's a Single Ops tool?
  • Ans. 

    Single Ops tool is a software that helps businesses manage their operations from a single platform.

    • It streamlines processes and improves efficiency

    • It can include features like scheduling, inventory management, and invoicing

    • Examples include ServiceTitan, Jobber, and Housecall Pro

  • Answered by AI
  • Q2. Tell me about yourself
  • Ans. 

    I am a dedicated and hardworking individual with a passion for learning and growth.

    • I have a background in marketing and have worked in the industry for 5 years.

    • I am currently pursuing a Master's degree in Business Administration to further my skills and knowledge.

    • I am a team player and enjoy collaborating with others to achieve common goals.

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: We had screening test in which 15 out of 40 were shortlisted
Tips: Be quick , skip the difficult ones
Duration: 20 minutes
Total Questions: 60

Round: Group Discussion
Experience: Had a brief discussion on the topic.Started the conversation and did positive contribution.
Tips: Speak with confidence , maintain eye contact with everyone .
Duration: 15 minutes

Round: Technical Interview
Experience: Have been asked around 10-15 questions , difficulty is moderate

Round: HR Interview
Experience: Open loop questions
Tips: Be realistic and keep it short

College Name: Malla Reddy Institute Of Engineering & Technology ( MRIET )

Skills evaluated in this interview

GlobalLogic Interview FAQs

How many rounds are there in GlobalLogic Plsql Developer interview?
GlobalLogic interview process usually has 2 rounds. The most common rounds in the GlobalLogic interview process are Resume Shortlist and Technical.
What are the top questions asked in GlobalLogic Plsql Developer interview?

Some of the top questions asked at the GlobalLogic Plsql Developer interview -

  1. What type of cursors did you ...read more
  2. What is primary key and unique ...read more
  3. Difference between delete, drop and trunc...read more

Tell us how to improve this page.

GlobalLogic Plsql Developer Interview Process

based on 1 interview

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
 • 802 Interviews
Nagarro Interview Questions
4.0
 • 763 Interviews
NTT Data Interview Questions
3.8
 • 627 Interviews
Publicis Sapient Interview Questions
3.5
 • 621 Interviews
UST Interview Questions
3.8
 • 518 Interviews
CGI Group Interview Questions
4.0
 • 493 Interviews
View all
GlobalLogic Plsql Developer Salary
based on 6 salaries
₹3.5 L/yr - ₹13 L/yr
25% more than the average Plsql Developer Salary in India
View more details
Associate Analyst
4k salaries
unlock blur

₹1.2 L/yr - ₹5 L/yr

Senior Software Engineer
3.4k salaries
unlock blur

₹5.2 L/yr - ₹25.1 L/yr

Analyst
3.2k salaries
unlock blur

₹1.2 L/yr - ₹5.5 L/yr

Software Engineer
3k salaries
unlock blur

₹3.2 L/yr - ₹12.7 L/yr

Associate Consultant
2.9k salaries
unlock blur

₹9.2 L/yr - ₹33 L/yr

Explore more salaries
Compare GlobalLogic with

Genpact

3.8
Compare

DXC Technology

3.7
Compare

Sutherland Global Services

3.6
Compare

Optum Global Solutions

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