Avanze Technologies Senior Processing Executive Interview Questions and Answers

Q1. Interface vs abstract class
Ans. 
Interface defines a contract while abstract class provides partial implementation.
• Interfaces can only have abstract methods while abstract classes can have both abstract and non-abstract methods.

• A class can implement multiple interfaces but can only inherit from one abstract class.

• Interfaces are used for loose coupling while abstract classes are used for code reusability.

• Example of interface: Runnable interface in Java...read more
Answered by AI
Add your answer
Q2. What is Method overloading?
Ans. 
Method overloading is when a class has multiple methods with the same name but different parameters.
• Method overloading allows for flexibility in method calls

• The methods must have different parameters, such as different data types or different numbers of parameters

• Example: public void print(int num) and public void print(String str)

• The compiler determines which method to call based on the arguments passed
Answered by AI
Add your answer
Q3. Indexing of sqlsever dstsbase
Ans. 
Indexing in SQL Server database
• Indexing improves query performance by creating a structure that allows for faster data retrieval

• Clustered and non-clustered indexes are the two types of indexes in SQL Server

• Clustered indexes determine the physical order of data in a table while non-clustered indexes create a separate structure

• Indexing should be done strategically to avoid over-indexing which can slow down data modificat
Answered by AI
Add your answer
Q4. Value type & reference type
Add your answer

Q1. Only Salary negitiation
Add your answer

Q1. Few common questions from project & why did u left your current organization
Add your answer

Q1. Finding the second maximum number in the list
Ans. 
To find the second maximum number in a list, sort the list in descending order and return the second element.
• Sort the list in descending order

• Return the second element in the sorted list
Answered by AI
Add your answer

Q1. Loops in Informatica
Ans. 
Loops in Informatica are used to iterate over a set of data or perform repetitive tasks.
• Loops in Informatica can be implemented using the 'Expression' or 'Router' transformations.

• They are useful for processing multiple rows of data in a mapping.

• Common types of loops include 'While' and 'For' loops.

• Loops can help in performing complex data transformations and validations.
Answered by AI
Add your answer

Q1. What is the reason for change
Add your answer

Two coding round in Javascript, first one to right CRUD operation in React.

Second one have to right JS for Flattened Array

Q1. Asking about Salary Structure
Add your answer

Q1. Concepts on oops progressing the way that it will include
Add your answer
Q2. Answers on the dilegent way
Add your answer

Q1. How many year experience
Ans. I have 10 year experience same office
Answered Anonymously
View 3 more answers
Q2. When you will join company?
Ans. If i got selected i need 30 days paper period on my current office
Answered Anonymously
Add your answer
Q3. How much salary you will expected?
Ans. I will expect 20 k salary
Answered Anonymously
Add your answer
Q4. Are u interested to work night shift
Ans. Yes I interested day or night shift
Answered Anonymously
Add your answer
Q5. Are u interested to week end
Add your answer
Q6. Why you resign your current office
Ans. I interested to learn new things that's only reason
Answered Anonymously
Add your answer
Q7. You interested voice or non voice job
Add your answer
Q8. Tell me your interest skills
Ans. I am to work always sir
Answered Anonymously
Add your answer