Xcaliber Infotech Interview Questions and Answers

Q1. What is Self join
Ans. 
A self join is a SQL operation where a table is joined with itself to compare rows within the same table.
• Used to compare rows in the same table.

• Commonly used for hierarchical data, like employee-manager relationships.

• Example: SELECT A.name, B.name FROM employees A, employees B WHERE A.manager_id = B.id;

• Can help in finding duplicates or related records within a single table.
Answered by AI
Add your answer
Q2. What is Rls in power bi
Add your answer

Q1. What is bias variance tradeoff in machine learning
Ans. 
Bias-variance tradeoff is the balance between underfitting and overfitting in machine learning models.
• Bias refers to error from erroneous assumptions in the learning algorithm, leading to underfitting.

• Variance refers to error from sensitivity to small fluctuations in the training set, leading to overfitting.

• The tradeoff involves finding the right level of model complexity to minimize both bias and variance.

• Regularizati...read more
Answered by AI
Add your answer
Q2. Explain your project
Add your answer
Q3. Write a SQL code to find 2nd highest salary
Ans. 
SQL code to find 2nd highest salary
• Use the MAX() function to find the highest salary

• Use the WHERE clause to exclude the highest salary

• Order the salaries in descending order and limit the result to 1
Answered by AI
Add your answer

Q1. SQL queries (Aggregate Functions) Advanced excel Scenario Based Questions SQL Joins User Story
Add your answer

Q1. User Stories (2-3) Types of documents that BA prepares 5-6 scenario based questions Agile Methodologies Scrum Events and Artifacts
Add your answer

Basic Java arrays que

Q1. Basic technical que
Add your answer

Q1. Mostly SQL Questions Scenario based questions
Add your answer

Q1. Tricky scenario based questions Questions based on hobbies Asked to write User stories for specific requirements
Add your answer

Q1. Tell me about OOPS
Add your answer
Q2. What is multithreading
Ans. 
Multithreading is a programming technique that allows concurrent execution of multiple threads within a single process.
• Improves application performance by utilizing CPU resources more efficiently.

• Allows multiple tasks to run simultaneously, such as downloading files while processing data.

• Threads share the same memory space, which makes communication between them easier but requires careful synchronization.

• Commonly used...read more
Answered by AI
Add your answer