Helm360
Dharmarth Homoeopathic Interview Questions and Answers
Q1. one number is missing from 1 to 100. Find it's value
One number is missing from 1 to 100. Find it's value.
Use the formula n(n+1)/2 to find the sum of numbers from 1 to 100
Subtract the sum of numbers given from the sum of numbers from 1 to 100 to find the missing number
The missing number is 5050 minus the sum of given numbers
Q2. If you have 500 test cases and only few hours for regression, how will you do it ?
Prioritize test cases based on criticality and impact, automate repetitive tests, and focus on high-risk areas.
Prioritize test cases based on criticality and impact
Automate repetitive tests using test automation tools
Focus on high-risk areas to ensure maximum coverage in limited time
Q3. Difference between abstract class and interfaces
Abstract classes can have implementation while interfaces cannot. Classes can implement multiple interfaces but only inherit from one abstract class.
Abstract classes can have constructors while interfaces cannot
Interfaces can only have method signatures while abstract classes can have both method signatures and implementation
Abstract classes can have access modifiers while interfaces cannot
Classes can implement multiple interfaces but only inherit from one abstract class
Q4. What is Regression 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.
Regression testing can be done manually as well as automatically....read more
Q5. Fundamentals of SQL
SQL is a programming language used to manage and manipulate relational databases.
SQL stands for Structured Query Language
It is used to create, modify, and query databases
Common SQL commands include SELECT, INSERT, UPDATE, and DELETE
SQL is used in various industries including finance, healthcare, and e-commerce
Q6. Joins used in SQL
Joins are used in SQL to combine data from two or more tables based on a related column.
INNER JOIN returns only the matching rows from both tables
LEFT JOIN returns all rows from the left table and matching rows from the right table
RIGHT JOIN returns all rows from the right table and matching rows from the left table
FULL OUTER JOIN returns all rows from both tables
CROSS JOIN returns the Cartesian product of both tables
Q7. Project Description
Developed a predictive model to forecast sales for a retail company
Used historical sales data to train the model
Incorporated external factors such as weather and holidays
Evaluated model performance using metrics like RMSE and MAE
Q8. Complete SQL till Indexing
SQL indexing is a technique to improve query performance by creating indexes on columns in database tables.
Indexes are created using CREATE INDEX statement in SQL.
Indexes can be clustered or non-clustered.
Clustered indexes physically reorganize the table to match the index order.
Non-clustered indexes store a separate copy of the indexed columns.
Indexes should be created on columns frequently used in WHERE, JOIN, and ORDER BY clauses.
Indexes can be unique or non-unique.
Interview Process at Dharmarth Homoeopathic
Top Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month