Ideassion Technology Solutions Interview Questions and Answers

Q1. Describe oops concept.
Ans. 
OOPs concept stands for Object-Oriented Programming, which is a programming paradigm based on the concept of objects.
• OOPs focuses on creating objects that contain both data and methods to manipulate that data.

• It emphasizes concepts like inheritance, encapsulation, polymorphism, and abstraction.

• Inheritance allows a class to inherit properties and behavior from another class.

• Encapsulation restricts access to certain comp...read more
Answered by AI
Add your answer

Q1. Reason for changing job and why should we hire you
Ans. 
Seeking new challenges and opportunities for growth. I bring a unique blend of skills and experience to add value to your team.
• Looking for new challenges and opportunities for professional growth

• Seeking a more dynamic work environment to utilize my skills effectively

• Excited about the possibility of contributing to a new team and organization

• Believe my diverse skill set and experience make me a valuable addition to your
Answered by AI
Add your answer

Q1. Real time DBA issues and scenarios
Add your answer
Q2. Questions on HA and Always on
Add your answer

SQL AND POWERBI related questions

Q1. How much you rate yourself in communication
Add your answer
Q2. How much you rate yourself in java
Ans. 
I rate myself 8 out of 10 in Java. I have strong knowledge and experience in Java programming.
• I have been working with Java for over 5 years

• I have completed multiple projects using Java

• I am familiar with advanced Java concepts such as multithreading and design patterns
Answered by AI
Add your answer

Oops concepts and one question of printing table of 2 in java

Q1. Tell me about yourself.
Add your answer
Q2. Why did you leave your previous company
Ans. 
Seeking new challenges and opportunities for growth.
• Desire for new challenges and opportunities for growth

• Looking for a company with better work-life balance

• Seeking a more collaborative team environment
Answered by AI
Add your answer

Make a calender app with adding events in date, update and delete

Q1. Do you know backend?
Ans. 
Yes, I have experience with backend development.
• Proficient in backend programming languages such as Java, Python, or Node.js

• Experience with databases like MySQL, MongoDB, or PostgreSQL

• Knowledge of RESTful APIs and web services

• Familiarity with server-side frameworks like Spring Boot, Django, or Express.js
Answered by AI
Add your answer
Q2. If you have a chance to do fullstack could you do it
Ans. 
Yes, I have experience in both front-end and back-end development, making me capable of handling fullstack development.
• I have experience in both front-end technologies like HTML, CSS, JavaScript, and back-end technologies like Node.js, Python, and databases like MySQL, MongoDB.

• I have worked on fullstack projects where I have developed both the client-side and server-side components.

• I am comfortable working with framewo...read more
Answered by AI
Add your answer

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. Javascript based coding question
Add your answer