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
3.7

based on 4.3k Reviews

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
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
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
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
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Oct 2024. There were 2 interview rounds.

Round 1 - Technical 

(5 Questions)

  • Q1. I am fine or not
  • Q2. I want this job
  • Q3. I want information for selected in job and interview
  • Q4. And I want the company your details and related studies details
  • Q5. And it will be a good job for me so please select in this company for my family situation
Round 2 - Group Discussion 

Group discussion related in company

Interview Preparation Tips

Interview preparation tips for other job seekers - Mmm
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Jul 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

Easy exam sample available on youtube

Round 2 - Technical 

(2 Questions)

  • Q1. What are step functions.
  • Ans. 

    Step functions are a type of serverless function that allow you to create workflows by chaining multiple functions together.

    • Step functions are used to coordinate multiple AWS services into serverless workflows.

    • They allow you to define a series of steps in a workflow, with each step being a separate function.

    • You can use step functions to handle complex business logic, long-running processes, and error handling.

    • Step func...

  • Answered by AI
  • Q2. How to scale lambdas
  • Ans. 

    Scaling lambdas involves optimizing memory usage, increasing concurrency, and managing dependencies.

    • Optimize memory usage by reducing unnecessary variables and objects

    • Increase concurrency by using asynchronous programming and parallel processing

    • Manage dependencies by breaking down functions into smaller, more modular components

    • Consider using AWS Lambda Provisioned Concurrency for consistent performance

  • Answered by AI
Round 3 - Behavioral 

(1 Question)

  • Q1. How did you handled a difficult collegelue
  • Ans. 

    I addressed the issue directly and professionally, seeking to understand their perspective and find common ground.

    • Approached the colleague privately to discuss the issue

    • Listened actively to their concerns and perspective

    • Sought to find common ground and reach a resolution

    • Maintained professionalism and respect throughout the conversation

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Managerial round. Behavioral and cloud technology scenario based questions. Interviewer very friendly and open

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Coding test was around 2 hrs

Round 2 - One-on-one 

(2 Questions)

  • Q1. What is kubernets
  • Ans. 

    Kubernetes is an open-source container orchestration platform for automating deployment, scaling, and management of containerized applications.

    • Kubernetes helps in automating the deployment, scaling, and management of containerized applications.

    • It allows for easy scaling of applications by adding or removing containers based on demand.

    • Kubernetes provides features like load balancing, self-healing, and rolling updates fo...

  • Answered by AI
  • Q2. What is docker container runtime
  • Ans. 

    Docker container runtime is the engine that executes containers, managing their lifecycle and resources.

    • Docker container runtime is responsible for running and managing Docker containers.

    • It provides an isolated environment for applications to run without affecting the host system.

    • Popular container runtimes include Docker Engine, containerd, and CRI-O.

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Array qs reverse
  • Q2. Question about angular and react
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in Feb 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Asked simple tricky questions

Round 2 - Technical 

(2 Questions)

  • Q1. Class Dependency Injection
  • Q2. Questions was asked from oops concepts

Interview Preparation Tips

Topics to prepare for Publicis Sapient PHP Developer interview:
  • OOPS
  • Laravel
  • PHP
  • MySQL
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

2 question 1 easy 2 medium dsa

Round 2 - Coding Test 

2 codes of dsa and mcq.

Round 3 - Technical 

(2 Questions)

  • Q1. Code paring round
  • Q2. Dsa question of graph

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 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
3.8k salaries
unlock blur

₹1 L/yr - ₹4 L/yr

Senior Software Engineer
3.3k salaries
unlock blur

₹5.2 L/yr - ₹22 L/yr

Analyst
3.1k salaries
unlock blur

₹1 L/yr - ₹5.5 L/yr

Software Engineer
2.9k salaries
unlock blur

₹3 L/yr - ₹13 L/yr

Associate Consultant
2.7k salaries
unlock blur

₹9 L/yr - ₹32 L/yr

Explore more salaries
Compare GlobalLogic with

TCS

3.7
Compare

Wipro

3.7
Compare

Infosys

3.7
Compare

HCLTech

3.5
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview