i
Avisys
Filter interviews by
I applied via Referral and was interviewed in Jan 2023. There were 3 interview rounds.
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.
Top trending discussions
Aptitude test details in the snovasys are best aptitude test details in snovasys and in the snovasys i thought like i need to learn more in the aptitude atmy strating of career and all all all alllllllllllllllllllllllll abc and the best buddy program we have invested on the internet today at the speed limit of data and the policy are not good we need to improve all the data and the data is not good of all the data to be shared and with in the organisation all the data is must and should need to learn careful and all the data is need to know all the must and should detailed actions are taken on their data
I am unable to provide my current salary as it is confidential.
My current salary is confidential and I am unable to disclose it.
I prefer to discuss salary expectations rather than disclosing my current salary.
Salary is negotiable based on the position and responsibilities.
I am more interested in discussing the opportunities and growth potential in this role.
I applied via Campus Placement and was interviewed in Dec 2023. There were 2 interview rounds.
Give a pattern and solved people enter into techinal round 1.I cleard this test and enter to tr1
posted on 26 Apr 2024
I applied via Campus Placement and was interviewed before Apr 2023. There was 1 interview round.
String buffer is synchronized and thread-safe, while string builder is not synchronized and faster.
String buffer is synchronized, making it thread-safe for use in multi-threaded environments.
String builder is not synchronized, providing better performance in single-threaded applications.
String builder is faster than string buffer due to lack of synchronization overhead.
Example: StringBuffer sb = new StringBuffer(); Str...
Strings are immutable in order to ensure data integrity and security.
Immutable strings prevent accidental data modification, ensuring data integrity.
Immutable strings enhance security by preventing unauthorized access or tampering.
Immutable strings allow for more efficient memory management and optimization.
Example: 'Hello' cannot be changed to 'Hella' directly, a new string must be created.
Linear search is a simple searching algorithm that sequentially checks each element in a list until a match is found.
Iterate through each element in the list
Compare the current element with the target value
Return the index if a match is found, otherwise return -1
JDK includes JRE and development tools, while JRE includes only the Java Runtime Environment.
JDK stands for Java Development Kit, which includes JRE and development tools like compilers and debuggers.
JRE stands for Java Runtime Environment, which includes JVM and libraries necessary to run Java applications.
JVM stands for Java Virtual Machine, which is responsible for executing Java bytecode.
JDK is used for developing ...
posted on 24 Apr 2024
I applied via Campus Placement and was interviewed in Oct 2023. There were 3 interview rounds.
It was online 60min test.
It was offline 30 min test.
I applied via Campus Placement and was interviewed in Sep 2023. There were 4 interview rounds.
Python based questions
I applied via Recruitment Consulltant and was interviewed in Apr 2024. There was 1 interview round.
This question tests your ability to identify and generate patterns in coding.
Understand the pattern: Analyze the given examples to identify the underlying rule.
Use loops: Implement loops to generate sequences based on the identified pattern.
Consider edge cases: Ensure your solution handles special cases, like empty arrays or single elements.
Optimize for performance: Think about the time complexity of your solution, esp...
I appeared for an interview in Feb 2025.
They asked one coding question that is for star pattern question
posted on 1 Nov 2024
I applied via Campus Placement and was interviewed in Oct 2024. There were 2 interview rounds.
Number series in aptitude involves identifying the pattern in a sequence of numbers and predicting the next number.
Look for patterns such as arithmetic progression, geometric progression, or a combination of both.
Check for alternate numbers, differences between consecutive numbers, or multiplication factors.
Consider prime numbers, squares, cubes, or other mathematical operations applied to the series.
Example: 2, 4, 6, ...
Relationships in verbal communication are crucial for effective collaboration and understanding.
Verbal communication involves both verbal and non-verbal cues
Active listening is key to building strong relationships in verbal communication
Clarity and conciseness in speech can enhance relationships
Empathy and understanding of others' perspectives are important in verbal relationships
The four branches of OOP are encapsulation, inheritance, polymorphism, and abstraction.
Encapsulation: Bundling data and methods that operate on the data into a single unit.
Inheritance: Allowing a class to inherit properties and behavior from another class.
Polymorphism: The ability for objects of different classes to respond to the same method call.
Abstraction: Hiding the complex implementation details and showing only ...
Structures in C are user-defined data types that allow grouping of variables of different data types under a single name.
Structures are used to represent a record which consists of different data types.
They are defined using the 'struct' keyword.
Each variable in a structure is called a member.
Structures can be nested within other structures.
Example: struct employee { int emp_id; char emp_name[50]; float emp_salary; };
E...
I applied via Campus Placement and was interviewed in Sep 2024. There were 3 interview rounds.
Aptitude questions with some basic coding questions
They have given 3 coding questions and some pseudo codings
based on 1 interview experience
Difficulty level
Duration
Siebel Developer
10
salaries
| ₹3.5 L/yr - ₹16.5 L/yr |
Senior Software Engineer
8
salaries
| ₹7 L/yr - ₹9.5 L/yr |
QA Engineer
7
salaries
| ₹2.2 L/yr - ₹8.8 L/yr |
Oracle Brm Developer
6
salaries
| ₹2.3 L/yr - ₹8 L/yr |
Salesforce Developer
5
salaries
| ₹3.2 L/yr - ₹9.3 L/yr |
Zidio Development
Northcorp Software
Accel Frontline
Elentec Power India (EPI) Pvt. Ltd.