Filter interviews by
I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.
Indexes in PL/SQL are database objects that improve the performance of queries by allowing faster data retrieval.
Indexes are created on columns in database tables to speed up data retrieval operations.
They work by creating a separate data structure that allows the database to quickly locate rows based on the indexed columns.
Indexes can be unique or non-unique, and can be created using different methods like B-tree, bit
Mutating table error occurs when a trigger tries to update the same table it is triggered by.
Occurs when a trigger attempts to modify the table that is currently being modified by the same trigger
Can be avoided by using compound triggers or autonomous transactions
Example: Trigger A updates Table X, which causes Trigger A to fire again, resulting in a mutating table error
Top trending discussions
I applied via Naukri.com and was interviewed in Apr 2024. There was 1 interview round.
Using PL/SQL to create a procedure with a ref cursor to find the average and factorial of a given number.
Create a procedure that takes in a number as input and returns the average of that number using a ref cursor.
Use the EXISTS function to check if a factorial exists for a given number.
Write a block of code to calculate the factorial of a number using a loop.
Use a case statement to handle duplicate records in PL/SQL.
Use a case statement to check for duplicate records based on specific criteria.
Implement logic within the case statement to handle the duplicates appropriately.
Consider using a unique identifier or combination of columns to identify duplicates.
I applied via Job Portal and was interviewed in Nov 2024. There were 2 interview rounds.
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...
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
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.
I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.
posted on 30 Dec 2024
The interview will last for 30 minutes and will include basic Node.js questions, followed by two coding questions.
posted on 25 Apr 2024
I applied via campus placement at Chitkara Institute of Engineering & Technology, Rajpura and was interviewed in Mar 2024. There were 2 interview rounds.
3 coding questions, very basic
based on 1 interview
Interview experience
Consultant
51
salaries
| ₹6.5 L/yr - ₹19.5 L/yr |
Senior Consultant
26
salaries
| ₹13 L/yr - ₹26 L/yr |
Assistant Manager
25
salaries
| ₹8 L/yr - ₹17.3 L/yr |
Associate Consultant
17
salaries
| ₹4.6 L/yr - ₹8 L/yr |
Senior Executive
9
salaries
| ₹7 L/yr - ₹9 L/yr |
TCS
Infosys
Wipro
Tech Mahindra