Avisys Interview Questions, Process, and Tips

Women Empowerment Time 20 minutes

Q1. What is procedure and triggers
Ans. 
Procedures are stored routines for executing tasks; triggers are automated actions in response to database events.
• A procedure is a set of SQL statements that can be executed as a unit. Example: `CREATE PROCEDURE myProcedure AS BEGIN ... END;`

• Triggers are special types of stored procedures that automatically execute in response to certain events on a table. Example: `CREATE TRIGGER myTrigger BEFORE INSERT ON myTable FOR...read more
Answered by AI
Add your answer

Q1. What is your strengths
Ans. 
My strengths include problem-solving, technical expertise, and effective communication, enabling me to deliver optimal solutions.
• Strong analytical skills: I excel at diagnosing complex issues, as demonstrated when I optimized a database query, reducing execution time by 50%.

• Technical proficiency: My experience with Oracle databases allows me to implement best practices for performance tuning and data management.

• Effecti...read more
Answered by AI
Add your answer

Q1. Anypoint platform related
Add your answer

Q1. Salary discussion
Add your answer

Q1. What are your best skills
Add your answer

Q1. What are joins in SQL? What is the difference between union and full join?
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• Joins in SQL are used to retrieve data from multiple tables based on a related column.

• Types of joins include inner join, left join, right join, and full join.

• Union combines the result sets of two or more SELECT statements, while full join returns all rows when there is a match in either table.
Answered by AI
Add your answer

Q1. You must have good understanding of all OOPS concept
Add your answer