Esha Media Research Interview Questions and Answers

Self intro, about your College life

Q1. How important is communication style in the interview process?
Add your answer

Q1. What can you tell me about your final year project and your performance in verbal and accent tests for communication?
Add your answer

It is all about reasoning.

GD is all about how to build Business Strategy in short term

Q1. Introduce Your self
Add your answer
Q2. Where do you see after 5 years
Add your answer
Q3. Salary expectation
Add your answer
Q4. Rate yourself within 10
Add your answer
Q5. Why are you join this institute
Add your answer

It was a 100-minute test consisting of mcqs and one coding question on articulation points in the graph.

Q1. What is the difference between Postgresql and MySQL?
Ans. 
Postgresql is known for its advanced features and support for complex queries, while MySQL is popular for its ease of use and speed.
• Postgresql is known for its advanced features such as support for complex queries, indexing, and JSON data types.

• MySQL is popular for its ease of use, speed, and compatibility with various platforms.

• Postgresql has a strong focus on standards compliance and extensibility, while MySQL is mor...read more
Answered by AI
Add your answer
Q2. What are ACID properties in DBMS?
Ans. 
ACID properties in DBMS ensure data integrity and consistency in transactions.
• Atomicity: All operations in a transaction are completed successfully or none at all.

• Consistency: Data is always in a valid state before and after a transaction.

• Isolation: Transactions are executed independently without interference from other transactions.

• Durability: Once a transaction is committed, changes are permanent and cannot be lost.

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

Q1. SQL Window Functions and RANK, DENSE RANK Difference
Ans. 
SQL Window Functions like RANK and DENSE RANK are used to assign a rank to rows within a partition.
• RANK function assigns a unique rank to each distinct row within a partition.

• DENSE RANK function assigns a unique rank to each distinct row within a partition, but without any gaps.

• Both functions are used with the OVER() clause in SQL to define the partition and order of rows.
Answered by AI
Add your answer
Q2. Hadoop Default Replication Factor
Add your answer

String Array manipulation

Q1. Different activity launch modes, services, intent-services
Ans. 
Different launch modes control how activities are launched, services run in the background, and intent-services handle asynchronous tasks.
• Launch modes include standard, singleTop, singleTask, and singleInstance

• Services are used for long-running operations in the background

• Intent-services are used for handling asynchronous tasks on a separate worker thread
Answered by AI
Add your answer
Q2. Normal android sdk related questions and about third party libraries
Add your answer

Q1. Interview with India Director
Add your answer

Q1. Let me know about yourself
Add your answer
Q2. Normal queries about you
Add your answer

Q1. Excel questions
Add your answer

Q1. Personality questions
Add your answer

Q1. Basic interview question and about the experiance related and why you left the previous company.
Add your answer

Q1. 2 sum problem [leetcode]
Add your answer
Q2. Linkedlist problem
Ans. 
Implement various operations on a linked list and solve related problems like reversing a linked list or detecting a cycle.
• Understand the basic structure of a linked list with nodes containing data and a reference to the next node.

• For insertion, update the pointers of the nodes accordingly to maintain the sequence.

• For deletion, adjust the pointers to skip the node to be deleted.

• To reverse a linked list, iterate through...read more
Answered by AI
Add your answer