Path Infotech Senior Programmer Interview Questions and Answers for Experienced

30 mints, they asked queries, procedures, functions, views, triggers, packages, debugging

Q1. HOW DO YOU DELETE DUPLICATE DATA
Ans. 
Duplicate data can be deleted by using SQL queries with the DISTINCT keyword or by writing a script to identify and remove duplicates.
• Use SQL queries with the DISTINCT keyword to select unique records and insert them into a new table.

• Write a script to iterate through the data, identify duplicates based on specific criteria, and delete them.

• Utilize built-in functions or libraries in programming languages like Python or
Answered by AI
Add your answer
Q2. WRITE ONE FUNCTION
Ans. 
Function to reverse an array of strings
• Create a function that takes an array of strings as input

• Use a loop to iterate through the array and reverse each string

• Return the reversed array of strings
Answered by AI
Add your answer

Q1. SALARY,DOCUMENTS
Add your answer