Epsilon Quality Engineer Interview Questions and Answers

Q1. What is Indexing in Mysql
Ans. 
Indexing in MySQL is a technique to improve the performance of database queries by creating a data structure that allows for faster data retrieval.
• Indexes are created on one or more columns of a table.

• They help in speeding up the search, sorting, and joining of data.

• Indexes can be created using different algorithms like B-tree, hash, or bitmap.

• Using indexes appropriately can significantly enhance query performance.

• Exam...read more
Answered by AI
Add your answer
Q2. Opps concepts in php
Ans. 
Object-oriented programming concepts in PHP
• Encapsulation: bundling data and methods together in a class

• Inheritance: creating new classes based on existing ones

• Polymorphism: using a single interface to represent different types

• Abstraction: hiding unnecessary details and exposing only essential features

• Class: blueprint for creating objects

• Object: instance of a class

• Method: function defined inside a class

• Property: variabl
Answered by AI
Add your answer

Q1. Talk about yourself
Add your answer
Q2. What is your professional experience
Add your answer

Simple SQL questions

Q1. What are the forms of media?
Ans. 
Forms of media include print, broadcast, digital, and social media.
• Print media: newspapers, magazines, brochures

• Broadcast media: television, radio

• Digital media: websites, blogs, online articles

• Social media: Facebook, Twitter, Instagram
Answered by AI
Add your answer
Q2. What is print media and digital media?
Ans. 
Print media refers to traditional forms of media such as newspapers and magazines, while digital media includes online platforms like websites and social media.
• Print media includes newspapers, magazines, brochures, and flyers

• Digital media includes websites, social media platforms, blogs, and online advertisements

• Print media is tangible and physical, while digital media is intangible and accessed electronically

• Print med...read more
Answered by AI
Add your answer

Round duration - 90 Minutes
Round difficulty - Hard

The test was at 6 pm with cam on and in fullscreen mode.

Q1. 
Interleaving Two Strings Problem Statement
You are given three strings 'A', 'B', and 'C'. Determine if 'C' is formed by interleaving 'A' and 'B'.
String 'C' is an interleaving of 'A' and 'B' if the lengt...read more
Ans. 
The problem involves determining if a string 'C' is formed by interleaving two given strings 'A' and 'B'.
• Check if the length of 'C' is equal to the sum of the lengths of 'A' and 'B'.

• Verify if all characters of 'A' and 'B' exist in 'C' while maintaining their order.

• Return 'True' if 'C' is an interleaving of 'A' and 'B', otherwise return 'False'.
Answered by AI
Add your answer
Q2. 
Construct Binary Tree from Inorder and Postorder Traversal
Given two lists representing the inorder and postorder traversal of a binary tree of integer type with 'N' nodes, construct the binary tree and r...read more
Ans. 
Construct a binary tree from inorder and postorder traversal lists and return its root.
• Create a map to store the indices of elements in the inorder traversal list for quick access during tree construction.

• Use the postorder list to determine the root of the tree and recursively build left and right subtrees.

• Construct the tree by recursively dividing the inorder list based on the root index in postorder list.

• Return the r...read more
Answered by AI
Add your answer

Round duration - 45 Minutes
Round difficulty - Easy

At 10:00 AM. Interviewer was very friendly and young but his cam was off.

Q1. 
Find Paths in Binary Tree
Kevin has sketched a series of integers, forming a diagram that represents a binary tree. Challenged by a friend, Kevin needs to find all paths from the root to the leaf where th...read more
Add your answer

Round duration - 45 Minutes
Round difficulty - Easy

It was held at 4 p.m. The interviewer was senior compared to the one in the previous round. Also, his cam was also on, but he wasn't speaking much and neither giving any expressions.

Q1. 
Boxes of Power Problem Statement
Given a set of boxes represented by an array gainPower, where each box has a certain power value, along with an initial power value 'power', your task is to maximize the t...read more
Ans. 
Maximize total score by selecting boxes optimally based on power values and operations.
• Iterate through the boxes and perform operations based on power values and current score

• Keep track of power, score, and selected boxes to maximize total score

• Example: For input [3, 50, [20, 30, 40]], select boxes with power 20 and 30 to get a score of 2
Answered by AI
Add your answer