Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Mydbops Team. If you also belong to the team, you can get access from here

Mydbops Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Mydbops Associate Software Engineer Interview Questions and Answers

Updated 12 Dec 2024

Mydbops Associate Software Engineer Interview Experiences

1 interview found

Associate Software Engineer Interview Questions & Answers

user image PRAGYA BHARTI SHARMA

posted on 6 Jul 2024

Interview experience
1
Bad
Difficulty level
Hard
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Why did you choose Python?

Interview Preparation Tips

Interview preparation tips for other job seekers - Do not join this company because no one appreciates your work, which can be demotivating. Additionally, there are no fixed working hours while working from home, and the company does not provide a site or office for work.

Interview questions from similar companies

I applied via Campus Placement and was interviewed before Jul 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. They asked me the Fibonacci series then all about gate subjects like computer network and operating system

Interview Preparation Tips

Interview preparation tips for other job seekers - Have a strong grip in programming and gate subjects..you will be selected for sure

I applied via Company Website and was interviewed before Jan 2020. There were 4 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. Introduce yourself?
  • Q2. Why did you choose to be a software engineer?
  • Q3. How do you find yourself fit for this role?
  • Q4. What do you know about us?

Interview Preparation Tips

Interview preparation tips for other job seekers - Put your sight into the interviewer's eyes and be calm . Just keep on talking It's your interview you are the king don't let yourself eaten up by the questions he/she shoots at you.its fine even if you answer them partially or not at all. But don't be mum.
Also try to make sense on whatever you are speaking.
Nothing's going to stop you from working for your passion.

I applied via Campus Placement and was interviewed before Oct 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Asked about b.tech project. Preferences about the places to work.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be pleasant and cool. Try to be genuine about the procedure.

I applied via Recruitment Consultant and was interviewed in May 2020. There were 4 interview rounds.

Interview Questionnaire 

12 Questions

  • Q1. Introduce yourself and share about your experiences and latest projects in detail
  • Q2. Architecture of mvc and how it works
  • Ans. 

    MVC is a software architecture pattern that separates an application into three interconnected components: Model, View, and Controller.

    • Model represents the data and business logic of the application

    • View is responsible for rendering the user interface

    • Controller handles user input and updates the model and view accordingly

    • MVC promotes separation of concerns and modularity

    • Examples of MVC frameworks include Ruby on Rails,

  • Answered by AI
  • Q3. Difference between wep api and wcf
  • Ans. 

    Web API is for building HTTP services while WCF is for building services that support multiple transport protocols.

    • Web API is lightweight and ideal for building RESTful services over HTTP.

    • WCF is a more heavy-duty framework that supports multiple transport protocols like HTTP, TCP, Named Pipes, etc.

    • Web API is more suited for building services that are consumed by web applications while WCF is more suited for building se...

  • Answered by AI
  • Q4. Session management in asp.net
  • Ans. 

    Session management in ASP.NET

    • ASP.NET provides in-built session management through HttpSessionState class

    • Session can be used to store user-specific data across multiple requests

    • Session can be configured to use different storage options like InProc, StateServer, SQLServer

    • Session can be accessed using HttpContext.Current.Session property

    • Session can be secured using SSL, cookieless sessions, and timeout settings

  • Answered by AI
  • Q5. What are Filters in mvc and its types
  • Ans. 

    Filters in MVC are used to intercept and modify HTTP requests and responses.

    • Filters are used to implement cross-cutting concerns like logging, caching, authentication, etc.

    • There are five types of filters in MVC: Authorization filters, Action filters, Result filters, Exception filters, and Resource filters.

    • Authorization filters are used to authenticate and authorize users before executing an action.

    • Action filters are us...

  • Answered by AI
  • Q6. What are authentication and authorization
  • Ans. 

    Authentication is verifying the identity of a user, while authorization is granting access to specific resources.

    • Authentication confirms the identity of a user through credentials such as username and password.

    • Authorization determines what resources a user can access based on their role or permissions.

    • Examples of authentication include logging into a website or entering a PIN at an ATM.

    • Examples of authorization include...

  • Answered by AI
  • Q7. What is benefit of using bootstrap
  • Ans. 

    Bootstrap is a popular front-end framework that provides a range of benefits for web development.

    • Bootstrap offers a responsive grid system that makes it easy to create mobile-friendly websites.

    • It includes pre-built CSS styles and JavaScript plugins that can save time and effort in development.

    • Bootstrap is well-documented and has a large community, making it easy to find support and resources.

    • It is constantly updated to...

  • Answered by AI
  • Q8. Disadvantages of ajax
  • Ans. 

    Ajax can cause security issues and affect SEO.

    • Ajax can make a website less accessible to users with slow internet connections.

    • It can also cause issues with browser history and back button functionality.

    • Ajax can make it difficult for search engines to crawl and index website content.

    • Cross-site scripting (XSS) attacks can be carried out through Ajax if proper security measures are not taken.

  • Answered by AI
  • Q9. Difference between function and stored procedures in sql
  • Ans. 

    Functions return a single value while stored procedures execute multiple SQL statements.

    • Functions can be used in SELECT, WHERE, and HAVING clauses.

    • Stored procedures can have input and output parameters.

    • Functions cannot modify the database while stored procedures can.

    • Functions are deterministic while stored procedures are not necessarily so.

    • Examples of functions: AVG, COUNT, MAX, MIN, SUM.

    • Examples of stored procedures:

  • Answered by AI
  • Q10. What are Aggregate functions available and explain them
  • Ans. 

    Aggregate functions perform calculations on a set of values and return a single value.

    • Common aggregate functions include COUNT, SUM, AVG, MIN, and MAX.

    • COUNT returns the number of rows in a table or the number of non-null values in a column.

    • SUM returns the sum of all values in a column.

    • AVG returns the average of all values in a column.

    • MIN returns the smallest value in a column.

    • MAX returns the largest value in a column.

  • Answered by AI
  • Q11. Benefits of cte and difference between temp table and table variables
  • Ans. 

    CTE benefits and difference between temp table and table variables

    • CTE (Common Table Expression) allows for recursive queries and simplifies complex queries

    • Temp tables are physical tables stored in tempdb and can be indexed and have constraints

    • Table variables are stored in memory and have limited scope and no statistics

    • Temp tables are better for large data sets and complex queries, while table variables are better for s

  • Answered by AI
  • Q12. What are Indexes and its types
  • Ans. 

    Indexes are data structures that improve the speed of data retrieval operations in a database.

    • Indexes are created on one or more columns of a table.

    • Types of indexes include clustered, non-clustered, unique, and full-text indexes.

    • Clustered indexes determine the physical order of data in a table, while non-clustered indexes create a separate structure to store the index data.

    • Unique indexes ensure that each value in the i...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Usually Interview in companies took half and hour to one hour in technical discussion answer what you know if we are not strong we can say that we are not strong. Stay confident with the answers. You can crack any interviews

Skills evaluated in this interview

I was interviewed before Nov 2020.

Round 1 - Coding Test 

(6 Questions)

Round duration - 360 minutes
Round difficulty - Medium

They give you 6 hr. For 6 question but the good part is that you need to complete atleast 1 question and you are good to go.
Round will be cleared only after attempting one question and rest of the questions are for improving your rank.

  • Q1. 

    Pair Sum Problem Statement

    You are given an integer array 'ARR' of size 'N' and an integer 'S'. Your task is to find and return a list of all pairs of elements where each sum of a pair equals 'S'.

    Note:
    ...
  • Ans. 

    Find pairs of elements in an array that sum up to a given value, sorted in a specific order.

    • Iterate through the array and for each element, check if the complement (S - current element) exists in a hash set.

    • If the complement exists, add the pair to the result list.

    • Sort the result list based on the criteria mentioned in the problem statement.

  • Answered by AI
  • Q2. 

    Minimum Number of Platforms Needed Problem Statement

    You are given the arrival and departure times of N trains at a railway station for a particular day. Your task is to determine the minimum number of pl...

  • Ans. 

    The task is to determine the minimum number of platforms needed at a railway station based on arrival and departure times of trains.

    • Sort the arrival and departure times in ascending order.

    • Use two pointers to keep track of overlapping schedules.

    • Increment platform count when a new train arrives before the previous one departs.

  • Answered by AI
  • Q3. 

    Minimise Sum Problem Statement

    You are given a matrix of 'N' rows and 'M' columns and a non-negative integer 'K'. Determine the minimum possible sum of all elements in each submatrix after performing at m...

  • Ans. 

    Given a matrix and a non-negative integer K, find the minimum possible sum of all elements in each submatrix after performing at most K decrements.

    • Iterate through all submatrices and find the minimum possible sum after performing decrements

    • Keep track of the number of decrements performed on each element

    • Use dynamic programming to optimize the solution

    • Ensure not to decrease any number below 0

    • Return the minimum possible s

  • Answered by AI
  • Q4. 

    Chocolate Distribution Problem

    You are given an array/list CHOCOLATES of size 'N', where each element represents the number of chocolates in a packet. Your task is to distribute these chocolates among 'M'...

  • Ans. 

    Distribute chocolates among students to minimize the difference between the largest and smallest number of chocolates.

    • Sort the array of chocolates packets.

    • Use sliding window technique to find the minimum difference between the largest and smallest packets distributed to students.

    • Consider edge cases like when number of students is equal to number of packets.

  • Answered by AI
  • Q5. 

    Prime Time Again Problem Statement

    You are given two integers DAY_HOURS and PARTS. Consider a day with DAY_HOURS hours, which can be divided into PARTS equal parts. Your task is to determine the total ins...

  • Ans. 

    Calculate total instances of equivalent prime groups in a day divided into equal parts.

    • Divide the day into equal parts and find prime numbers in each part.

    • Identify prime groups where prime numbers occur at the same position in different parts.

    • Count the total instances of equivalent prime groups.

    • Ensure each hour in a prime group is in a different part of the day.

  • Answered by AI
  • Q6. 

    Constellation Identification Problem

    Given a matrix named UNIVERSE with 3 rows and 'N' columns, filled with characters {#, *, .}, where:

    • '*' represents stars.
    • '.' represents empty space.
    • '#' repre...
  • Ans. 

    The task is to identify constellations shaped like vowels within a matrix filled with characters {#, *, .}.

    • Iterate through the matrix to find 3x3 constellations shaped like vowels.

    • Check for vowels 'A', 'E', 'I', 'O', 'U' in each 3x3 constellation.

    • Print the vowels found in each constellation for each test case.

  • Answered by AI
Round 2 - HR 

Round duration - 20 Minutes
Round difficulty - Easy

Interview Preparation Tips

Professional and academic backgroundI applied for the job as Associate Software Engineer in MumbaiEligibility criteriaAbove 7 cgpaTata Consultancy Services (TCS) interview preparation:Topics to prepare for the interview - Data Structures, Python, Operating System, Algorithms, DBMSTime required to prepare for the interview - 2 MonthsInterview preparation tips for other job seekers

Tip 1 : learn basics
Tip 2 : learn any oops language and practice.
Tip 3 : code as much as you can.

Application resume tips for other job seekers

Tip 1 : short and precise. Upto the point.
Tip 2 : keep few things aside from resume

Final outcome of the interviewSelected

Skills evaluated in this interview

I applied via Company Website and was interviewed before Feb 2021. There were 3 interview rounds.

Round 1 - Aptitude Test 

TNQT: TCS National Qualifier Test

Round 2 - Technical 

(1 Question)

  • Q1. All technical questions related to your project and basic understanding of any programming language. Basically questions from your resume will be asked.
Round 3 - HR 

(2 Questions)

  • Q1. Tell me about yourself.
  • Q2. What is your family background?

Interview Preparation Tips

Interview preparation tips for other job seekers - All the best, TCS is not tough to get into. But getting good project is a main cookie to be cracked.

Interview Questionnaire 

1 Question

  • Q1. I'll be mentioning each and everything in my experience itself

Interview Preparation Tips

Round: Test
Experience: The test was a really basic one. Also the cut off was decided depending upon the performance of those who have appeared for the exam. So a basic knowledge of maths, reasoning and verbal helped me get through the exam. Each section  had a specific time limit and cut off. I was able to complete each section within stipulated time and able to answer most of them correctly. My knowledge of aptitude I had through my coaching also helped me.
Tips: Keep your cool and don't get tensed. the questions are not above the tenth class standard even. You'll have a lot of time to think and answer every question. Don't take a risk of copying. You can surely crack the test. You'll know few questions before you enter the examination centre, as people who already appeared for the test have a habit of debating on these questions. I'm sure the paper is same for all the batches. So there isn't any reason to worry at all.
Duration: around 70 mins minute
Total Questions: 50

Round: HR Interview
Experience: My college is one of the biggest ones in Andhra Pradesh. To handle the entire bunch of comparatively better students in the state, they gave us a privilege of clearing only Test and Interview. We had no group discussion.  Coming to interview, mine was purely on HR. The questions were expected and are common HR questions for most of interviews. He asked me to tell me about myself. I told him everything. Then he had gone through my resume and asked me a few questions on my intern-ships, social activities and about the events in which I participated and organised. I explained him everything. Then he asked  me why software and then why Infosys. I answered these questions too. That's all about the questions. My panellist was a cool guy. He was laughing all through. So I could answer exactly on what I've prepared. In fact I was laughing through the entire process. It was like a small chat with a strange and new friend.
Tips: Be prepared on your resume. Every point counts. The panellists can easily guess which isn't your true achievement and can grill you on that. So be careful while preparing your resume and be prepared to answer any question related to your resume. There were people who had experience Technical round also. So having a knowledge of Basic C language will be helpful. Common HR questions are available on the internet. Most of the interview depends on how we attempt these questions. So be prepared on those questions and finally the most important thing is, don't get tensed, keep a smile on your face and let the words flow even if you feel they are wrong.

General Tips: This is a campus placement and the panellists are surely going to select most of you. A 7 day preparation is more than enough. Prepare well. Don't get tensed. Keep a smile on your face. Your confidence level matters the most for them. So don't regret for few mistakes in the interview process.
College Name: ANDHRA UNIVERSITY COLLEGE OF ENGINEERING
Motivation: This was an On campus drive in my college and I had to surely apply for this company as I had no core company visiting my campus. Many of my seniors are working in this campus and have told me that the training in Infosys is an ultimate one.
Funny Moments: I already knew many of the questions in verbal ability before I appeared for the exam from my friends. Also we could discuss and answer few questions in the test. The interviewer was a funny guy. The entire session was really funny and we had a debate on the company's owner for a while which was more funny

I was interviewed before Sep 2020.

Round 1 - Coding Test 

Round duration - 60 minutes
Round difficulty - Easy

It was an aptitude test with maths and English questions

Round 2 - Face to Face 

(1 Question)

Round duration - 60 minutes
Round difficulty - Easy

It was a face to face interview with one of the TCS employees

  • Q1. 

    Linked List Value Search Problem Statement

    Given a Singly Linked List of integers accessible via a head pointer, where each node contains a specific integer value. You are required to determine if a node ...

  • Ans. 

    Given a singly linked list of integers, determine if a specified value exists within the list.

    • Iterate through the linked list to check if the specified value exists.

    • Return 1 if the value is found, else return 0.

    • Handle multiple test cases by looping through each one separately.

  • Answered by AI
Round 3 - Face to Face 

(1 Question)

Round duration - 60 minutes
Round difficulty - Easy

It was more like an HR+Tech round

  • Q1. 

    Search an Element in a Sorted Array

    Given a sorted array 'A' of 'N' integers, determine whether a number 'X' exists within this array for a series of queries. For each query, print 1 if 'X' exists in the ...

  • Ans. 

    Search for a number in a sorted array and determine its existence for multiple queries.

    • Iterate through each query integer 'X' and perform binary search on the sorted array 'A' to check for its existence.

    • Output 1 if 'X' is found in 'A', otherwise output 0.

    • Ensure to handle multiple test cases as per the given constraints.

  • Answered by AI

Interview Preparation Tips

Professional and academic backgroundI applied for the job as Associate Software Engineer in ChennaiEligibility criteriaAbove 75% aggregateTata Consultancy Services (TCS) interview preparation:Topics to prepare for the interview - Went through GeekforGeeks, completed problems on Hackerank, Completed problems on Leetcode, completed quizzes available online, completed the problems mentioned in previous year interviewTime required to prepare for the interview - 2 monthsInterview preparation tips for other job seekers

Tip 1 : Don't stress too much, you can't finish all the problems
Tip 2 : Talk to the current members of that organization on Linkedin or any college alumni

Application resume tips for other job seekers

Tip 1 : Keep it one page
Tip 2 : Focus on your projects

Final outcome of the interviewSelected

Skills evaluated in this interview

Interview Preparation Tips

Round: Resume Shortlist
Experience: Resume actually does not effects much ...U should only give those dates that u could match up with ur resume as u will be tested for every thing u write in it
Tips: Make it up to the point ..let it be short and consice ..relevant to the appropriate details

College Name: GANDHI INSTITUTE OF ENGINEERING AND TECHNOLOGY

Mydbops Interview FAQs

How many rounds are there in Mydbops Associate Software Engineer interview?
Mydbops interview process usually has 1 rounds. The most common rounds in the Mydbops interview process are Technical.

Tell us how to improve this page.

Mydbops Associate Software Engineer Interview Process

based on 1 interview

Interview experience

1
  
Bad
View more
Database Engineer
12 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Database Engineer
9 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Database Admin
4 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Principal Software Engineer
4 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Mysql Database Administrator
4 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Mydbops with

Percona Monitoring and Management

1.0
Compare

Pythian

4.1
Compare

DBS Bank

3.8
Compare

TCS

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview