AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Capco Technologies
Compare
Filter interviews by
Capco Technologies Plsql Developer Interview Questions and Answers
Capco Technologies Plsql Developer Interview Experiences
1 interview found
Anonymous
(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
- 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
Skills evaluated in this interview
Plsql Developer Jobs at Capco Technologies
Interview questions from similar companies
Selected
I applied via Naukri.com and was interviewed in Jun 2024. There was 1 interview round.
(2 Questions)
- Q1. STORED PROCEDURE
- Q2. CURSOR AND FUNCTION
Interview Preparation Tips
Sabarish R
(2 Questions)
- Q1. Basic SQL questions
- Q2. Advanced PLSQL questions
DSA based on any general language prefer C++
(3 Questions)
- Q1. DBMS, BST, Sieve of Erathnus, Dynamic Programming
- Q2. Debugging c++ code
- Q3. OOPS based question
(1 Question)
- Q1. General questions and some questions on personality
Vinay Kulkarni
I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.
(2 Questions)
- Q1. Basics about angular
- Q2. Javascript concepts
Interview Preparation Tips
I applied via Campus Placement and was interviewed in Jun 2024. There were 2 interview rounds.
Technical MCQ questions on core computer science subjects were asked.
(2 Questions)
- Q1. How to find whether the given linked list has loop in it?
- Q2. Explain osi model with example of browser.
I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.
(1 Question)
- Q1. Javascript question
I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.
Python code for solving a string usecase using stack, SQL join and groupby queries
(1 Question)
- Q1. Solve code snippets
Selected
I applied via Hirect and was interviewed in Nov 2022. There were 5 interview rounds.
(1 Question)
- Q1. Java 8 question about Strings.
(1 Question)
- Q1. Diff between JDK,JVM,JRE. Equals and HashCode
- Ans.
JDK is a development kit, JRE is a runtime environment, and JVM is a virtual machine. Equals compares object values, HashCode returns a unique integer for an object.
JDK includes JRE and development tools, while JRE includes JVM and necessary libraries
JVM is responsible for executing Java bytecode
Equals method compares the values of two objects, while == compares their references
HashCode method returns a unique integer ...
(1 Question)
- Q1. Given 2 Nodes 1->9 ->0 1->0 Add both of them so resulting node would be 2->0->0 190 +10 = 200 Java 8 questions
- Ans.
Add two linked lists representing numbers and return the resulting linked list.
Traverse both linked lists and add the corresponding digits, keeping track of carry.
Create a new node for each digit and update the carry for the next iteration.
If one list is longer than the other, add the remaining digits to the result.
Handle the case where the carry is not zero after all digits have been added.
Time complexity: O(max(m,n))...
(1 Question)
- Q1. Salary Expectations about the job
- Ans.
I expect a competitive salary based on my experience, skills, and the responsibilities of the role.
I have extensive experience in senior developer roles and have consistently delivered high-quality work.
I have a strong understanding of various programming languages and frameworks.
I have successfully led and mentored teams in previous positions.
I am confident in my ability to contribute to the success of the company.
I a...
Interview Preparation Tips
Skills evaluated in this interview
Capco Technologies Interview FAQs
Tell us how to improve this page.
Capco Technologies Interviews By Designations
- Capco Technologies Senior Consultant Interview Questions
- Capco Technologies Business Analyst Interview Questions
- Capco Technologies Consultant Interview Questions
- Capco Technologies Associate Interview Questions
- Capco Technologies Associate Consultant Interview Questions
- Capco Technologies Principal Consultant Interview Questions
- Capco Technologies Accountant Interview Questions
- Capco Technologies Accounts Manager Interview Questions
- Show more
Interview Questions for Popular Designations
- Oracle SQL and PLSQL Developer Interview Questions
- Senior Plsql Developer Interview Questions
- Front end Developer Interview Questions
- Web Developer Interview Questions
- Software Developer Intern Interview Questions
- Backend Developer Interview Questions
- Junior Software Developer Interview Questions
- Full Stack Software Developer Interview Questions
- Show more
Capco Technologies Plsql Developer Interview Process
based on 1 interview
Interview experience
Plsql Developer Interview Questions from Similar Companies
|
Senior Consultant
917
salaries
|  ₹10.8 L/yr - ₹33.4 L/yr |
|
Consultant
484
salaries
| ₹5.2 L/yr - ₹22.9 L/yr |
|
Senior Consultant 2
161
salaries
| ₹15 L/yr - ₹38 L/yr |
|
Consultant2
132
salaries
| ₹8.6 L/yr - ₹25 L/yr |
|
Business Analyst
115
salaries
| ₹5.2 L/yr - ₹22 L/yr |
TCS
Infosys
Wipro
HCLTech
- Home >
- Interviews >
- Capco Technologies Interview Questions >
- Capco Technologies Plsql Developer Interview Questions
