Minfy Technologies Senior Bdm Manager Interview Questions and Answers

Few questions that would involve problem solving. Basic 10th std math would suffice

Had few DSA questions.

Q1. Technical interview
Add your answer

Q1. About job, expection etc
Add your answer

Q1. Basic 10-15btheorotical question
Add your answer
Q2. Join + window funct question
Add your answer

Q1. Difference Between Union and Union All
Ans. 
Union combines and removes duplicates, Union All combines without removing duplicates
• Union combines result sets and removes duplicates

• Union All combines result sets without removing duplicates

• Union is slower than Union All as it involves removing duplicates

• Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

• Example: SELECT column1 FROM table1 UNION ALL SELECT column1 FROM table2;
Answered by AI
Add your answer
Q2. SQL Execution order
Add your answer
Q3. Coalesce function in SQL
Ans. 
Coalesce function in SQL is used to return the first non-null value in a list of expressions.
• Coalesce function takes multiple parameters and returns the first non-null value.

• It is commonly used to handle null values in SQL queries.

• Example: SELECT COALESCE(column_name, 'N/A') FROM table_name;
Answered by AI
Add your answer

Simple question on maths

Q1. Explain OOPS concept
Ans. 
OOPS (Object-Oriented Programming) is a programming paradigm based on the concept of objects, which can contain data and code.
• OOPS focuses on creating objects that interact with each other to solve complex problems

• Key principles include encapsulation, inheritance, polymorphism, and abstraction

• Encapsulation ensures that the internal state of an object is hidden from the outside world

• Inheritance allows a class to inherit...read more
Answered by AI
Add your answer
Q2. Coding array questions
Add your answer

Q1. Write a program to check if string is a anagram
Ans. 
Program to check if a string is an anagram
• Create a function that takes in two strings as input

• Remove all spaces and convert both strings to lowercase

• Sort both strings and compare if they are equal to determine if they are anagrams
Answered by AI
View 1 more answer
Q2. What is react lifecycle method
Ans. 
React lifecycle methods are special methods that are automatically called by React at specific points in a component's life cycle.
• React components have several lifecycle methods such as componentDidMount, componentDidUpdate, componentWillUnmount, etc.

• These methods allow developers to perform actions at specific points in a component's life cycle, such as fetching data, updating the UI, or cleaning up resources.

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

Create a web app to perform cred operation

Q1. SQL Based advanced question
Add your answer
Q2. Advanced SQL questions with Joins, Window Functions, etc
Add your answer

Q1. Basic questions on Sql
Add your answer
Q2. Few queries on CTE, JOINS, WINDOW functions
Add your answer

Q1. Similar as first row but some critical questions on sql
Add your answer

Q1. General questions about shifts and role
Add your answer

Questions based or percentage, profit loss, ratio

Q1. Explain about stacks
Ans. 
Stacks are a data structure that follows the Last In First Out (LIFO) principle.
• Elements are added and removed from the top of the stack

• Common operations include push (add element) and pop (remove element)

• Stacks can be implemented using arrays or linked lists

• Examples of stack usage include function call stack and undo/redo functionality in text editors
Answered by AI
Add your answer
Q2. To find middle number in the linked list
Ans. 
To find the middle number in a linked list.
• Traverse the linked list using two pointers, one moving twice as fast as the other.

• When the fast pointer reaches the end, the slow pointer will be at the middle node.

• If the linked list has even number of nodes, there will be two middle nodes. Return either one.
Answered by AI
Add your answer

Q1. Introduction , hobbies, goals
Add your answer
Q2. Strength, weakness, short term and long term goals
Add your answer