Upload Button Icon Add office photos
Engaged Employer

i

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

Capco Technologies Verified Tick

Compare button icon Compare button icon Compare
3.7

based on 491 Reviews

Filter interviews by

Capco Technologies Plsql Developer Interview Questions and Answers

Updated 9 Jun 2024

Capco Technologies Plsql Developer Interview Experiences

1 interview found

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

(2 Questions)

  • Q1. What is dirty read
  • Ans. 

    Dirty read is when a transaction reads data that has been modified by another transaction but not yet committed.

    • Occurs when a transaction reads uncommitted data from another transaction

    • Can lead to inconsistent or incorrect results

    • Can be prevented by using proper isolation levels in database transactions

  • Answered by AI
  • Q2. Count of rows in inner join, left join, right join
  • Ans. 

    Count of rows in different types of joins in SQL

    • Inner join: Counts only the rows that have matching values in both tables

    • Left join: Counts all rows from the left table and the matching rows from the right table

    • Right join: Counts all rows from the right table and the matching rows from the left table

  • Answered by AI

Skills evaluated in this interview

Plsql Developer Jobs at Capco Technologies

View all

Interview questions from similar companies

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 Jun 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. STORED PROCEDURE
  • Q2. CURSOR AND FUNCTION

Interview Preparation Tips

Interview preparation tips for other job seekers - UPDATE YOURSELF AND ATTEND THE INTERVIEW
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Basic SQL questions
  • Q2. Advanced PLSQL questions
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected
Round 1 - Coding Test 

DSA based on any general language prefer C++

Round 2 - Technical 

(3 Questions)

  • Q1. DBMS, BST, Sieve of Erathnus, Dynamic Programming
  • Q2. Debugging c++ code
  • Q3. OOPS based question
Round 3 - HR 

(1 Question)

  • Q1. General questions and some questions on personality
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Job Portal and was interviewed in Nov 2024. There were 2 interview rounds.

Round 1 - One-on-one 

(1 Question)

  • Q1. What is your approach to building basic logic skills?
  • Ans. 

    My approach to building basic logic skills involves practicing problem-solving exercises, breaking down complex problems into smaller parts, and seeking feedback to improve.

    • Practice problem-solving exercises regularly to strengthen logical thinking abilities.

    • Break down complex problems into smaller, more manageable parts to better understand the problem and find solutions.

    • Seek feedback from peers or mentors to identify...

  • Answered by AI
Round 2 - One-on-one 

(1 Question)

  • Q1. Some behavioural questions?
Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Basics about angular
  • Q2. Javascript concepts

Interview Preparation Tips

Interview preparation tips for other job seekers - "I attended an interview with this company and waited for a couple of days for a response. When I tried contacting HR, specifically Prasanna Lekkalapudi, she kept disconnecting my calls. In her text responses, she was unprofessional and dismissive, even stating that she doesn't care about my feedback. She mentioned that she has seen many people like me in her career. This kind of behavior reflects poorly on the company. I strongly advise against joining this organization, as it does not value your time, effort, or patience."
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Jun 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Technical MCQ questions on core computer science subjects were asked.

Round 2 - One-on-one 

(2 Questions)

  • Q1. How to find whether the given linked list has loop in it?
  • Q2. Explain osi model with example of browser.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Javascript question
Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.

Round 1 - Coding Test 

Python code for solving a string usecase using stack, SQL join and groupby queries

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Solve code snippets

Capco Technologies Interview FAQs

How many rounds are there in Capco Technologies Plsql Developer interview?
Capco Technologies interview process usually has 1 rounds. The most common rounds in the Capco Technologies interview process are Technical.
How to prepare for Capco Technologies Plsql Developer interview?
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 Capco Technologies. The most common topics and skills that interviewers at Capco Technologies expect are Data Analytics, Data Modeling, Export Import, Financial Services and Management Consulting.
What are the top questions asked in Capco Technologies Plsql Developer interview?

Some of the top questions asked at the Capco Technologies Plsql Developer interview -

  1. Count of rows in inner join, left join, right j...read more
  2. What is dirty r...read more

Tell us how to improve this page.

Capco Technologies Plsql Developer Interview Process

based on 1 interview

Interview experience

3
  
Average
View more
PL/SQL Developer

Bangalore / Bengaluru

2-3 Yrs

Not Disclosed

Explore more jobs
Senior Consultant
881 salaries
unlock blur

₹10.1 L/yr - ₹33 L/yr

Consultant
482 salaries
unlock blur

₹5.2 L/yr - ₹23 L/yr

Senior Consultant 2
161 salaries
unlock blur

₹15 L/yr - ₹38 L/yr

Consultant2
135 salaries
unlock blur

₹7.5 L/yr - ₹23.5 L/yr

Business Analyst
115 salaries
unlock blur

₹5.8 L/yr - ₹22 L/yr

Explore more salaries
Compare Capco Technologies with

TCS

3.7
Compare

Infosys

3.7
Compare

Wipro

3.7
Compare

HCLTech

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