i
TCS
Filter interviews by
Clear (1)
PL/SQL exceptions handle errors and manage control flow in Oracle databases, ensuring robust application behavior.
PL/SQL has predefined exceptions like NO_DATA_FOUND and ZERO_DIVIDE.
Custom exceptions can be defined using the EXCEPTION keyword.
Use the RAISE statement to trigger an exception manually.
Example: BEGIN SELECT salary INTO v_salary FROM employees WHERE emp_id = 100; EXCEPTION WHEN NO_DATA_FOUND THEN DBMS_OUTPU...
PL/SQL triggers are special procedures that automatically execute in response to certain events on a database table or view.
1. DML Triggers: Execute on Data Manipulation Language events (INSERT, UPDATE, DELETE). Example: AFTER INSERT trigger to log changes.
2. INSTEAD OF Triggers: Used on views to perform actions instead of the triggering action. Example: INSTEAD OF DELETE on a view.
3. System Triggers: Triggered by syst...
I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.
Binary search is a fast search algorithm that finds the position of a target value within a sorted array.
Ensure the array is sorted before performing binary search.
Compare the target value with the middle element of the array.
If the target value is less than the middle element, search the left half of the array. If greater, search the right half.
Repeat the process until the target value is found or the subarray is empt
Merge sort is a divide and conquer algorithm that divides the input array into two halves, sorts them, and then merges them back together.
Divide the array into two halves recursively
Sort each half separately
Merge the sorted halves back together
What people are saying about TCS
I am a Senior Engineer with 10+ years of experience in software development, specializing in backend systems and cloud technologies.
10+ years of experience in software development
Specialize in backend systems and cloud technologies
Strong problem-solving skills
Experience working in agile environments
Proficient in multiple programming languages such as Java, Python, and SQL
I chose TCS for its reputation as a global leader in IT services and its focus on innovation and career development.
TCS is known for its strong reputation in the IT industry
TCS offers opportunities for career growth and development
TCS has a global presence with diverse projects and clients
TCS interview questions for designations
I applied via Recruitment Consulltant and was interviewed in Apr 2024. There was 1 interview round.
Get interview-ready with Top TCS Interview Questions
I applied via Campus Placement
Aptitude and coding test happened
I applied via Approached by Company and was interviewed in Aug 2022. There were 2 interview rounds.
I am changing companies early to seek new challenges and opportunities for growth.
Seeking new challenges and opportunities for growth
Wanting to expand my skillset and knowledge
Looking for a better work-life balance
Desire for a more supportive and collaborative work environment
Company restructuring or downsizing
Relocation or personal reasons
My expectations for the Senior Engineer role include challenging projects, a collaborative team environment, opportunities for growth and learning, and a competitive compensation package.
Challenging projects that allow me to utilize my skills and expertise
A collaborative team environment where ideas are valued and shared
Opportunities for growth and learning through training programs and mentorship
A competitive compensa...
I applied via Referral and was interviewed in Mar 2022. There were 2 interview rounds.
Python programming questions
Python oops concepts based questions
I applied via Naukri.com and was interviewed before Apr 2022. There were 4 interview rounds.
based on 13 interviews
2 Interview rounds
based on 128 reviews
Rating in categories
System Engineer
1.1L
salaries
| ₹0 L/yr - ₹0 L/yr |
IT Analyst
66.4k
salaries
| ₹0 L/yr - ₹0 L/yr |
AST Consultant
51.6k
salaries
| ₹0 L/yr - ₹0 L/yr |
Assistant System Engineer
29.8k
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Consultant
29.6k
salaries
| ₹0 L/yr - ₹0 L/yr |
Amazon
Wipro
Infosys
Accenture