Club med Interview Questions and Answers

Q1. What are the assumptions of Linear Regression?
Ans. 
Assumptions of Linear Regression
• Linearity: The relationship between the independent and dependent variables is linear.

• Independence: The residuals are independent of each other.

• Homoscedasticity: The variance of residuals is constant across all levels of the independent variables.

• Normality: The residuals are normally distributed.

• No multicollinearity: The independent variables are not highly correlated with each other.
Answered by AI
Add your answer
Q2. How to evaluate your machine learning model?
Ans. 
Evaluate machine learning model by analyzing metrics like accuracy, precision, recall, F1 score, ROC curve, and confusion matrix.
• Calculate accuracy to measure overall performance of the model.

• Use precision to evaluate the proportion of true positive predictions among all positive predictions.

• Consider recall to assess the proportion of true positive predictions among all actual positives.

• Calculate F1 score as a balance ...read more
Answered by AI
Add your answer

Q1. What is R-Squared and Adjusted R Squared? Also brief about the difference?
Add your answer
Q2. Interpret the coefficients of Linear Regression and Binomial Logistic Regression?
Add your answer

Q1. Ducting types youed
Add your answer
Q2. Ducting any types of material
Add your answer
Q3. Mep for explain
Add your answer
Q4. Mep basic form housed property
Add your answer
Q5. Electrical line
Add your answer

Q1. Basic java fundamentals
Add your answer
Q2. Spring boot,sql
Add your answer

Q1. Some technical questions from manager
Add your answer
Q2. Some challenges or scenario based questions
Add your answer

Q1. Salary discussion mostly
Add your answer
Q2. Benifts that they offer with TR
Add your answer

Q1. MULTIPLE QUESTIONS OF OOPS
Add your answer
Q2. Program of prime number
Ans. 
A program to find prime numbers within a given range
• Iterate through numbers in the given range

• Check if each number is divisible by any number other than 1 and itself

• If not divisible, it is a prime number
Answered by AI
Add your answer
Q3. Pseudo code of finding ones in a number
Ans. 
Count the number of ones in a given number using pseudo code
• Initialize a count variable to 0

• Iterate through each bit of the number and check if it is 1

• Increment the count if the bit is 1

• Return the count as the result
Answered by AI
Add your answer
Q4. Basic questions of sql and mongodb
Add your answer

Q1. Can we use POST method instead of get method
Ans. 
Yes, POST method should be used for sending sensitive data or when data length exceeds URL limit.
• POST method should be used when sending sensitive data like passwords or personal information.

• POST method should be used when the data length exceeds the URL limit, as GET has a limit on the amount of data that can be sent.

• GET method should be used for retrieving data from the server without changing anything on the server.
Answered by AI
Add your answer
Q2. Difference between where and having clauses in sql
Ans. 
Where clause is used to filter rows before grouping, while having clause is used to filter groups after grouping.
• Where clause is used with SELECT, UPDATE, DELETE statements to filter rows based on a condition

• Having clause is used with GROUP BY statement to filter groups based on a condition

• Where clause is applied before grouping, having clause is applied after grouping

• Example: SELECT * FROM table_name WHERE column_name...read more
Answered by AI
Add your answer
Q3. What are the aggregate functions in SQL
Ans. 
Aggregate functions in SQL are used to perform calculations on a set of values and return a single value.
• Aggregate functions include functions like SUM, AVG, COUNT, MIN, and MAX.

• SUM - calculates the sum of values in a column

• AVG - calculates the average of values in a column

• COUNT - counts the number of rows in a result set

• MIN - finds the minimum value in a column

• MAX - finds the maximum value in a column
Answered by AI
Add your answer
Q4. What is the difference between path params and query params
Ans. 
Path params are part of the URL path, while query params are appended to the URL after a '?'
• Path params are used to identify a specific resource in the URL path, while query params are used to filter or sort the resources

• Path params are defined in the URL path itself, such as /users/{id}, while query params are appended to the URL, such as /users?sort=asc

• Path params are typically used for mandatory parameters, while qu...read more
Answered by AI
Add your answer
Q5. Write a SQL query on inner join (given with a table and data)
Ans. 
SQL query using inner join to retrieve data from two tables
• Use INNER JOIN to combine rows from two tables based on a related column

• Specify the columns to select from each table

• Add a condition to match the related columns in the ON clause
Answered by AI
Add your answer
Q6. Application module to find bugs
Ans. 
One way to find bugs in an application module is through thorough testing and using debugging tools.
• Conduct thorough testing of the application module to identify bugs

• Use debugging tools like breakpoints, logging, and profiling to pinpoint and fix bugs

• Implement automated testing to catch bugs early in the development process
Answered by AI
Add your answer

SQL Joins and Window functions in SQL
Asked about Stored Procedures and implementations
Tableau LOD's
Tableau Parameters

Usual aptitude test you would expect from a bank

Q1. Why mizho and why the department specifically
Add your answer
Q2. Talk about a market news
Ans. 
The recent surge in Tesla's stock price due to strong quarterly earnings report
• Tesla's stock price increased by 10% after reporting better-than-expected earnings

• Investors were impressed by Tesla's profitability and strong delivery numbers

• Analysts raised their price targets for Tesla following the earnings report
Answered by AI
Add your answer

Q1. Power bi needs and measure required
Ans. 
Power BI needs and measures required for effective data analysis and visualization.
• Identify key performance indicators (KPIs) to track and measure

• Ensure data is clean, accurate, and up-to-date for reliable analysis

• Create interactive visualizations and reports to communicate insights effectively

• Utilize DAX formulas for advanced calculations and measures

• Implement data modeling techniques for efficient data organization

• Re...read more
Answered by AI
Add your answer
Q2. Python code to exploring k means clustering for customer segmentation
Add your answer