AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Agile Softech 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 Interview Experiences
1 interview found
Anonymous
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
I applied via Referral and was interviewed in Jan 2020. There were 4 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Basic Logical questions from String, Arrays, Collections, Java Oops and Selenium.
- Q2. See few puzzles from google.
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. Stge concepts, vSAN, RAID, basic testing, OS concepts, NVMe, SATA, SAS
I applied via Naukri.com and was interviewed in Dec 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. What is Company payroll Process
- Ans.
Company payroll process is the system used to manage employee compensation and benefits.
Payroll process includes calculating employee salaries, taxes, and deductions
It also involves managing employee benefits such as health insurance and retirement plans
Payroll process can be done in-house or outsourced to a third-party provider
It is important to ensure compliance with labor laws and regulations
Payroll process can be a...
Interview Preparation Tips
I applied via Company Website and was interviewed in Jul 2019. There were 3 interview rounds.
Interview Questionnaire
6 Questions
- Q1. What's your role and responsibilities
- Q2. Current processes your organization follows
- Ans.
Our organization follows a combination of manual and automated processes to streamline operations.
We use project management tools like Jira to track tasks and progress
Regular team meetings are held to discuss project updates and address any issues
Automated testing is used to ensure software quality and reduce manual errors
- Q3. How do you contribute to your organization (citizenship activities)
- Q4. What's IRD, IDD and BRD
- Ans.
IRD stands for Interface Requirements Document, IDD stands for Interface Design Document, and BRD stands for Business Requirements Document.
IRD is a document that outlines the requirements for the interface between different systems or components.
IDD is a document that describes the design of the interface, including the data formats, protocols, and communication methods.
BRD is a document that captures the business req...
- Q5. Microsoft Visio usage
- Q6. What are Use case diagrams
- Ans.
Use case diagrams are visual representations of the interactions between users and a system.
They depict the system's functionality from the user's perspective.
They show the different actors and their roles in the system.
They illustrate the various use cases and their relationships.
They help in identifying the requirements of the system.
They aid in communication between stakeholders.
Example: A use case diagram for an on...
Interview Preparation Tips
I applied via Walk-in and was interviewed in Jun 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Intro n randomly any questions just to check the communication n confident of a candidate
Interview Preparation Tips
I applied via Naukri.com and was interviewed before Sep 2019. There were 6 interview rounds.
Interview Questionnaire
3 Questions
- Q1. IQ Test
- Q2. Machine Test
- Q3. Face To Face
Interview Preparation Tips
1. IQ Test
2. Machine Test
3. Face to Face
IQ Test is not so tough but prepare well Machine Test
Machine Test Question are like :-
Q.1 - We declare a variable in C++ like "is_this_a_variable" and in Java like "IsThisAVariable". There is underscore in between every word and first alphabet of every word is in lowercase in C++ and in Java first alphabet is in capital without underscore. Create a program in which if user input a string in a C++ variable format it will convert the input in java variable format.
Q2. Count the frequency of a string.
user input string - pqhphi
output-
p - 2
q - 1
h - 2
i - 1
Be strong in algorithms and data structure.
I appeared for an interview in Aug 2017.
Interview Preparation Tips
Duration: 1 hour 30 minutes
Total Questions: 60
Round: Technical Interview
Experience: Questions about DS , CN and basic resume
Round: Technical Interview
Experience: Questions about RT OS and memory mapping. And other operating system related questions.
Projects done so far.
I appeared for an interview in Aug 2017.
Interview Questionnaire
8 Questions
- Q1. Basics of C
- Q2. Puzzles on data structures
- Q3. Asked on project
- Q4. C basics
- Q5. 3 basic and simple codes
- Q6. Family background
- Q7. How was technical interviews
- Q8. Why should we not hire you
- Ans.
I lack experience in a specific technology required for the role.
I may not have experience with a specific programming language or framework mentioned in the job description.
I may not have worked on projects similar to what your company is working on.
I may not have experience with certain tools or technologies that are crucial for the role.
Interview Preparation Tips
Experience: It was just mcq questions but had negative marking
Duration: 1 hour 30 minutes
Total Questions: 60
Round: Technical Interview
Experience: It was cool and interactive round and was fun
Round: Technical Interview
Experience: It was interesting but I fumbled a little
Round: HR Interview
Experience: It was ok
College Name: Cummins College Of Engineering For Women (CCOEW)
I applied via Campus Placement and was interviewed in Dec 2016. There were 5 interview rounds.
Interview Questionnaire
14 Questions
- Q1. Four people and torch problem?
- Q2. What is the difference between AC and DC?
- Ans.
AC and DC are two types of electrical current with different characteristics.
AC stands for Alternating Current, while DC stands for Direct Current.
AC periodically changes direction, while DC flows in one direction.
AC is commonly used in household electrical systems, while DC is used in batteries and electronic devices.
AC can be easily transformed to different voltage levels using transformers, while DC requires convert...
- Q3. Fill the cells in the pyramid?
- Ans.
Fill the cells in the pyramid
The pyramid is a pattern of numbers or characters arranged in a triangular shape
Each row of the pyramid has one more cell than the previous row
Start filling the pyramid from the top and move downwards
The cells can be filled with any desired numbers or characters
- Q4. What is alternator and generator?
- Ans.
An alternator and generator are devices that convert mechanical energy into electrical energy.
Both alternators and generators are used to generate electricity.
They work on the principle of electromagnetic induction.
Alternators are commonly used in modern vehicles to charge the battery and power the electrical systems.
Generators are often used as backup power sources during power outages.
Examples of alternators include ...
- Q5. What is the complexity of quick sort?
- Ans.
Quick sort has an average and worst-case time complexity of O(n log n).
Quick sort is a divide-and-conquer algorithm.
It selects a pivot element and partitions the array around the pivot.
The average and worst-case time complexity is O(n log n).
However, in the worst-case scenario, it can have a time complexity of O(n^2).
- Q6. What are interesting u did?
- Ans.
I developed a mobile app for tracking daily water intake and hydration levels.
Researched best practices for hydration tracking
Designed user-friendly interface for inputting water intake
Implemented data visualization for tracking hydration levels
Tested app with focus groups for feedback
Continuously updated app based on user suggestions
- Q7. Explain SHA Algorithm?
- Ans.
SHA Algorithm is a cryptographic hash function that takes an input and produces a fixed-size output.
SHA stands for Secure Hash Algorithm.
It is widely used in various security applications and protocols.
SHA-1, SHA-256, SHA-384, and SHA-512 are common variants of SHA.
It generates a unique hash value for each unique input.
The output is a fixed length, regardless of the input size.
SHA is used for data integrity, password h...
- Q8. 5 heads and two tails, separate into two groups such that two groups should have equal number of tails?
- Q9. Delete a node in linked list?
- Ans.
To delete a node in a linked list, we need to adjust the pointers of the previous node and the next node.
Find the node to be deleted
Adjust the pointers of the previous node and the next node
Free the memory of the deleted node
- Q10. Tell me about yourself?
- Ans.
I am a passionate software engineer with experience in developing web applications and a strong background in computer science.
Experienced in developing web applications using technologies like HTML, CSS, JavaScript, and React
Strong background in computer science with knowledge of data structures and algorithms
Proficient in programming languages such as Java, Python, and C++
Familiar with Agile development methodologies...
- Q11. What are the challenges you faced in the interns?
- Ans.
As an intern supervisor, I faced challenges in terms of communication, technical skills, and time management.
Communication barriers due to language or cultural differences
Lack of technical skills or knowledge required for the job
Difficulty in managing time and meeting deadlines
Inability to work independently or as part of a team
Resistance to feedback or constructive criticism
Limited exposure to real-world scenarios and...
- Q12. Preference of job place?
- Ans.
I prefer a job place that offers a collaborative and innovative work environment.
Prefer a workplace that encourages teamwork and communication
Value opportunities for learning and growth
Seek a company that fosters creativity and innovation
- Q13. How will you solve the disputes?
- Ans.
I will solve disputes by promoting open communication, active listening, and finding mutually beneficial solutions.
Encourage open and honest communication between parties involved
Actively listen to each party's concerns and perspectives
Identify common goals and interests to find mutually beneficial solutions
Mediate discussions and facilitate negotiations if necessary
Document agreements and ensure follow-up to prevent f...
- Q14. What is your view about Qualcomm?
- Ans.
Qualcomm is a leading semiconductor and telecommunications equipment company.
Qualcomm is known for its expertise in wireless technologies and mobile chipsets.
They have developed popular Snapdragon processors used in smartphones and tablets.
Qualcomm has made significant contributions to the advancement of 5G technology.
The company has a strong patent portfolio and is involved in licensing its technology to other manufac...
Interview Preparation Tips
Experience: Simple aptitude questions and technical questions which includes OOPS, Computer networks
Duration: 1 hour 25 minutes
Total Questions: 50
College Name: IIT Madras
Skills evaluated in this interview
Agile Softech Interview FAQs
Some of the top questions asked at the Agile Softech interview -
Tell us how to improve this page.
Interview Questions for Popular Designations
- Senior Executive Interview Questions
- Team Lead Interview Questions
- Software Developer Interview Questions
- Business Analyst Interview Questions
- Sales Executive Interview Questions
- Consultant Interview Questions
- Graduate Engineer Trainee (Get) Interview Questions
- System Engineer Interview Questions
- Show more
Interview Questions from Similar Companies
Agile Softech Reviews and Ratings
based on 15 reviews
Rating in categories
|
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
