Agivant Technologies Interview Questions and Answers

Count vowels and consonants in a given string

• Iterate through each character in the string and check if it is a vowel or consonant

• Keep separate counters for vowels and consonants

• Consider both uppercase and lowercase characters

• Exclude spaces and special characters from counting

Use Sieve of Eratosthenes algorithm to find prime numbers between 1 to n.

• Implement Sieve of Eratosthenes algorithm

• Iterate through numbers from 2 to n

• Mark multiples of each number as non-prime

• Remaining unmarked numbers are prime

ArrayList is better for random access and LinkedList is better for frequent insertions and deletions.

• ArrayList uses dynamic array to store elements, allowing fast random access but slower insertions and deletions.

• LinkedList uses doubly linked list to store elements, allowing fast insertions and deletions but slower random access.

• Example: Use ArrayList when you need to frequently access elements by index. Use LinkedList when you need to frequently add or remove elements.

List is an ordered collection, Set is a collection with no duplicates, Map is a key-value pair collection.

• List maintains insertion order, Set does not allow duplicates, Map stores key-value pairs

• List example: ArrayList, Set example: HashSet, Map example: HashMap

School ERP is a software system designed to manage and automate school operations.

• It includes features like student information management, attendance tracking, gradebook management, and communication tools.

• School ERP can also handle administrative tasks like payroll and budgeting.

• Examples of school ERP systems include PowerSchool, Infinite Campus, and Skyward.

• School ERP can improve efficiency, communication, and data accuracy in schools.

Yes, a pivot table is a data summarization tool used in spreadsheet programs.

• Pivot tables allow users to quickly summarize and analyze large amounts of data.

• They can be used to group data by categories, calculate totals and averages, and create custom calculations.

• Pivot tables are commonly used in Excel and other spreadsheet programs.

• They are especially useful for financial analysis, sales data, and other large datasets.