20+ Assure Pharma Interview Questions and Answers

The camel will take 1000 bananas to reach point B.

• The camel will eat one banana per kilometer.

• The maximum number of bananas the camel can carry is 1000.

• The camel can take frequent stops.

• Therefore, the camel will take 1000 bananas to reach point B.

Yes, SQL queries can be written in Python using libraries like SQLAlchemy or Pandas.

• Python provides libraries like SQLAlchemy and Pandas for executing SQL queries.

• SQLAlchemy allows writing SQL queries in Python syntax and provides an Object-Relational Mapping (ORM) layer.

• Pandas provides a SQL-like interface called 'pandasql' to query DataFrames using SQL syntax.

• Both libraries offer flexibility and convenience in executing SQL queries within Python scripts.

I would use websockets for real-time data updates in both web and mobile applications.

• Implement websockets to establish a persistent connection between the server and clients

• Use a pub/sub system to notify clients of data changes

• Update the UI in real-time based on the incoming data

• Optimize data transfer to reduce latency and improve performance

Different types of regression analysis include linear regression, logistic regression, polynomial regression, ridge regression, and lasso regression.

• Linear regression: Predicts a continuous outcome based on one or more input features.

• Logistic regression: Predicts the probability of a binary outcome.

• Polynomial regression: Fits a curve to the data by including polynomial terms.

• Ridge regression: Adds a penalty term to the linear regression to prevent overfitting.

• Lasso regression...read more

Transformer based models use self-attention mechanism to capture long-range dependencies in data.

• Transformer models consist of encoder and decoder layers.

• Self-attention mechanism allows each word to attend to all other words in the input sequence.

• Positional encoding is added to input embeddings to provide information about the position of words.

• Transformer models have achieved state-of-the-art results in various NLP tasks such as machine translation, text generation, and sent...read more

Various NLP techniques for text extraction include Named Entity Recognition, Part-of-Speech tagging, and Dependency Parsing.

• Named Entity Recognition (NER) identifies entities such as names, dates, and locations in text.

• Part-of-Speech tagging assigns grammatical categories to words in a sentence.

• Dependency Parsing analyzes the grammatical structure of a sentence to identify relationships between words.

Confusion matrix is a table used to evaluate the performance of a classification model.

• It is a matrix with rows representing the actual class and columns representing the predicted class.

• It helps in visualizing the performance of a classification model by showing the counts of true positive, true negative, false positive, and false negative predictions.

• It is commonly used in machine learning to assess the quality of the classification model.

• Example: In a binary classification...read more

To test data in Excel file, use tools like Excel functions, data validation, and manual verification.

• Use Excel functions like VLOOKUP, SUM, COUNT, etc. to verify data accuracy.

• Apply data validation rules to ensure data consistency and integrity.

• Manually review the data for any anomalies or errors.

• Perform regression testing to check for any changes in data over time.

Web components are reusable custom elements for building web applications.

• Web components allow for encapsulation of HTML, CSS, and JavaScript into reusable components.

• They can be easily reused across different web pages or applications.

• Examples include custom elements like , , and .

To print nodes with no edges in a unidirectional graph, iterate through all nodes and print those without any outgoing edges.

• Iterate through all nodes in the graph

• For each node, check if it has any outgoing edges

• If a node has no outgoing edges, print it

Anagram question solved without using any inbuilt functions

• Create a function to check if two strings are anagrams by comparing the frequency of characters

• Iterate through both strings and count the frequency of each character

• Compare the frequency of characters in both strings to determine if they are anagrams

I will test the login page by verifying input validation, authentication process, error handling, and session management.

• Verify input validation by entering invalid credentials

• Test authentication process by entering correct credentials

• Check error handling by entering incorrect credentials

• Test session management by logging in and out multiple times

Data structures in Python are ways to store and organize data efficiently.

• Data structures in Python include lists, tuples, dictionaries, sets, and arrays.

• Lists are ordered, mutable, and can contain duplicate elements.

• Tuples are ordered, immutable, and can contain duplicate elements.

• Dictionaries are unordered, mutable, and store data in key-value pairs.

• Sets are unordered, mutable, and do not allow duplicate elements.

• Arrays are used to store multiple values in a single variable...read more

Frequency of elements in an array

• Iterate through the array and count the occurrences of each element

• Store the counts in a map or dictionary for easy access

• Return the map/dictionary with element frequencies

Tech stack for real time applications includes WebSocket, Node.js, Redis, and MongoDB.

• Use WebSocket for real-time communication between client and server

• Node.js for server-side logic and handling multiple connections efficiently

• Redis for caching and storing real-time data

• MongoDB for persistent data storage and retrieval

Resultant rows for different SQL joins

• Inner join - returns rows that have matching values in both tables

• Left join - returns all rows from the left table and the matched rows from the right table

• Right join - returns all rows from the right table and the matched rows from the left table

• Full outer join - returns all rows when there is a match in either left or right table

Manual testing is the process of manually testing software for defects, functionality, and usability.

• Involves testers executing test cases manually without the use of automation tools

• Requires human intervention to observe and verify the expected outcomes

• Helps in identifying user interface issues, usability problems, and other defects

• Can be time-consuming and prone to human error

• Examples include exploratory testing, ad-hoc testing, and regression testing

Defect clustering is the phenomenon where a small number of modules or functionalities in a software system are responsible for the majority of defects.

• Defect clustering suggests that a small portion of the software code is more error-prone than others.

• Identifying and focusing on these high-defect modules can help improve overall software quality.

• Examples of defect clustering include certain modules consistently causing issues or specific functionalities leading to frequent d...read more

Vlookup is simpler and easier to use, while Index Match is more flexible and efficient.

• Vlookup is easier for beginners to understand and use

• Vlookup is quicker to set up and requires less formula writing

• Index Match is more flexible as it can look up values in any column, not just the first one

• Index Match is more efficient for large datasets as it does not require the entire column to be searched

Impact analytics is the practice of using data analysis to measure and understand the effects of decisions and actions.

• Impact analytics helps organizations make informed decisions based on data-driven insights

• It allows businesses to track the success of their strategies and initiatives

• By analyzing data, organizations can identify areas for improvement and optimize their operations

• Examples include measuring the impact of marketing campaigns on sales, analyzing customer feedbac...read more

HTML5 introduced new features like semantic elements, audio/video support, canvas for graphics, local storage, and improved form controls compared to HTML3.

• HTML5 introduced semantic elements like <header>, <footer>, <nav>, <article>, <section> for better structure and SEO.

• HTML5 added native support for audio and video playback without the need for plugins.

• Canvas element in HTML5 allows for dynamic graphics and animations without the need for Flash.

• Local storage in HTML5 allow...read more

BRD focuses on business requirements while FRD focuses on functional requirements.

• BRD (Business Requirements Document) outlines the business problem that needs to be solved.

• FRD (Functional Requirements Document) details how the system will meet the business requirements.

• BRD is more high-level and focuses on the 'what', while FRD is more detailed and focuses on the 'how'.

• BRD is typically created before FRD in the project lifecycle.

• Example: BRD may state the need for a customer...read more

loc and iloc are methods in pandas used for selecting rows and columns by label or integer position.

• loc is used for selecting rows and columns by label

• iloc is used for selecting rows and columns by integer position

• Example: df.loc[0:5, 'column_name']

• Example: df.iloc[0:5, 2]

Retail experience and analysis

• I have over 5 years of experience in retail industry analysis

• Proficient in using data analytics tools to track sales trends and customer behavior

• Implemented strategies based on market research to increase sales and customer satisfaction

• Collaborated with cross-functional teams to optimize inventory management and pricing strategies

Black box testing is a software testing method where the internal structure or code of the application is not known to the tester.

• Tester focuses on the functionality of the software without knowing its internal workings

• Tests are based on requirements and specifications

• Input data is provided and output is compared against expected results

• Examples include equivalence partitioning, boundary value analysis, and decision table testing

Regression testing is the process of retesting a software application to ensure that new code changes have not adversely affected existing functionality.

• Regression testing is performed after code changes to verify that the existing features still work correctly.

• It helps in identifying any defects introduced by new code changes.

• Automated testing tools are often used for regression testing to save time and effort.

• Examples of regression testing include running test cases that co...read more

I have worked on projects involving data analysis, visualization, and predictive modeling.

• Developed predictive models using machine learning algorithms

• Performed data cleaning and preprocessing to ensure data quality

• Created interactive dashboards for data visualization

• Collaborated with cross-functional teams to derive insights from data

A clean and user-friendly navigation bar with dropdown menus for easy access to different sections of the website.

• Include main navigation links such as Home, About Us, Services, Contact

• Use dropdown menus for subcategories under each main link

• Ensure the navigation bar is responsive for mobile devices