Oracle Financial Services Software
10+ Aurobindo Pharma Interview Questions and Answers
Suppose there are N balls. out of which only 1 ball is lighter in weight. You are given a simple balance. Then How many minimum no. of attempts do one take to find out that lighter ball. and how many maxi...read more
Minimum number of attempts to find the lighter ball is ceil(log2(N)) and maximum number of attempts is 3.
Minimum attempts: ceil(log2(N))
Maximum attempts: 3
Condition for maximum attempts: N must be greater than or equal to 9
Given an array/list 'ARR' of ‘N’ distinct integers, you are supposed to find the third largest element in the given array 'ARR'.
Input Format :
The first line contains a single integer ‘T’...read more
The task is to find the third largest element in an array of distinct integers.
Read the number of test cases 'T'
For each test case, read the number of elements 'N' and the array 'ARR'
Sort the array in descending order
Return the element at index 2 as the third largest element
Ninja has to implement an ‘AVL_TREE’ from scratch.
He is given ‘N’ values, representing the values of nodes to be inserted. Ninja has to insert these values into the ‘AVL_TREE’ and return i...read more
The question asks to implement an AVL_TREE from scratch and insert given values into it.
AVL_TREE is a self-balancing binary search tree
The height difference between left and right subtrees of all nodes should not be more than one
Implement the AVL_TREE data structure and insertion algorithm
Return the root of the AVL_TREE after inserting all the nodes
Which is the correct SQL query to select the top 5 numbers from the given data?
The correct SQL query to select the top 5 numbers from the given data is 'SELECT TOP 5 number FROM table_name ORDER BY number DESC'.
Use the 'SELECT' statement to specify the columns you want to retrieve.
Use the 'TOP' keyword followed by the number of rows you want to select.
Specify the column name in the 'ORDER BY' clause to sort the data in descending order.
Asked me to write a query to select some data from large collection of it.
Write a query to select data from a large collection.
Use the SELECT statement to specify the columns you want to retrieve.
Use the FROM clause to specify the table or tables from which to retrieve the data.
Use the WHERE clause to specify any conditions that the retrieved data must meet.
Use the ORDER BY clause to sort the retrieved data in a specific order.
Use the LIMIT clause to limit the number of rows returned, if necessary.
Q6. Reason for selecting certain technologies in the project
We selected technologies based on project requirements, team expertise, scalability, and cost-effectiveness.
Considered project requirements and objectives
Leveraged team expertise in certain technologies
Chose scalable technologies for future growth
Evaluated cost-effectiveness of different options
Q7. What do you know about Java?
Java is a popular programming language used for developing various applications.
Java is an object-oriented language
It is platform-independent
Java code is compiled into bytecode
Java has a vast library of pre-built classes and functions
Java is used for developing web applications, mobile apps, desktop applications, and more
Q8. Describe Operating System.
An operating system is a software that manages computer hardware and software resources.
It acts as an interface between the user and the computer hardware.
It manages memory, processes, and input/output devices.
Examples include Windows, macOS, and Linux.
It provides a platform for other software to run on.
It ensures security and manages user accounts.
Q9. what is Inheritance in java
Inheritance in Java allows a class to inherit properties and behavior from another class.
Inheritance enables code reusability and promotes a hierarchical relationship between classes.
Subclasses inherit attributes and methods from a superclass.
Java supports single and multiple inheritance through classes and interfaces.
Example: class Car extends Vehicle {}
Q10. how does hashmap works
HashMap is a data structure that stores key-value pairs and allows for fast retrieval of values based on keys.
HashMap uses a hash function to map keys to indices in an array.
It allows for constant-time retrieval, insertion, and deletion of key-value pairs.
Collisions can occur when multiple keys map to the same index, which is resolved using techniques like chaining or open addressing.
Q11. diff between comparator and comparable
Comparator is used to define custom sorting order for objects, while Comparable is an interface used to implement natural ordering of objects.
Comparator is used to define custom sorting order for objects, while Comparable is used to implement natural ordering of objects
Comparator interface has a compare() method, while Comparable interface has a compareTo() method
Comparator can be used to sort objects based on multiple criteria, while Comparable can only be used for single cr...read more
Q12. 4 Pillars of OOPS DBMS
The 4 pillars of OOPS are Inheritance, Encapsulation, Abstraction, and Polymorphism.
Inheritance allows a class to inherit properties and behavior from another class.
Encapsulation refers to the bundling of data with the methods that operate on that data.
Abstraction focuses on hiding the implementation details and showing only the necessary features of an object.
Polymorphism allows objects to be treated as instances of their parent class.
Top HR Questions asked in Aurobindo Pharma
Interview Process at Aurobindo Pharma
Top Associate Consultant Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month