Add office photos
Filter interviews by
TCS iON Plsql Developer Interview Questions and Answers
TCS iON Plsql Developer Interview Experiences
1 interview found
(2 Questions)
- Q1. Plsql Function procedure
- Ans.
A PL/SQL function is a named PL/SQL block that returns a value.
Functions are used to perform a specific task and return a single value.
They can accept input parameters and return a value.
Functions can be called from SQL statements or other PL/SQL blocks.
- Q2. Write program on given topic
- Ans.
Write a program to calculate the factorial of a given number.
Create a function to calculate the factorial recursively or iteratively.
Handle edge cases like negative numbers or zero.
Use a loop to multiply numbers from 1 to the given number to calculate the factorial.
Interview questions from similar companies
I applied via Naukri.com and was interviewed in Apr 2024. There was 1 interview round.
(4 Questions)
- Q1. RANK, WITH CLAUSE, PARTITION, DISTINCT, REF CURSOR
- Q2. Procedure with Ref cursor AVG, EXISTS, write a block to find factorial
- Ans.
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.
- Q3. Handle duplicate records with case statement
- Ans.
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.
- Q4. Joins, DBMS_PROFILER
Skills evaluated in this interview
Sabarish R
(2 Questions)
- Q1. Basic SQL questions
- Q2. Advanced PLSQL questions
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
(2 Questions)
- Q1. Core java, advanced java, spring boot, Hibernate, database
- Q2. Design pattern, previous project experience
Interview Preparation Tips
Web Developer Interview Questions & Answers
Quantiphi Analytics Solutions Private Limited
Anonymous
posted on 30 Dec 2024
The interview will last for 30 minutes and will include basic Node.js questions, followed by two coding questions.
Software Developer Intern Interview Questions & Answers
Wissen Technology
Anonymous
posted on 25 Apr 2024
Selected
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
(1 Question)
- Q1. Again DSA and DBMS questions, easy to medium easy
Interview Preparation Tips
Junior Software Developer Interview Questions & Answers
QualityKiosk Technologies
Anonymous
posted on 12 Apr 2024
I applied via Walk-in and was interviewed in Mar 2024. There was 1 interview round.
(1 Question)
- Q1. Oops concepts, DSA, asked intro
I applied via Company Website and was interviewed in May 2024. There was 1 interview round.
1 hr -duration and Question is Full of basics and technology what we have used
TCS iON Interview FAQs
Tell us how to improve this page.
TCS iON Interviews By Designations
- TCS iON Software Developer Interview Questions
- TCS iON System Engineer Interview Questions
- TCS iON Software Engineer Interview Questions
- TCS iON Java Developer Interview Questions
- TCS iON Assistant System Engineer Interview Questions
- TCS iON Assistant System Engineer Trainee Interview Questions
- TCS iON Business Analyst Interview Questions
- TCS iON Softwaretest Engineer 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
TCS iON Plsql Developer Interview Process
based on 1 interview
Interview experience
Plsql Developer Interview Questions from Similar Companies
Fast track your campus placements
|
Operations Executive
251
salaries
|  ₹1.2 L/yr - ₹5.5 L/yr |
|
Software Developer
145
salaries
| ₹3.6 L/yr - ₹13.6 L/yr |
|
Software Engineer
118
salaries
| ₹2.1 L/yr - ₹9 L/yr |
|
System Engineer
111
salaries
| ₹2 L/yr - ₹9.2 L/yr |
|
IT Manager
57
salaries
| ₹1.2 L/yr - ₹4.2 L/yr |
Wipro
Amazon
TCS
Infosys
- Home >
- Interviews >
- TCS iON Interview Questions >
- TCS iON Plsql Developer Interview Questions
