AvitInfotech Interview Questions and Answers

The exam consists of seven sections, and the cutoff score is quite high; it is essential to complete the exam thoroughly.

Q1. Can you tell me about yourself?
Add your answer
Q2. Can you provide details about your internship experience?
Add your answer
Q3. Given a puzzle to solve
Add your answer
Q4. What can you tell me about your major projects?
Add your answer
Q5. What is the latest news you have heard regarding technology?
Add your answer

Q1. Give work freedom to employee
Add your answer
Q2. No need to search each and every transactions
Add your answer

Q1. Trust on employee
Add your answer
Q2. Maintain minimum job curtsy
Add your answer

Q1. Salary hike and position hike is Mandatory
Add your answer
Q2. Collect exact feedback from employee
Add your answer

Q1. Queries on joins using inner join, left join, right join, outer join
Add your answer
Q2. What are the definitions of case and decode, what are the differences between them, and can you explain the logic for each?
Ans. 
Case and decode are conditional expressions in PL/SQL used for data manipulation.
• CASE is used for conditional logic in SQL statements, while DECODE is used for conditional logic in SELECT statements.

• CASE is more flexible and can handle multiple conditions, while DECODE is limited to one condition.

• CASE can be used in both SQL and PL/SQL, while DECODE is specific to SQL.

• Example of CASE: SELECT CASE WHEN condition1 THEN r...read more
Answered by AI
Add your answer
Q3. What are the primary key and foreign key in database design, and can you provide examples of each?
Ans. 
Primary key uniquely identifies each record in a table, while foreign key establishes a link between two tables.
• Primary key ensures uniqueness and cannot have null values

• Foreign key establishes a relationship between tables based on the primary key of another table

• Example of primary key: EmployeeID in an Employee table

• Example of foreign key: DepartmentID in an Employee table linking to DepartmentID in a Department tabl
Answered by AI
Add your answer
Q4. What are the differences between Rank and Dense Rank in SQL?
Ans. 
Rank assigns unique ranks to each distinct row, while Dense Rank assigns consecutive ranks without gaps.
• Rank may have gaps in the ranking sequence, while Dense Rank does not.

• Rank assigns the same rank to rows with the same values, while Dense Rank assigns different ranks.

• Rank function is non-consecutive, while Dense Rank function is consecutive.
Answered by AI
Add your answer
Q5. What is the difference between procedures and functions?
Ans. 
Procedures are used to perform an action, while functions return a value.
• Procedures do not return a value, while functions do.

• Functions can be called from SQL queries, while procedures cannot.

• Functions must return a value, while procedures do not necessarily have to.
Answered by AI
Add your answer
Q6. Is it possible to use a package body without a package specification?
Ans. 
No, a package body cannot be used without a package specification.
• A package body must always be associated with a package specification.

• The package specification defines the public interface of the package, while the package body contains the implementation details.

• Attempting to use a package body without a corresponding package specification will result in compilation errors.
Answered by AI
Add your answer
Q7. What is a SQL query that can be used to find duplicate values in a database?
Ans. 
Use a SQL query with GROUP BY and HAVING clause to find duplicate values in a database.
• Use GROUP BY clause to group the values that are duplicated.

• Use HAVING clause to filter out the groups that have more than one occurrence.

• Example: SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name HAVING COUNT(*) > 1;
Answered by AI
Add your answer
Q8. Queries using group by and having clause
Ans. 
Group by and having clause are used together to filter groups based on specified conditions.
• Group by clause is used to group rows that have the same values into summary rows.

• Having clause is used to filter groups based on specified conditions.

• Example: SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 5000;
Answered by AI
Add your answer
Q9. What are the definitions of the Substr and Instr functions?
Ans. 
Substr function extracts a substring from a string, while Instr function returns the position of a substring within a string.
• Substr function syntax: SUBSTR(string, start_position, length)

• Example: SUBSTR('Hello World', 7, 5) will return 'World'

• Instr function syntax: INSTR(string, substring)

• Example: INSTR('Hello World', 'World') will return 7
Answered by AI
Add your answer
Q10. What is the process for writing a SQL query that includes a subquery?
Ans. 
Writing a SQL query with a subquery involves nesting one query inside another to retrieve specific data.
• Start by writing the main query that will retrieve the primary data

• Identify the criteria for the subquery to filter the results

• Enclose the subquery within parentheses and use it in the WHERE or FROM clause of the main query

• Ensure that the subquery returns a single value or a single column result
Answered by AI
Add your answer
Q11. What is the difference between char, varchar, and varchar2 data types?
Ans. 
Char is fixed length, varchar is variable length with max 4000 bytes, varchar2 is variable length with max 32767 bytes.
• Char is fixed length and always right-padded with spaces, while varchar and varchar2 are variable length.

• Varchar can store up to 4000 bytes of data, while varchar2 can store up to 32767 bytes.

• Char is less efficient in terms of storage compared to varchar and varchar2.
Answered by AI
Add your answer
Q12. Queries using Trunc and round
Add your answer
Q13. Is it possible to combine two tables with differing data and columns without utilizing joins?
Ans. 
No, it is not possible to combine two tables with differing data and columns without utilizing joins.
• Joins are necessary to combine tables based on a common column or key.

• Different data and columns require a join to match and merge the data properly.

• Examples of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
Answered by AI
Add your answer
Q14. Is it possible to update data in a view?
Ans. 
Yes, it is possible to update data in a view using INSTEAD OF triggers.
• Views are virtual tables that display data from one or more tables.

• By using INSTEAD OF triggers, you can update data in a view by specifying the logic to handle the update operation.

• The trigger intercepts the update operation on the view and executes the specified logic to update the underlying tables.

• For example, you can create an INSTEAD OF trigge...read more
Answered by AI
Add your answer

Q1. Can you describe yourself and provide details about your project, including the brief questions that were asked about it?
Add your answer
Q2. Why TCS?
Ans. 
TCS is a global IT services company known for its innovative solutions and commitment to employee growth.
• TCS has a strong reputation in the IT industry for delivering high-quality services.

• TCS offers opportunities for professional growth and development through training programs and career advancement.

• TCS has a diverse and inclusive work culture that values teamwork and collaboration.
Answered by AI
Add your answer
Q3. What is a dynamic cursor in database management?
Ans. 
A dynamic cursor in database management allows for the execution of different SQL queries at runtime.
• Dynamic cursors are used when the SQL query to be executed is not known until runtime.

• They allow for flexibility in querying the database based on user input or other conditions.

• Dynamic cursors can be used to handle varying result sets or conditions in a more efficient manner.

• Example: Using a dynamic cursor to search fo...read more
Answered by AI
Add your answer
Q4. Did you perform performance tuning, and if so, what steps did you take?
Ans. 
Yes, I have performed performance tuning by identifying bottlenecks and optimizing queries.
• Identified slow queries using tools like SQL Trace, Explain Plan, and AWR reports.

• Optimized queries by adding indexes, rewriting SQL statements, and reducing unnecessary data retrieval.

• Tuned PL/SQL code by using bulk processing, minimizing context switches, and optimizing loops.

• Utilized database features like partitioning and mat
Answered by AI
Add your answer
Q5. What is the definition of a package, and is it possible to use a package body without a package specification?
Ans. 
A package in PL/SQL is a collection of related procedures, functions, variables, and other constructs.
• A package consists of two parts: package specification and package body.

• The package specification defines the public interface of the package, including declarations of variables, constants, cursors, procedures, and functions.

• The package body contains the actual implementation of the procedures and functions declared i...read more
Answered by AI
Add your answer
Q6. I got more questions from my project related
Add your answer

Q1. What are your reasons for wanting to join TCS?
Ans. 
I am excited about the opportunity to work with a global leader like TCS and contribute to innovative projects.
• TCS is a renowned global company with a strong reputation in the IT industry

• I am impressed by TCS's commitment to innovation and cutting-edge technology

• I believe TCS offers great opportunities for professional growth and development

• I am excited about the chance to work on diverse and challenging projects at TC
Answered by AI
Add your answer
Q2. What is your current salary package?
Ans. 
I prefer to discuss my salary expectations based on the responsibilities and requirements of the position.
• Focus on discussing salary expectations based on the job responsibilities and requirements.

• Avoid disclosing specific current salary package.

• Emphasize the importance of fair compensation based on market rates and skills.

• Provide examples of successful projects or achievements that demonstrate your value.

• Discuss oppor...read more
Answered by AI
Add your answer
Q3. What is your expected salary package?
Ans. 
I am looking for a competitive salary package based on my experience and skills.
• I am open to discussing salary based on the responsibilities and requirements of the role.

• I have researched the average salary range for Plsql Developers in this location.

• I am looking for a package that includes benefits such as healthcare, retirement plans, and professional development opportunities.
Answered by AI
Add your answer
Q4. Are you comfortable with shift work?
Ans. 
Yes, I am comfortable with shift work and have experience working various shifts.
• I have previous experience working different shifts in my current/previous roles.

• I am flexible with my schedule and can easily adapt to changing shift patterns.

• I understand the importance of shift work in ensuring 24/7 coverage for critical systems.
Answered by AI
Add your answer
Q5. Are you ok with any location
Ans. 
Yes, I am open to any location for the Plsql Developer position.
• I am willing to relocate for the right opportunity

• I am open to working in different cities or countries

• I am flexible with travel requirements for the job
Answered by AI
Add your answer
Q6. Holding any other offers in hand
Add your answer

A sequence was provided: 4181, 2684, 1597, 987, 610.
first 2 are given and write code for other value calculation using java 8

The second question required writing a reverse of a palindrome using both Java 8 streams. I was able to successfully write both and clear the first round.

Q1. Interviewer was himself not knowing anything as it was walkin drive he was sitting infront of me and checking questions on phone Introduction that he inturrepted in between when I was introducing myself
Add your answer
Q2. What are the features of Java 17, specifically related to sealed classes, including their syntax and necessity, along with the potential errors encountered when invoking a sealed class?
Ans. 
Java 17 introduces sealed classes to restrict inheritance and improve code maintainability.
• Sealed classes are declared using the 'sealed' keyword followed by the permitted subclasses.

• Subclasses of a sealed class must be either final or sealed themselves.

• Errors may occur when trying to extend a sealed class with a non-permitted subclass.
Answered by AI
Add your answer
Q3. Java 8 feathers stream api, functional interface, Intermittent operator ,Ternary operator, Prediction,Bi predicate. Answered all successfully
Add your answer
Q4. Draw low level design of implementation of notify me if item is back in stock in a ecommerce application
Ans. 
Implementation of 'notify me if item is back in stock' feature in an ecommerce application
• Create a database table to store user notifications for out-of-stock items

• Implement a service to check item availability and send notifications to subscribed users

• Provide a user interface for users to subscribe to notifications for specific items
Answered by AI
Add your answer
Q5. All design patterns which I know. Asked me to implement adapter pattern on paper
Add your answer
Q6. Then given a problem that concurrent way perform operation on excell to decrease the response time
Add your answer

Q1. Current CTC, Expected CTC, Notice Period, Skill set
Add your answer
Q2. Open for Fixed term hire? Open for working from client location at Gurgaon? (3 days from office)
Ans. 
Yes, open for fixed term hire and working from client location at Gurgaon for 3 days a week.
• Open for fixed term hire

• Willing to work from client location at Gurgaon for 3 days a week
Answered by AI
Add your answer

Q1. Introduction, Current role and responsibilities
Add your answer
Q2. List out the achievements in current project, Tools used
Ans. 
Implemented automated testing using Selenium WebDriver and JUnit in Agile environment
• Implemented automated testing framework using Selenium WebDriver

• Utilized JUnit for test case management

• Worked in Agile environment to ensure continuous testing and integration
Answered by AI
Add your answer
Q3. Pilot vs Beta testing. How can newly developed functionality be tested via automation rather doing it manually?
Ans. 
Pilot testing is done by a small group of users before the full release, while beta testing is done by a larger group of users. Automation testing can be used for regression testing, smoke testing, and performance testing.
• Pilot testing involves a small group of users testing the functionality in a controlled environment.

• Beta testing involves a larger group of users testing the functionality in a real-world environment.

• ...read more
Answered by AI
Add your answer
Q4. Primary key vs Unique key in SQL, Query to find row having last id in sql
Ans. 
Primary key uniquely identifies a record, while unique key allows only one instance of a value in a column. Query to find last id involves using ORDER BY and LIMIT.
• Primary key enforces uniqueness and not null constraint on a column

• Unique key enforces uniqueness but allows null values

• To find row with last id, use ORDER BY id DESC LIMIT 1 in SQL query
Answered by AI
Add your answer
Q5. Explain Software Testing Life Cycle, Defect Life Cycle
Ans. 
Software Testing Life Cycle (STLC) involves planning, designing, executing, and reporting on tests. Defect Life Cycle includes identification, logging, fixing, and retesting defects.
• STLC includes requirements analysis, test planning, test design, test execution, and test closure.

• Defect Life Cycle involves defect identification, defect logging, defect fixing, defect retesting, and defect closure.

• STLC ensures that the so...read more
Answered by AI
Add your answer
Q6. What's the meaning of 303 status code in API? Put vs Delete method in API What is 3 point estimation technique in Agile?
Ans. 
303 status code in API means 'See Other'. PUT method is used to update data, while DELETE method is used to remove data. 3 point estimation technique in Agile is used to estimate tasks.
• 303 status code indicates that the resource can be found at a different URI and should be retrieved from there

• PUT method is used to update an existing resource in the API

• DELETE method is used to remove a resource from the API

• 3 point esti...read more
Answered by AI
Add your answer
Q7. What kind of links and labels can be tagged to a bug in jira?
Ans. 
Links and labels that can be tagged to a bug in Jira
• Links: related issues, documents, websites

• Labels: priority, severity, type, status
Answered by AI
Add your answer
Q8. Have you done shell scripting? What does grep, href commands do in unix?
Ans. 
Shell scripting is a way to automate tasks in Unix/Linux systems. Grep is used to search for specific patterns in text files. Href is not a standard Unix command.
• Shell scripting automates tasks by writing scripts in a Unix/Linux environment

• Grep command is used to search for specific patterns in text files

• Example: grep 'search_pattern' file.txt

• Href is not a standard Unix command, it may be a typo or a custom script
Answered by AI
Add your answer
Q9. As a lead, how would you resolve conflict with a team member? As a lead, if you are given plenty of tasks to be completed with in a limited time frame. What would be your approach in doing them?
Ans. 
To resolve conflict with a team member, communication is key. Prioritize understanding, address the issue calmly, find common ground, and work towards a solution together.
• Listen to the team member's perspective and concerns

• Communicate openly and calmly about the issue

• Find common ground and areas of agreement

• Work together to find a solution that benefits both parties

• Seek input from other team members or a mediator if ne
Answered by AI
Add your answer
Q10. Open for relocating to Bangalore and working from client's office? (with no relocation bonus) Open for working in night / rotational shift? (with no additional compensation) Open for working in long exten...read more
Ans. 
Open to relocating to Bangalore, working in night shifts, long hours, and 24X7 culture. Goal is to excel in automation testing.
• Yes, open to relocating to Bangalore and working from client's office

• Yes, open to working in night/rotational shifts

• Yes, open to working in long extendable hours or 24X7 culture

• Goal is to excel in automation testing
Answered by AI
Add your answer

Q1. Multi cast in angular
Add your answer
Q2. Why event emitter what it does
Add your answer
Q3. Handling multiple api calls
Add your answer
Q4. Higher order functions
Add your answer
Q5. Child route and forRoot difference
Add your answer
Q6. Ng-container , ng-template
Add your answer

Q1. How many variance in sap?
Ans. 
The number of variances in SAP can vary depending on the specific processes and transactions being analyzed.
• The number of variances in SAP can be influenced by factors such as data entry errors, system glitches, or discrepancies in invoice processing.

• Variances in SAP may be identified through reconciliation processes, exception reports, or manual reviews of accounts payable transactions.

• Examples of variances in SAP inc...read more
Answered by AI
View 1 more answer
Q2. We cac explain the all accounts receivable and accounts payable
Ans. 
Accounts receivable and accounts payable are two important aspects of a company's financial operations.
• Accounts receivable refers to money owed to a company by its customers for goods or services provided.

• Accounts payable refers to money owed by a company to its suppliers or vendors for goods or services received.

• Accounts receivable is an asset on the balance sheet, while accounts payable is a liability.

• Managing accoun...read more
Answered by AI
View 2 more answers
Q3. What is the cost element and cost center?
Ans. 
Cost element and cost center are key concepts in accounting for tracking and allocating costs within an organization.
• Cost element refers to the specific types of costs incurred by an organization, such as materials, labor, or overhead.

• Cost center is a specific department, team, or function within an organization that is responsible for incurring costs.

• Cost elements are assigned to cost centers to track and allocate cos...read more
Answered by AI
View 2 more answers
Q4. How many we have currencies in sap?
Ans. 
SAP supports over 160 currencies worldwide.
• SAP supports over 160 currencies for global transactions.

• Currencies can be configured in SAP using transaction code OB22.

• Each currency is assigned a unique currency code (e.g. USD for US Dollar, EUR for Euro).
Answered by AI
View 1 more answer
Q5. How many types of projects
Ans. 
There are various types of projects, including internal projects, external projects, research projects, and development projects.
• Internal projects focus on improving processes within the organization.

• External projects involve working with external partners or clients.

• Research projects aim to gather data and analyze findings.

• Development projects focus on creating new products or services.

• Examples: IT system implementati...read more
Answered by AI
View 1 more answer