Upload Button Icon Add office photos
Engaged Employer

i

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

Mystifly Consulting Verified Tick

Compare button icon Compare button icon Compare
2.7

based on 84 Reviews

Filter interviews by

Mystifly Consulting Software Engineer Interview Questions, Process, and Tips

Updated 8 Aug 2022

Top Mystifly Consulting Software Engineer Interview Questions and Answers

  • Q1. On a dark night, 4 people want to cross a bridge and they have only one torch. At a time at max 2 people can cross the bridge. The time required for each individual to cr ...read more
  • Q2. 22. You are given two hourglasses, one of 11 minutes and the other of 7 minutes. How will you measure 4 minutes using it?
  • Q3. 3. Given a sorted array from 1 to n like 1,2,3 _ n there might be one number that is repeated so we return true if the array has a repeated number or return false if the ...read more
View all 40 questions

Mystifly Consulting Software Engineer Interview Experiences

2 interviews found

Round 1 - Technical 

(23 Questions)

  • Q1. 1. What is a linked list, its advantages and representation
  • Ans. 

    A linked list is a data structure that consists of a sequence of nodes, where each node contains a reference to the next node.

    • Advantages of linked list:

    • - Dynamic size: Linked lists can grow or shrink as needed.

    • - Efficient insertion and deletion: Adding or removing elements from a linked list is faster than an array.

    • - Flexibility: Linked lists can be easily modified and reorganized.

    • Representation of a linked list:

    • - Each...

  • Answered by AI
  • Q2. 2. Implement code of Fibonacci number using recursion
  • Ans. 

    Code for Fibonacci number using recursion

    • Define a function that takes an integer as input

    • If the input is 0 or 1, return the input

    • Else, return the sum of the function called with input-1 and input-2

    • Call the function with the desired input

  • Answered by AI
  • Q3. 3. Given a sorted array from 1 to n like 1,2,3 _ n there might be one number that is repeated so we return true if the array has a repeated number or return false if the array don't have a repeated number
  • Ans. 

    Check if a sorted array from 1 to n has a repeated number.

    • Iterate through the array and check if the current element is equal to the next element.

    • If yes, return true. If no, continue iterating.

    • If the loop completes without finding a repeated element, return false.

  • Answered by AI
  • Q4. 4. Given a string as an input, write a code to print the string in a manner such that a character that comes first in the string displays first with all occurrences in the string
  • Ans. 

    Print a string with all occurrences of the first character first.

    • Loop through the string and count the occurrences of the first character.

    • Print the first character that many times, then print the rest of the string.

  • Answered by AI
  • Q5. 5. Print Fibonacci Series.
  • Ans. 

    Print Fibonacci series using iterative or recursive approach.

    • Iterative approach: Use a loop to generate the series.

    • Recursive approach: Use a function to call itself to generate the series.

    • Start with 0 and 1, then add the previous two numbers to get the next number.

    • The series goes like this: 0, 1, 1, 2, 3, 5, 8, 13, 21, 34, 55, 89, 144, ...

    • The series can be generated up to a certain limit or until a certain number is re

  • Answered by AI
  • Q6. 6. Describe OOPS concepts
  • Ans. 

    OOPS concepts are the principles of Object-Oriented Programming that focus on encapsulation, inheritance, polymorphism, and abstraction.

    • Encapsulation: bundling of data and methods that operate on that data within a single unit

    • Inheritance: ability of a class to inherit properties and methods from a parent class

    • Polymorphism: ability of objects to take on many forms or have multiple behaviors

    • Abstraction: hiding of complex...

  • Answered by AI
  • Q7. 7. What are Pillars of OOPS?
  • Ans. 

    Pillars of OOPS are the fundamental principles of Object-Oriented Programming.

    • Abstraction: Hiding implementation details and showing only necessary information.

    • Encapsulation: Binding data and functions together to protect data from outside interference.

    • Inheritance: Acquiring properties and behavior of a parent class by a child class.

    • Polymorphism: Ability of objects to take multiple forms or have multiple behaviors.

  • Answered by AI
  • Q8. 8 Explain Why OOPS Important
  • Ans. 

    OOPS is important for code reusability, maintainability, and extensibility.

    • Encapsulation ensures data security and prevents unwanted access.

    • Inheritance allows for code reuse and reduces redundancy.

    • Polymorphism enables flexibility and extensibility of code.

    • Abstraction simplifies complex systems and hides implementation details.

    • OOPS promotes modular design and improves code maintainability.

    • OOPS facilitates team collabora...

  • Answered by AI
  • Q9. 9. What are classes and objects?
  • Ans. 

    Classes are templates for creating objects. Objects are instances of classes that have their own properties and methods.

    • Classes define the properties and methods that objects of that class will have

    • Objects are instances of classes that can be created and manipulated in code

    • Classes and objects are fundamental concepts in object-oriented programming

    • Example: A class 'Car' can have properties like 'make', 'model', 'year',

  • Answered by AI
  • Q10. 10. What is a Constructor
  • Ans. 

    A constructor is a special method that is used to initialize objects in a class.

    • Constructors have the same name as the class they are in

    • They are called automatically when an object is created

    • They can take parameters to set initial values for object properties

  • Answered by AI
  • Q11. 11. Abstraction Vs Interface - Similarity And Difference
  • Ans. 

    Abstraction and interface are both used to achieve abstraction in programming.

    • Abstraction is the process of hiding implementation details while showing only the necessary information to the user.

    • Interface is a blueprint for a class that defines a set of methods and properties that the class must implement.

    • Abstraction can be achieved through abstract classes and interfaces.

    • Abstraction is a concept while interface is a l...

  • Answered by AI
  • Q12. 12. What is abstraction? Explain abstract class and interface - the difference between them.
  • Ans. 

    Abstraction is a way of hiding implementation details and showing only necessary information to the user.

    • Abstract class is a class that cannot be instantiated and can have both abstract and non-abstract methods.

    • Interface is a collection of abstract methods and constants that can be implemented by any class.

    • Abstract classes can have constructors, while interfaces cannot.

    • A class can implement multiple interfaces, but can...

  • Answered by AI
  • Q13. 13. Types of inheritance
  • Ans. 

    Types of inheritance in software engineering

    • Single inheritance: a class inherits from only one parent class

    • Multiple inheritance: a class inherits from multiple parent classes

    • Multilevel inheritance: a class inherits from a derived class, which in turn inherits from another class

    • Hierarchical inheritance: multiple classes inherit from a single parent class

    • Hybrid inheritance: a combination of multiple and multilevel inheri

  • Answered by AI
  • Q14. 14. Difference between structure and class
  • Ans. 

    Structures are value types while classes are reference types.

    • Structures are allocated on stack while classes are allocated on heap.

    • Structures do not support inheritance while classes do.

    • Structures cannot have destructors while classes can.

    • Structures are used for small data structures while classes are used for larger, more complex objects.

    • Structures are passed by value while classes are passed by reference.

  • Answered by AI
  • Q15. 15. What is a constructor and a destructor and how to represent them?
  • Ans. 

    Constructor and destructor are special member functions in a class that are used to initialize and destroy objects respectively.

    • Constructor is called when an object is created and is used to initialize the object's data members.

    • Destructor is called when an object is destroyed and is used to free up any resources allocated by the object.

    • Constructor has the same name as the class and no return type, while destructor has ...

  • Answered by AI
  • Q16. 16. What is encapsulation?
  • Ans. 

    Encapsulation is the process of hiding implementation details and exposing only necessary information.

    • Encapsulation is achieved through access modifiers like public, private, and protected.

    • It helps in achieving data abstraction and information hiding.

    • It prevents unauthorized access to the internal state of an object.

    • Example: A class with private variables and public methods to access them.

  • Answered by AI
  • Q17. 17. How to add a new column to an existing table, what is the command for that?
  • Ans. 

    To add a new column to an existing table, use the ALTER TABLE command.

    • Use the ALTER TABLE command followed by the table name.

    • Use the ADD keyword followed by the new column name and its data type.

    • Example: ALTER TABLE table_name ADD column_name data_type;

    • Make sure to specify any additional constraints or default values for the new column.

  • Answered by AI
  • Q18. 18. Query -- return customers who joined the company in march?
  • Ans. 

    Query to return customers who joined the company in March.

    • Use the WHERE clause to filter the join date by month

    • Assuming the join date is stored in a 'join_date' column

    • Example: SELECT * FROM customers WHERE MONTH(join_date) = 3

  • Answered by AI
  • Q19. 19. Seven layers of OSI
  • Ans. 

    The OSI model is a conceptual model that characterizes and standardizes the communication functions of a telecommunication or computing system.

    • The seven layers are: Physical, Data Link, Network, Transport, Session, Presentation, and Application.

    • Each layer has a specific function and communicates with the layers above and below it.

    • The Physical layer deals with the physical transmission of data.

    • The Data Link layer provid...

  • Answered by AI
  • Q20. 20. Protocol used in the application layer
  • Ans. 

    The application layer uses various protocols such as HTTP, FTP, SMTP, etc.

    • HTTP (Hypertext Transfer Protocol) is used for web browsing

    • FTP (File Transfer Protocol) is used for file transfer

    • SMTP (Simple Mail Transfer Protocol) is used for email communication

    • POP3 (Post Office Protocol version 3) is used for retrieving emails

    • IMAP (Internet Message Access Protocol) is used for accessing emails on a server

    • DNS (Domain Name Sys...

  • Answered by AI
  • Q21. 21. Difference between TCP and UDP
  • Ans. 

    TCP is a connection-oriented protocol while UDP is connectionless.

    • TCP provides reliable, ordered, and error-checked delivery of data while UDP does not guarantee any of these.

    • TCP is slower but more reliable while UDP is faster but less reliable.

    • TCP is used for applications that require high reliability and accuracy while UDP is used for applications that require speed and efficiency.

    • Examples of TCP-based applications i...

  • Answered by AI
  • Q22. 22. You are given two hourglasses, one of 11 minutes and the other of 7 minutes. How will you measure 4 minutes using it?
  • Ans. 

    To measure 4 minutes using two hourglasses of 11 and 7 minutes, start both hourglasses simultaneously and flip the 7-minute hourglass when it runs out. When the 11-minute hourglass runs out, 4 minutes will have passed.

    • Start both hourglasses simultaneously

    • When the 7-minute hourglass runs out, flip it

    • When the 11-minute hourglass runs out, 4 minutes will have passed

  • Answered by AI
  • Q23. 23. Water Jug Puzzle: You are given 2 Jugs, one is 4 and the other of 7 Gallon and you need to measure x gallons of water.
Round 2 - Technical 

(18 Questions)

  • Q1. 1. Count Set Bit.......
  • Q2. 2. Program ATM Machine To Give Only 500 And 100 And Count There Number
  • Ans. 

    Program an ATM machine to dispense only 500 and 100 notes and count their number.

    • Create a function to dispense money

    • Use a loop to count the number of notes

    • Use if statements to check if the amount is divisible by 500 or 100

    • Display the total number of notes dispensed

  • Answered by AI
  • Q3. 3. Program to find the Binary Format of 4, 7
  • Ans. 

    Program to find binary format of 4 and 7.

    • Convert decimal numbers to binary using bitwise operator.

    • Print the binary format of the numbers.

    • Use printf or cout to display the output.

  • Answered by AI
  • Q4. 4. Print Fibonacci Series iteratively and recursively. You will be given 2 numbers and you will have to print all the Fibonacci digits between them.
  • Ans. 

    Print Fibonacci Series between two given numbers iteratively and recursively.

    • Iteratively, use a loop to generate Fibonacci numbers until the upper limit is reached.

    • Recursively, use a function to generate Fibonacci numbers until the upper limit is reached.

    • Store the generated Fibonacci numbers in an array and print them between the given numbers.

  • Answered by AI
  • Q5. 5. Palindrome Check.
  • Q6. 6. All Traversals of a tree.
  • Ans. 

    All possible ways to traverse a tree.

    • Pre-order traversal: root, left, right

    • In-order traversal: left, root, right

    • Post-order traversal: left, right, root

    • Level-order traversal: breadth-first search

    • Reverse level-order traversal: depth-first search

  • Answered by AI
  • Q7. 7. Finding Loop in Linked List
  • Ans. 

    To find a loop in a linked list, use Floyd's cycle-finding algorithm.

    • Floyd's algorithm uses two pointers, one moving at twice the speed of the other.

    • If there is a loop, the faster pointer will eventually catch up to the slower one.

    • To determine the start of the loop, reset one pointer to the beginning and move both at the same speed.

  • Answered by AI
  • Q8. 8. Height of a Tree.
  • Ans. 

    Height of a tree refers to the maximum number of edges from the root node to any leaf node in the tree.

    • Height of a tree can be calculated recursively by finding the height of left and right subtrees and adding 1 to the maximum of the two heights.

    • Height of a tree can also be calculated iteratively using level order traversal.

    • Height of a tree with only one node is 0.

    • Height of an empty tree is -1.

  • Answered by AI
  • Q9. 9. If you need to perform a lot of insertion and delete operations then which Data Structure will you use?
  • Ans. 

    I would use a Linked List data structure for frequent insertion and deletion operations.

    • Linked Lists have constant time complexity for insertion and deletion operations.

    • Arrays have a linear time complexity for these operations.

    • Doubly Linked Lists allow for efficient deletion of nodes.

    • Examples of use cases include implementing a queue or stack.

  • Answered by AI
  • Q10. 10. An array contains numbers from 1 to n. All the numbers occur twice in the array except any one element. Find the element which occurs only once.
  • Ans. 

    Find the element that occurs only once in an array of numbers from 1 to n with all other numbers occurring twice.

    • Use XOR operation to find the unique element.

    • Iterate through the array and XOR each element with the result.

    • The final result will be the unique element.

  • Answered by AI
  • Q11. 11. Define Abstraction, Inheritance, Runtime Polymorphism.
  • Ans. 

    Abstraction: hiding implementation details. Inheritance: creating new classes from existing ones. Polymorphism: same method, different behavior.

    • Abstraction: Focuses on what an object does instead of how it does it.

    • Inheritance: Allows a new class to be based on an existing class.

    • Runtime Polymorphism: Same method can be used for different objects, with different behavior.

    • Example: A car is an abstraction of a vehicle. Sed...

  • Answered by AI
  • Q12. 12. What Is DBMS?????
  • Ans. 

    DBMS stands for Database Management System. It is a software system that manages and organizes data in a database.

    • DBMS is used to create, modify, and delete databases and their objects.

    • It provides a way to store, retrieve, and manipulate data efficiently.

    • Examples of DBMS include MySQL, Oracle, SQL Server, and MongoDB.

  • Answered by AI
  • Q13. 13. SQL Queries?????????
  • Q14. 14. Primary Key vs. Unique Key?
  • Ans. 

    Primary key uniquely identifies a record in a table, while unique key ensures uniqueness of a column.

    • Primary key can't have null values, while unique key can have one null value.

    • A table can have only one primary key, but multiple unique keys.

    • Primary key is used as a foreign key in other tables, while unique key is not.

    • Example: Primary key - employee_id in employee table. Unique key - email in employee table.

  • Answered by AI
  • Q15. 15. Define Constraints???????
  • Ans. 

    Constraints are limitations or restrictions that are put on a system or process.

    • Constraints can be related to time, resources, budget, or technology.

    • They can be imposed by external factors such as regulations or internal factors such as company policies.

    • Examples of constraints in software development include limited memory or processing power, compatibility with existing systems, and security requirements.

  • Answered by AI
  • Q16. 16. What Are OS And OS Responsibly?
  • Ans. 

    OS stands for Operating System. It is responsible for managing computer hardware and software resources.

    • OS is the interface between the user and the computer hardware.

    • It manages memory, processes, and input/output devices.

    • Examples of OS include Windows, macOS, and Linux.

    • OS is responsible for providing security and managing user accounts.

    • It also provides a platform for running applications and software.

  • Answered by AI
  • Q17. 17. What is MultiThreading?
  • Ans. 

    Multithreading is the ability of a CPU to execute multiple threads concurrently.

    • Multithreading allows for better utilization of CPU resources.

    • It can improve application performance by allowing multiple tasks to run simultaneously.

    • Multithreading can also lead to synchronization issues and race conditions.

    • Examples of multithreaded applications include web servers, video games, and media players.

  • Answered by AI
  • Q18. 18. MultiThreading Vs MultiTasking?
  • Ans. 

    Multithreading is the ability of a CPU to run multiple threads concurrently, while multitasking is the ability of an OS to run multiple processes concurrently.

    • Multithreading is at the CPU level, while multitasking is at the OS level.

    • Multithreading allows multiple threads to share the same memory space, while multitasking requires separate memory spaces for each process.

    • Multithreading is used for improving performance a...

  • Answered by AI
Round 3 - Puzzles Interview 

(1 Question)

  • Q1. On a dark night, 4 people want to cross a bridge and they have only one torch. At a time at max 2 people can cross the bridge. The time required for each individual to cross the bridge is 1, 2, 5, and 10 m...
Round 4 - HR 

(5 Questions)

  • Q1. 1. Introduce and tell me something about yourself.
  • Ans. 

    I am a software engineer with 5 years of experience in developing web applications using Java and JavaScript.

    • I have a strong background in object-oriented programming and software development principles.

    • I am proficient in Java, JavaScript, and related frameworks such as Spring and React.

    • I have experience in designing and implementing RESTful APIs.

    • I am familiar with Agile methodologies and have worked in Scrum teams.

    • I h...

  • Answered by AI
  • Q2. 2. What are your strength and weakness?
  • Ans. 

    My strength is problem-solving and my weakness is perfectionism.

    • Strength: Strong problem-solving skills

    • Strength: Ability to work well in a team

    • Weakness: Perfectionism

    • Weakness: Difficulty in delegating tasks

  • Answered by AI
  • Q3. 3. What do you think mystify is doing?
  • Ans. 

    Mystify is likely a function or method that performs a complex or obscure operation.

    • Mystify could be encrypting or obfuscating data.

    • It might be performing a transformation or manipulation on data.

    • Mystify could be generating random or unpredictable outputs.

  • Answered by AI
  • Q4. 4. Why do you want to join our company?
  • Ans. 

    I want to join your company because of its reputation for innovation and the opportunity to work on cutting-edge projects.

    • Reputation for innovation

    • Opportunity to work on cutting-edge projects

  • Answered by AI
  • Q5. 5. Why should we hire you?
  • Ans. 

    You should hire me because I have a strong technical background, excellent problem-solving skills, and a passion for software development.

    • I have a Bachelor's degree in Computer Science and extensive experience in software development.

    • I have a deep understanding of various programming languages and frameworks, including Java, Python, and JavaScript.

    • I have a proven track record of delivering high-quality software solutio...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - JAVA or PYTHON is PREFERRED BY THEM. Also, OS DBMS may be asked to a few students so be ready for it.

Make sure you maintain a Structured flow while learning. Solve Striver 180 Questions, they are a great practice resource for DSA. Don't try and add something to your resume so that it looks fancier, it might cause trouble during the interview. Only add skills and topics if you have good knowledge about them.

Separately try and prepare for puzzles as well. During the interview, Keep Your Head Cool, also while explaining your approach to the interviewer, it would be great if you explain it with some examples, this will make it easier for him to understand your approach.

Skills evaluated in this interview

I applied via Job Portal and was interviewed before Aug 2021. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(2 Questions)

  • Q1. Explain Object-oriented Programming
  • Ans. 

    Object-oriented programming is a programming paradigm that uses objects to represent and manipulate data.

    • Encapsulation: bundling data and methods that operate on that data within one unit

    • Inheritance: creating new classes from existing ones

    • Polymorphism: ability of objects to take on many forms

    • Examples: Java, C++, Python, Ruby

  • Answered by AI
  • Q2. Explain your projects.

Interview Preparation Tips

Topics to prepare for Mystifly Consulting Software Engineer interview:
  • Java
  • OOPS
  • Resume
  • Data Structures
  • Algorithms
Interview preparation tips for other job seekers - Just go through the java basics, be confident and explain projects.

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement

Round 1 - Coding Test 

Basic DSA questions related to string and hashmap

Round 2 - One-on-one 

(2 Questions)

  • Q1. Return true if the sentence use all the vowels else false
  • Q2. When to use BFS, DFS and basic DSA questions?

I applied via campus placement at Motilal Nehru Institute National Institute of Technology (NIT), Allahabad and was interviewed in Jun 2022. There were 5 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Aptitude Test 

50 mcq were asked in 12 mins. Most of the candidates qualified this round.

Round 3 - Coding Test 

3 coding questions of basic DSA were asked. Also few mcqs from Operating System, Networking and DBMS.

Round 4 - Technical 

(3 Questions)

  • Q1. The technical round was of 40 mins. 3 standard questions from DSA were asked for which only approach was enough. Questions were from string, array and tree- Rotated string, Lowest common ancestor, etc.
  • Q2. Project related discussion regarding my role in the team.
  • Q3. A few HR questions related to family background. Why not go for higher studies like the rest of my family. Had to convince him that I saw more growth in working for an organisation.
Round 5 - HR 

(1 Question)

  • Q1. My introduction then, standard HR questions like where do i see myself in coming yrs, why do i want to join the company, etc. It lasted 10 mins

Interview Preparation Tips

Topics to prepare for Cogoport Software Engineer interview:
  • DSA
  • DBMS
  • OS
  • Networking
  • Project
Interview preparation tips for other job seekers - Try to present yourself in a confident and straightforward manner. Ask as many questions as possible at the end to convey your eagerness to join the company.

I applied via Company Website and was interviewed in Apr 2022. There were 6 interview rounds.

Round 1 - Aptitude Test 
Round 2 - Assignment 

Naaptol

Round 3 - Assignment 

Naaptol

Round 4 - Aptitude Test 

Naaptol

Round 5 - Case Study 

Study ing information

Round 6 - One-on-one 

(5 Questions)

  • Q1. Which place are you studying
  • Q2. Which subject are u interested
  • Q3. Which place are you born
  • Q4. Iam born in chamadala(v),jaladhanki (m)
  • Q5. Are you complete your graduation

Interview Preparation Tips

Interview preparation tips for other job seekers - Naaptol shopping information is very well..

I applied via campus placement at Indian Institute of Technology (IIT), Roorkee and was interviewed before Sep 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Linked List, Stack, BST

Interview Preparation Tips

Interview preparation tips for other job seekers - be ready with ds algo and have some side projects
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Jul 2023. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. It was 1 hr technical round for iOS Developer role. Questions related to project I am working, iOS Development questions like (process of publishing app, push notifications and its uses, Delegates how to u...
Round 2 - One-on-one 

(1 Question)

  • Q1. It was 30 min managerial round with one of the technical manager of MRI. Asked technical questions based on my projects. And then tricky questions like why you want to join, why we should hire you, where d...

Interview Preparation Tips

Interview preparation tips for other job seekers - Never lie in your resume.
Showcase your skills as much as you can in your resume.
You should have a very good knowledge about the project that your are working on in your current organisation.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Feb 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

45 mins, Basic aptitude , comprehension and decision making questions

Round 2 - Technical 

(1 Question)

  • Q1. Questions related to databases, DSA - medium, SQL Queries
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Youtube Video and was interviewed before Feb 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

There were many questions to be solved within an hour, but the expectation was to solve maximum you can.

Round 2 - Coding Test 

1 DSA based and 2 SQL coding questions with 5/6 DSA based MCQs

Round 3 - Technical 

(1 Question)

  • Q1. Write a python code to find missing element ranging from 0 to 100. Write a SQL query to fetch data from multiple tables. Questions based on types on Joins in SQL, Stored Procedures, Views and importance o...
  • Ans. 

    Python code to find missing element and SQL query for fetching data from multiple tables.

    • Python code to find missing element: Use set difference to find missing elements in range 0 to 100.

    • SQL query for fetching data from multiple tables: Use JOINs like INNER JOIN, LEFT JOIN, or CROSS JOIN to combine data from multiple tables.

    • Types of Joins in SQL: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN.

    • Stored Procedures: Precompi...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident with your concepts and share maximum knowledge you have.

Skills evaluated in this interview

Interview experience
2
Poor
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Oct 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Aptitude Test 

15 minutes test.
50 questions
easy questions
Management , Leadership , Character Type questions

Round 3 - Coding Test 

2 coding questions
resume grilling
easy medium questions

Round 4 - HR 

(2 Questions)

  • Q1. Time management questions
  • Q2. Toughest project you work upon

Mystifly Consulting Interview FAQs

How many rounds are there in Mystifly Consulting Software Engineer interview?
Mystifly Consulting interview process usually has 3 rounds. The most common rounds in the Mystifly Consulting interview process are Technical, Puzzles Interview and HR.
How to prepare for Mystifly Consulting Software Engineer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Mystifly Consulting. The most common topics and skills that interviewers at Mystifly Consulting expect are Java, Microservices, NoSQL, Rabbitmq and Scalability.
What are the top questions asked in Mystifly Consulting Software Engineer interview?

Some of the top questions asked at the Mystifly Consulting Software Engineer interview -

  1. On a dark night, 4 people want to cross a bridge and they have only one torch. ...read more
  2. 22. You are given two hourglasses, one of 11 minutes and the other of 7 minutes...read more
  3. 3. Given a sorted array from 1 to n like 1,2,3 _ n there might be one number th...read more

Tell us how to improve this page.

People are getting interviews through

based on 1 Mystifly Consulting interview
Job Portal
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
Mystifly Consulting Software Engineer Salary
based on 20 salaries
₹5.5 L/yr - ₹20 L/yr
57% more than the average Software Engineer Salary in India
View more details

Mystifly Consulting Software Engineer Reviews and Ratings

based on 6 reviews

2.0/5

Rating in categories

1.8

Skill development

2.0

Work-Life balance

1.8

Salary & Benefits

1.8

Job Security

2.5

Company culture

1.2

Promotions/Appraisal

3.0

Work Satisfaction

Explore 6 Reviews and Ratings
Senior Travel Consultant
59 salaries
unlock blur

₹3.5 L/yr - ₹7 L/yr

Travel Consultant
23 salaries
unlock blur

₹3 L/yr - ₹6 L/yr

Senior Accounts Executive
21 salaries
unlock blur

₹4.2 L/yr - ₹7.1 L/yr

Software Engineer
20 salaries
unlock blur

₹5.5 L/yr - ₹20 L/yr

Product Manager
15 salaries
unlock blur

₹26 L/yr - ₹41 L/yr

Explore more salaries
Compare Mystifly Consulting with

Amadeus

4.0
Compare

Travelport

4.4
Compare

Sabre

4.0
Compare

Cleartrip

3.4
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview