Unison Pharmaceuticals Interview Questions and Answers

SQL query to show data in ascending order

• Use the ORDER BY clause in SQL

• Specify the column you want to sort by

• Use ASC keyword for ascending order

Context is an object that provides access to application-specific resources and classes.

• Context is used to get access to system services, resources, preferences, etc.

• There are two types of context: Application Context and Activity Context.

• Application Context is tied to the lifecycle of the application and is available throughout the application.

• Activity Context is tied to the lifecycle of an activity and is available only within that activity.

• Context is passed as a parameter ...read more

RecyclerView is a flexible view for providing a limited window into a large data set.

• RecyclerView is used to display large data sets that can be scrolled efficiently.

• It reuses the views that are no longer visible to display new data.

• It uses a LayoutManager to position the items and a ViewHolder to cache the views.

• It provides built-in animations for adding, removing, and updating items.

• It supports both vertical and horizontal scrolling.

• It can be customized by creating custom L...read more

I remain calm, empathize with the customer, and offer a solution to address their concerns.

• Stay calm and composed

• Listen actively and empathize with the customer's frustration

• Apologize for any inconvenience caused

• Offer a solution or alternative options to resolve the issue

• Ensure clear communication and provide step-by-step guidance if needed

• Follow up with the customer to ensure their satisfaction

Array is a collection of elements of similar data type stored in contiguous memory locations. LinkedList is a data structure where each element is a separate object with a reference to the next element.

• Array has fixed size, LinkedList can grow dynamically

• Array has faster access time, LinkedList has faster insertion and deletion time

• Array is best for random access, LinkedList is best for sequential access

• Example of Array: int[] arr = {1, 2, 3}

• Example of LinkedList: LinkedList ...read more

Null is absence of value while object is a collection of properties and methods.

• Null is a primitive value while object is a complex data type.

• Null is used to indicate absence of value while object is used to represent real-world entities.

• Null cannot have properties or methods while object can have both.

• Example of null: let x = null; Example of object: let person = { name: 'John', age: 30 };

Powerpoint explanation involves presenting information using slides with text, images, and multimedia.

• Use bullet points to summarize key information

• Include visuals like graphs or images to enhance understanding

• Use animations sparingly to keep audience engaged

• Practice your presentation to ensure smooth delivery