Clavita Pharma Interview Questions and Answers

Strings in Java are sequences of characters. They are immutable objects and can be created using string literals or the new keyword.

• Strings can be created using string literals: String str = "Hello";

• Strings can also be created using the new keyword: String str = new String("World");

• Strings can be concatenated using the + operator: String result = str1 + str2;

Data modelling is the process of creating a conceptual representation of data and its relationships.

• It involves identifying entities, attributes, and relationships between them.

• It helps in designing efficient databases and improving data quality.

• Examples include ER diagrams, UML diagrams, and data flow diagrams.

Collections in Java are frameworks that provide an architecture to store and manipulate a group of objects.

• Collections provide interfaces (List, Set, Map) and classes (ArrayList, HashSet, HashMap) to store and manipulate groups of objects.

• Collections framework includes algorithms to manipulate collections, such as sorting, searching, and shuffling.

• Collections in Java are part of the Java Collections Framework (JCF) and provide dynamic arrays, linked lists, hash tables, trees,...read more

Power BI is a business analytics service by Microsoft that provides interactive visualizations and business intelligence capabilities.

• Power Query for data transformation

• Power Pivot for data modeling

• Power View for data visualization

• Power Map for geospatial data visualization

• Power Q&A for natural language query

• Power BI Desktop for report authoring

• Power BI Service for sharing and collaboration

Power Pivot is a data modeling tool in Excel that allows users to create relationships and analyze large data sets.

• Power Pivot is an add-in for Microsoft Excel.

• It allows users to create data models and relationships between tables.

• Users can analyze large data sets with fast performance.

• It supports advanced calculations and data analysis functions.

• Power Pivot can handle millions of rows of data.

• It is commonly used for business intelligence and data analysis tasks.