AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Agile Softech Plsql Developer Interview Questions and Answers
13 Interview questions
The PLSQL code snippet to replace only the third character with * in a given string.
Use the SUBSTR function to extract the first two characters of the string.
Concatenate the extracted characters with '*' and the remaining characters starting from the fourth position using the SUBSTR function.
Assign the modified string back to the original variable.
The query displays employee records with the same salary.
Use the GROUP BY clause to group the records by salary.
Use the HAVING clause to filter the groups with more than one employee.
Select the necessary columns to display the employee records.
Delete, drop, and truncate are SQL commands used to remove data from a table, but they differ in their functionality.
DELETE is used to remove specific rows from a table based on a condition.
DROP is used to remove an entire table from the database.
TRUNCATE is used to remove all rows from a table, but keeps the structure intact.
DELETE and TRUNCATE can be rolled back, but DROP cannot.
DELETE triggers the delete trigge...
Procedures and functions are both PL/SQL program units, but they have some differences.
Procedures do not return a value, while functions do.
Procedures can have OUT parameters to pass values back to the caller, while functions cannot.
Functions can be used in SQL queries, while procedures cannot.
Functions must return a value, while procedures do not have to.
Functions can be called directly in PL/SQL code, while proc...
To copy the structure of a table without copying the data, you can use the CREATE TABLE AS SELECT statement.
Use the CREATE TABLE AS SELECT statement to create a new table with the same structure as the original table.
Specify the columns and their data types in the SELECT statement, but exclude the actual data from the original table.
Example: CREATE TABLE new_table AS SELECT * FROM original_table WHERE 1=0;
To eliminate duplicates without using the distinct command in PL/SQL, we can use the GROUP BY clause.
Use the GROUP BY clause to group the data by the columns that you want to eliminate duplicates from.
Select the columns you want to display in the result set.
Aggregate functions like COUNT, SUM, AVG, etc. can be used to perform calculations on the grouped data.
The GROUP BY clause ensures that only unique combination...
Indexing is a technique used in databases to improve the performance of queries by creating a data structure that allows for faster data retrieval.
Indexing creates a separate data structure that contains a subset of the data in the database, organized in a way that allows for efficient searching and retrieval.
Indexes are created on one or more columns of a table and can be used to quickly locate data based on the ...
Foreign key, primary key, and unique key are all constraints used in database tables to enforce data integrity.
Primary key is a column or a set of columns that uniquely identifies each row in a table.
Foreign key is a column or a set of columns in one table that refers to the primary key in another table.
Unique key ensures that the values in a column or a set of columns are unique across all the rows in a table.
The query to display the top 5 salaries in PL/SQL.
Use the SELECT statement to retrieve the salaries from the table.
Order the salaries in descending order using the ORDER BY clause.
Limit the result to the top 5 rows using the FETCH FIRST clause.
A trigger is a PL/SQL block that is automatically executed in response to a specific event. A procedure is a named PL/SQL block that performs a specific task. A cursor is a database object used to retrieve data from a result set.
A trigger is used to automatically execute a set of SQL statements when a specific event occurs, such as inserting, updating, or deleting data from a table.
A procedure is a reusable block ...
Agile Softech Plsql Developer Interview Experiences
1 interview found
I applied via Campus Placement and was interviewed in Apr 2018. There were 5 interview rounds.
Interview Questionnaire
15 Questions
- Q1. 1.What is Trigger,procedure,cursor differentiate with example
- Ans.
A trigger is a PL/SQL block that is automatically executed in response to a specific event. A procedure is a named PL/SQL block that performs a specific task. A cursor is a database object used to retrieve data from a result set.
A trigger is used to automatically execute a set of SQL statements when a specific event occurs, such as inserting, updating, or deleting data from a table.
A procedure is a reusable block of co...
- Q2. 2.how to recover the data(Tables) in oracle or how to export the tables in file
- Ans.
To recover data in Oracle, you can use the flashback feature or export tables using the Data Pump utility.
To recover data using flashback, you can use the FLASHBACK TABLE statement to restore a table to a previous state.
To export tables, you can use the Data Pump utility with the EXPDP command to export tables to a file.
You can also use the SQL Developer tool to export tables as SQL insert statements or CSV files.
- Q3. 3.what is joins and its types what is the use and what is natural join with example
- Ans.
Joins are used to combine rows from two or more tables based on related columns. There are different types of joins.
Types of joins: inner join, left join, right join, full outer join, cross join
Joins are used to retrieve data from multiple tables based on a related column
Natural join is a type of join that automatically matches columns with the same name in both tables
Example: SELECT * FROM employees NATURAL JOIN depar...
- Q4. 4.Differentiate Foreign key,primary key and unique key
- Ans.
Foreign key, primary key, and unique key are all constraints used in database tables to enforce data integrity.
Primary key is a column or a set of columns that uniquely identifies each row in a table.
Foreign key is a column or a set of columns in one table that refers to the primary key in another table.
Unique key ensures that the values in a column or a set of columns are unique across all the rows in a table.
- Q5. 5.6.Difference between delete,drop and truncate
- Ans.
Delete, drop, and truncate are SQL commands used to remove data from a table, but they differ in their functionality.
DELETE is used to remove specific rows from a table based on a condition.
DROP is used to remove an entire table from the database.
TRUNCATE is used to remove all rows from a table, but keeps the structure intact.
DELETE and TRUNCATE can be rolled back, but DROP cannot.
DELETE triggers the delete trigger, wh...
- Q6. 6.Display the 5th Highest Salary in Employee Table
- Ans.
Use a subquery to find the 5th highest salary in the Employee table.
Use the ORDER BY clause to sort the salaries in descending order.
Use the ROWNUM keyword to limit the results to the 5th highest salary.
Use a subquery to achieve the desired result.
- Q7. 7.Display Top 5 salary
- Ans.
The query to display the top 5 salaries in PL/SQL.
Use the SELECT statement to retrieve the salaries from the table.
Order the salaries in descending order using the ORDER BY clause.
Limit the result to the top 5 rows using the FETCH FIRST clause.
- Q8. 8.Write a command of copy the structure only not data of the table
- Ans.
To copy the structure of a table without copying the data, you can use the CREATE TABLE AS SELECT statement.
Use the CREATE TABLE AS SELECT statement to create a new table with the same structure as the original table.
Specify the columns and their data types in the SELECT statement, but exclude the actual data from the original table.
Example: CREATE TABLE new_table AS SELECT * FROM original_table WHERE 1=0;
- Q9. 9.What is view and its type what is complex view with example
- Ans.
A view is a virtual table created from one or more tables. It can be used to simplify complex queries and provide a customized view of data.
A view is a stored query that can be treated as a table
Types of views include simple views, complex views, and materialized views
A complex view is a view that involves multiple tables or subqueries
Complex views can be used to combine data from different tables or apply complex calc...
- Q10. 10.What is indexing what is the role of indexing in database
- Ans.
Indexing is a technique used in databases to improve the performance of queries by creating a data structure that allows for faster data retrieval.
Indexing creates a separate data structure that contains a subset of the data in the database, organized in a way that allows for efficient searching and retrieval.
Indexes are created on one or more columns of a table and can be used to quickly locate data based on the value...
- Q11. 11.Difference between Procedure and Function
- Ans.
Procedures and functions are both PL/SQL program units, but they have some differences.
Procedures do not return a value, while functions do.
Procedures can have OUT parameters to pass values back to the caller, while functions cannot.
Functions can be used in SQL queries, while procedures cannot.
Functions must return a value, while procedures do not have to.
Functions can be called directly in PL/SQL code, while procedure...
- Q12. 12.Write a query to display employee records having same salary
- Ans.
The query displays employee records with the same salary.
Use the GROUP BY clause to group the records by salary.
Use the HAVING clause to filter the groups with more than one employee.
Select the necessary columns to display the employee records.
- Q13. 13.How we can eliminate duplicates without using distinct command
- Ans.
To eliminate duplicates without using the distinct command in PL/SQL, we can use the GROUP BY clause.
Use the GROUP BY clause to group the data by the columns that you want to eliminate duplicates from.
Select the columns you want to display in the result set.
Aggregate functions like COUNT, SUM, AVG, etc. can be used to perform calculations on the grouped data.
The GROUP BY clause ensures that only unique combinations of ...
- Q14. 14.Replace Only Third Character with *
- Ans.
The PLSQL code snippet to replace only the third character with * in a given string.
Use the SUBSTR function to extract the first two characters of the string.
Concatenate the extracted characters with '*' and the remaining characters starting from the fourth position using the SUBSTR function.
Assign the modified string back to the original variable.
- Q15. Introduction Objective of Your Life Strength Weakness About Salary(Discuss About Your Expected Salary)
Interview Preparation Tips
Experience: Part 1-
Aptitude ,Reasoning & English Test
(Aptitude Question-15,Reasoning-15,English-10 )
Part 2-
Technical Questions(30)
Technology:C,C++,Data Structure,Database,Python,Java,Software Engineering
No Negative Marks
90 Mins For 60 Question (1 Marks For Each Question)
General Tips: Be Prepare For Interview and Don't Panic at that time.Give your answer clear and related to that question.
Skills: Communication, Body Language, Problem Solving, Leadership, Presentation Skills
Duration: <1 week
College Name: TEERTHANKER MAHAVEEER UNIVERSITY
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
(2 Questions)
- Q1. About your project and join
- Q2. Subquery and windows functions
Interview Preparation Tips
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
Software Developer Interview Questions & Answers
Optum Global Solutions
Anonymous
posted on 16 Sep 2021
I appeared for an interview in Oct 2020.
(1 Question)
Round duration - 75 min
Round difficulty - Medium
This round was MCQ and coding round. 25 MCQs and one coding question were asked. MCQs were based on OS, DBMS, Aptitude and Data Structures.
- Q1.
Minimum Days to Complete Work
You have 'N' tasks to complete. Each task can only be done on one of two specific days provided in two arrays:
day1andday2.For each task i,
day1[i]represents the earliest... - Ans.
Find the minimum number of days required to complete all tasks given specific completion days for each task.
Sort the tasks based on day1 in ascending order.
For each task, choose the minimum of day1 and day2 as the completion day.
Keep track of the maximum completion day for each task.
The final answer is the maximum completion day of all tasks.
(1 Question)
Round duration - 30 min
Round difficulty - Easy
This was a Data Structural round. Only one coding question was asked by the interviewer. The interviewer was very friendly. This round was very easy.
- Q1.
Bubble Sort Problem Statement
Sort the given unsorted array consisting of N non-negative integers in non-decreasing order using the Bubble Sort algorithm.
Input:
The first line contains an integer 'T' r...
- Ans.
Bubble Sort algorithm is used to sort an array of non-negative integers in non-decreasing order.
Implement the Bubble Sort algorithm to sort the array in place.
Compare adjacent elements and swap them if they are in the wrong order.
Repeat this process until the array is sorted.
Time complexity of Bubble Sort is O(n^2) in the worst case.
Example: For input [6, 2, 8, 4, 10], the output should be [2, 4, 6, 8, 10].
Interview Preparation Tips
Tip 1 : Be confident!
Tip 2 : Maintain high Cgpa
Tip 3 : Do your best
Tip 1 : Mention clear points
Tip 2 : Atleast 3 projects and never put anything you have not revised
Skills evaluated in this interview
Software Developer Interview Questions & Answers
Optum Global Solutions
Anonymous
posted on 16 Sep 2021
I appeared for an interview before Sep 2020.
(1 Question)
Round duration - 75 minutes
Round difficulty - Medium
It was in the evening.
It consisted of 26 questions of easy to hard level.
It consisted of 25 MCQs and only 1 coding problem.
- Q1.
Author and Books Formatting
Given a structured list of books and their authors, format the information as specified.
Input:
The first line of input contains an integer ‘T' representing the number of tes... - Ans.
The task is to format a list of authors and their books in a specific way as per the given input format.
Parse the input to extract the number of test cases, number of authors, author names, and their respective books.
Format the output by printing the author names and their books in the specified format.
Ensure correct sequence and labeling of authors and books as per the example provided.
Handle multiple test cases and a...
(1 Question)
Round duration - 15 minutes
Round difficulty - Medium
It was more of CV based round. A brief discussion on projects was there followed by some questions like why optum.
- Q1.
Delete a Node from a Linked List
You are provided with a linked list of integers. Your task is to implement a function that deletes a node located at a specified position 'POS'.
Input:
The first line co... - Ans.
Implement a function to delete a node from a linked list at a specified position.
Traverse the linked list to find the node at the specified position.
Update the pointers of the previous and next nodes to skip the node to be deleted.
Handle edge cases such as deleting the head or tail of the linked list.
Ensure to free the memory of the deleted node to avoid memory leaks.
(1 Question)
Round duration - 15 minutes
Round difficulty - Easy
A short round where some basic dbms questions like procedure, cursor were asked. Then some questions on whether I would prefer working alone or in a team. Where I see myself in 5 years.
- Q1.
Graph Coloring Problem
You are given a graph with 'N' vertices numbered from '1' to 'N' and 'M' edges. Your task is to color this graph using two colors, such as blue and red, in a way that no two adjacen...
- Ans.
Given a graph with 'N' vertices and 'M' edges, determine if it can be colored using two colors without adjacent vertices sharing the same color.
Use graph coloring algorithm like BFS or DFS to check if the graph can be colored with two colors without conflicts.
Check if any adjacent vertices have the same color. If so, it is not possible to color the graph as described.
If the graph has connected components, color each co...
Interview Preparation Tips
Tip 1 : Projects do not matter much for this company.
Tip 2 : I did almost all the puzzles from Interviewbit.
Tip 3 : DBMS is really important. Practice queries in SQL thoroughly. You should know the use of limit and top also. It may be asked to write the same query in more than 1 form.
Tip 4 : Practice all the data structures. Questions were simple and you should know the basics of every data structure.
Tip 1 : Don't write anything just for the sake of it.
Tip 2 : If you are writing some project then be thorough with all the details. If you are not much confident, then simply remove it and focus on other subjects.
Skills evaluated in this interview
Software Developer Interview Questions & Answers
Optum Global Solutions
Anonymous
posted on 12 Jun 2021
Interview Questionnaire
1 Question
- Q1. Basic questions related to skillset
I applied via Naukri.com and was interviewed in Aug 2020. There were 5 interview rounds.
Interview Questionnaire
3 Questions
- Q1. Aws vpc gateway questions, devops drawback
- Q2. Interfaces in oops
- Ans.
Interfaces define a contract for classes to implement certain methods and properties.
Interfaces allow for polymorphism and loose coupling.
Classes can implement multiple interfaces.
Interfaces cannot be instantiated on their own.
Interfaces can have default method implementations.
Interfaces can be used to enforce design patterns like the adapter pattern.
- Q3. Meta programing
Interview Preparation Tips
I appeared for an interview before May 2021.
(3 Questions)
Round duration - 90 Minutes
Round difficulty - Easy
This round was also conducted on Metll platform. This round is totally based on coding. There are so many choices in language, so you can easily select the language in which you are comfortable in. There are three problems to solve. I choose Java 8 to solve the problems. The problems are ranging from easy to hard-
To find the maximum occurring character in a given string.
To find the factorial of a given number.
Count Derangements.
- Q1.
Count Derangements
Determine the number of derangements possible for a set of 'N' elements. A derangement is a permutation where no element appears in its original position.
Input:
An integer 'T' repres... - Ans.
Count the number of derangements possible for a set of 'N' elements.
Derangements are permutations where no element appears in its original position.
Use the formula: !n = n! * (1 - 1/1! + 1/2! - 1/3! + ... + (-1)^n/n!).
Calculate the derangements modulo (10^9 + 7) for each test case.
- Q2.
Factorial Calculation Problem Statement
Develop a program to compute the factorial of a given integer 'n'.
The factorial of a non-negative integer 'n', denoted as
n!, is the product of all positive integ... - Ans.
Program to compute factorial of a given integer 'n', with error handling for negative values.
Create a function to calculate factorial using a loop or recursion
Check if input is negative, return 'Error' if true
Handle edge cases like 0 and 1 separately
Use long data type to handle large factorials
- Q3.
Most Frequent Word Problem Statement
You are given two strings 'A' and 'B' composed of words separated by spaces. Your task is to determine the most frequent and lexicographically smallest word in string ...
- Ans.
Find the most frequent and lexicographically smallest word in string 'A' that is not present in string 'B'.
Split strings 'A' and 'B' into words
Count frequency of each word in 'A'
Check if word is not in 'B' and is the most frequent and lexicographically smallest
Return the word or -1 if no such word exists
Round duration - 90 Minutes
Round difficulty - Easy
The interviewer was so polite. He firstly asks me to describe myself and then ask about my family. After that he ask which language I choose to solve problems in Coding round and why I choose that language. Then he started to ask the technical questions.
Interview Preparation Tips
Tip 1 : Practice questions on leetcode
Tip 2 : Understand the best solutions in depth and algorithm used
Tip 3 : Ask clarifying questions to the interviewer and break the problem to smaller sub parts
Tip 1 : Highlight your most impactful work on the resume
Tip 2 : Keep it easy to understand
Skills evaluated in this interview
Interview Questionnaire
1 Question
- Q1. Why you want to join Teleperformance
- Ans.
I want to join Teleperformance for its commitment to excellence, diverse opportunities, and a supportive work environment.
Teleperformance is a global leader in customer experience management, which aligns with my career goals.
The company's emphasis on employee development and training programs is appealing, as I value continuous learning.
I admire Teleperformance's commitment to diversity and inclusion, fostering a work...
Interview Questionnaire
3 Questions
- Q1. Mostly related to C and Linux
- Q2. Preapare good linux like IPC , mutex etc
- Ans.
Inter-process communication (IPC) and mutexes are essential for managing concurrent processes in Linux systems.
IPC allows processes to communicate and synchronize their actions. Common IPC methods include pipes, message queues, and shared memory.
Mutex (mutual exclusion) is a synchronization primitive that prevents multiple threads from accessing shared resources simultaneously.
Example of IPC: Using a named pipe (FIFO) ...
- Q3. C question like linklist stack
- Ans.
Implementing a linked list stack in C involves defining a node structure and stack operations like push, pop, and peek.
Define a struct for the node: `struct Node { int data; struct Node* next; };`
Create a stack structure that holds a pointer to the top node: `struct Stack { struct Node* top; };`
Implement push operation: Allocate a new node, set its data, and adjust the top pointer.
Implement pop operation: Check if the ...
Interview Preparation Tips
Skills evaluated in this interview
Agile Softech Interview FAQs
Some of the top questions asked at the Agile Softech Plsql Developer interview -
Tell us how to improve this page.
Interview Questions for Popular Designations
- Software Developer Interview Questions
- Java Developer Interview Questions
- System Engineer Interview Questions
- Associate Interview Questions
- Web Developer Interview Questions
- Application Developer Interview Questions
- Salesforce Developer Interview Questions
- Lead Engineer Interview Questions
- Show more
Interview Questions from Similar Companies
|
Softwaretest Engineer
5
salaries
|  ₹3 L/yr - ₹3.5 L/yr |
|
Software Engineer
4
salaries
| ₹1.2 L/yr - ₹20 L/yr |
|
Software Developer
4
salaries
| ₹0.9 L/yr - ₹4 L/yr |
|
Data Analyst
4
salaries
| ₹3 L/yr - ₹4 L/yr |
|
QA Engineer
4
salaries
| ₹1 L/yr - ₹2.2 L/yr |
Teleperformance
Optum Global Solutions
FIS
Nagarro
- Home >
- Interviews >
- Agile Softech Interview Questions
