Accelya Solutions India Limited Interview Questions, Process, and Tips

Aptitude test simple one

Q1. SQL and Java basic Questions
Add your answer

It was a basic aptitude test with logical reasoning questions. They just conduct this to test your speed for logic reasoning

Q1. Questions were mainly based on Java, Springboot and MySQL. I coding question was asked which was quite very simple to answer.
Add your answer

Q1. This round was with the senior person where again Java,Springboot and different technologies related questions were asked.
Add your answer

Q1. This was the final HR round for salary negotiation.
Add your answer

Aptitude test, examination that attempts to determine and measure a person's ability to acquire, through future training, some specific set of skills (intellectual, motor, and so on).

A case study is a research approach that is used to generate an in-depth, multi-faceted understanding of a complex issue in its real-life context. It is an established research design that is used extensively in a wide variety of disciplines, particularly in the social sciences.

40 question and 20 mins

Q1. About yourself and details
Add your answer

Q1. What is record and explain?
Ans. 
Record is a composite data type that stores related fields together.
• A record is a user-defined data type that contains a group of related data items.

• It is also known as a row or tuple in a table.

• Each field in a record can have a different data type.

• Records are commonly used in PL/SQL to hold query results or to pass data between procedures.

• Example: DECLARE emp_rec employees%ROWTYPE;

• This creates a record variable emp_re...read more
Answered by AI
Add your answer
Q2. PROCEDUR VS FUNCTIONS
Ans. 
Procedures are used to perform an action, while functions return a value.
• Procedures do not return values, but can have output parameters

• Functions must return a value and cannot have output parameters

• Procedures can modify data, while functions cannot

• Functions can be used in SQL queries, while procedures cannot
Answered by AI
Add your answer
Q3. What are collections and its type?
Ans. 
Collections are data structures used to store multiple values of the same data type.
• Types of collections in Oracle are Associative arrays, Nested tables, and Varrays.

• Associative arrays are indexed by string values, Nested tables are like arrays with no fixed size, and Varrays are like arrays with a fixed size.

• Collections can be used to pass multiple values to a stored procedure or function.
Answered by AI
Add your answer