Emicon Advisory Services Interview Questions, Process, and Tips

Q1. What and why joins in sql
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the right table

• RIGHT JOIN re...read more
Answered by AI
Add your answer
Q2. What is ddl commands
Ans. 
DDL commands are Data Definition Language commands used to define, modify, and delete database objects.
• DDL stands for Data Definition Language

• Common DDL commands include CREATE, ALTER, and DROP

• Examples: CREATE TABLE, ALTER TABLE ADD COLUMN, DROP TABLE
Answered by AI
Add your answer

Q1. Why you think you are fit for this role
Ans. 
I have a strong background in data analysis, with experience in various tools and techniques.
• I have a degree in Statistics and have completed multiple data analysis projects during my studies.

• I am proficient in using tools like Excel, SQL, and Python for data analysis.

• I have experience in cleaning and analyzing large datasets to extract meaningful insights.

• I have excellent problem-solving skills and attention to detail
Answered by AI
Add your answer
Q2. Are you ready to move
Ans. 
Yes, I am ready to move for the right opportunity.
• I am open to relocating for a position that aligns with my career goals.

• I have experience moving for previous job opportunities.

• I am willing to consider different locations based on the job requirements.
Answered by AI
Add your answer

Logical, time, clock, speed

Data structure, logics

Q1. Brief intro of yourself
Ans. 
I am a software developer with 5 years of experience in Java, Python, and SQL.
• 5 years of experience in Java, Python, and SQL

• Worked on developing web applications using Java Spring framework

• Proficient in database management with SQL
Answered by AI
Add your answer
Q2. Internships projects
Add your answer

Q1. About coding oops
Add your answer
Q2. Binary search,array
Add your answer

Q1. Opps concepts friend function virtual function
Add your answer
Q2. What is constructor
Ans. 
A constructor is a special type of method that is automatically called when an object is created in a class.
• Constructors have the same name as the class they belong to.

• They are used to initialize the object's state.

• Constructors can have parameters to set initial values for object properties.

• Example: public class Car { public Car(String color) { this.color = color; } }
Answered by AI
Add your answer
Q3. What are friend function
Ans. 
Friend functions are functions that are not members of a class but have access to the private and protected members of the class.
• Friend functions are declared with the keyword 'friend' in the class definition.

• They can access private and protected members of the class they are friends with.

• Friend functions are not member functions of the class.

• They are often used to allow external functions or classes to access private
Answered by AI
Add your answer