Mindinventory Interview Questions and Answers

Q1. Diff b/w CTE and SubQuery
Ans. 
CTE is a temporary result set that can be referenced within a query, while a subquery is a query nested within another query.
• CTE stands for Common Table Expression and is defined using the WITH keyword.

• CTEs can be referenced multiple times within a query.

• Subqueries are enclosed in parentheses and can only be referenced once in a query.

• Subqueries can be correlated or non-correlated.

• CTEs are generally used for readabilit...read more
Answered by AI
Add your answer
Q2. What is middleware in mvc core
Ans. 
Middleware in MVC Core is software components that are used to handle requests and responses in the application pipeline.
• Middleware components are added to the application pipeline in the Startup class using the UseMiddleware method.

• Each middleware component in the pipeline can inspect, modify, or short-circuit the request pipeline.

• Middleware components can perform tasks such as authentication, logging, error handling,...read more
Answered by AI
Add your answer

Q1. Android Question with Past projects
Add your answer

Q1. Behavior questions and Some Project based Questions
Add your answer

BInary Tree implementation

Q1. High level design and architecture of project
Ans. 
The high level design and architecture of a project involves outlining the overall structure and components of the software system.
• Identify the main modules or components of the system

• Define the interactions between these modules

• Specify the data flow and communication protocols

• Consider scalability, performance, and security requirements

• Choose appropriate design patterns and technologies
Answered by AI
Add your answer
Q2. Design database schema for particular scenario.
Ans. 
Design a database schema for a particular scenario.
• Identify entities and their relationships

• Create tables for each entity

• Define primary and foreign keys

• Normalize the database to reduce redundancy

• Consider indexing for performance optimization
Answered by AI
Add your answer
Q3. What is Cascadiing
Ans. 
Cascading is a data processing framework for building complex data processing workflows on Apache Hadoop.
• Cascading allows developers to easily create and manage data pipelines using Java or other JVM languages.

• It provides a higher-level abstraction for working with Hadoop MapReduce, making it easier to write and maintain data processing jobs.

• Cascading supports complex data transformations, joins, aggregations, and more...read more
Answered by AI
Add your answer

Q1. What is 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 a problem

• It involves concepts like classes, objects, inheritance, polymorphism, and encapsulation

• Example: Inheritance allows a class to inherit properties and behavior from another class
Answered by AI
Add your answer
Q2. What is the difference between abstract class and interface?
Ans. 
Abstract class can have both abstract and non-abstract methods, while interface can only have abstract methods.
• Abstract class can have constructor, fields, and methods, while interface cannot have any implementation.

• A class can extend only one abstract class, but can implement multiple interfaces.

• Abstract class is used to provide a common base for multiple classes, while interface is used to define a contract for class...read more
Answered by AI
Add your answer

20 questions were there and enough time was given. Questions were easy to medium

Q1. Basics of programming were asked. You will be asked to make logic for the given problem.
Add your answer
Q2. Star pattern, Fibonacci series, swap two numbers without third variable
Add your answer

Q1. They simply check your communication skills and behaviour
Add your answer