Pragmasys Consulting LLP CRM Consultant Interview Questions, Process, and Tips

I was given a pdf file containing 3 Problem statements along with the output for which I had to write SQL queries.

Q1. Theoretical Questions related to SQL were asked like types of join, the difference between union and join, related to my project, and some behavioral questions.
Add your answer
Q2. What are different types of Joins?
Ans. 
Joins are used to combine data from two or more tables based on a related column between them.
• 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 b
Answered by AI
Add your answer
Q3. What is the Difference between Union and Joins
Ans. 
Joins combine rows from two or more tables based on a related column, while unions combine rows from two or more tables with the same structure.
• Joins are used to combine data from different tables based on a related column

• Unions are used to combine data from tables with the same structure

• Joins can be inner, left, right, or full, while unions are always a combination of all rows

• Joins can have multiple conditions, while ...read more
Answered by AI
Add your answer

Q1. Scenario-based questions on SQL
Add your answer

Q1. Questions related to me like what my parents do etc. and their company profile.
Add your answer

Q1. How to find unique elements in an array using Java?
Ans. 
Use a Set to store unique elements from the array.
• Create a Set to store unique elements.

• Iterate through the array and add each element to the Set.

• The Set will automatically remove duplicates, leaving only unique elements.
Answered by AI
Add your answer

Q1. How to configure multiple database in spring boot?
Ans. 
To configure multiple databases in Spring Boot, you can use Spring Data JPA with multiple data sources.
• Define multiple DataSource beans in your configuration class.

• Configure each DataSource bean with its own properties like URL, username, password, etc.

• Use @Primary annotation to specify the primary DataSource bean.

• Use @Qualifier annotation to specify which DataSource bean to use in your repositories or services.

• Configu...read more
Answered by AI
Add your answer

Setup a cluster and find the bottleneck of performance.

Q1. Ways to deal with latency in Cassandra
Ans. 
Ways to optimize latency in Cassandra
• Use appropriate data modeling to reduce the number of queries needed

• Optimize queries by using appropriate indexes and clustering keys

• Tune the Cassandra configuration settings for better performance

• Use caching mechanisms like Memcached or Redis to reduce latency

• Consider using partitioning strategies to distribute data evenly across nodes
Answered by AI
Add your answer

SQL AND POWERBI related questions

PEN PAPER round consisting of three coding and c/c++ output based questions.

Q1. OOPS concepts , javascript
Add your answer
Q2. Projects related questions
Add your answer

Q1. Behavioural questions
Add your answer
Q2. Resume , internship related questions
Add your answer

Asked about JavaScript Topics
1. Promise
2. Clousure
3. Hoisting.

Create an Application Routes are protected by different roles in ReactJS

Q1. What you want to join this company
Ans. 
I want to join this company because of its innovative projects and strong company culture.
• Innovative projects in AI and machine learning excite me

• Positive reviews from current employees about company culture

• Opportunities for growth and learning in the tech industry
Answered by AI
Add your answer
Q2. Where do you see yourself in 5 years
Ans. 
In 5 years, I see myself as a senior software engineer leading a team of developers on innovative projects.
• Advancing to a senior software engineer role

• Leading a team of developers on projects

• Working on innovative and challenging projects

• Continuing to learn and grow in the field
Answered by AI
Add your answer
Q3. What is most important to company good culture or handsome package or both and why
Ans. 
Both good culture and a handsome package are important for a company as they contribute to employee satisfaction and retention.
• A good culture fosters a positive work environment, promotes collaboration, and boosts employee morale.

• A handsome package attracts top talent, motivates employees to perform well, and reduces turnover rates.

• Having both good culture and a handsome package can lead to higher employee satisfaction...read more
Answered by AI
Add your answer