1500+ Mayank Propmart Interview Questions and Answers

Maximum distance that can be traveled using 3 wheels, each with a 5km limit and requiring 2 wheels to move forward.

• Using all 3 wheels, we can move forward a total of 10kms (5kms using 2 wheels at a time)

• After using the first 2 wheels to travel 5kms, we can switch to the remaining wheel and travel another 5kms

• Alternatively, we can use 2 wheels to travel 5kms, then switch to the remaining wheel and use another 2 wheels to travel another 5kms, for a total of 10kms

Logic for distributing cards among 4 boxes in a circular manner.

• Use modulo operator to distribute cards among boxes in a circular manner.

• If card number is divisible by 4, assign it to box 4.

• If card number is divisible by 3, assign it to box 3.

• If card number is divisible by 2, assign it to box 2.

• If card number is not divisible by any of the above, assign it to box 1.

I am comfortable with multiple coding languages including Java, Python, and C++.

• Proficient in Java, Python, and C++

• Experience with web development languages such as HTML, CSS, and JavaScript

• Familiarity with scripting languages like Bash and PowerShell

• Comfortable with SQL and NoSQL databases

• Knowledge of machine learning libraries like TensorFlow and Keras

Sorting algorithms are used to arrange data in a specific order. There are various types of sorting algorithms.

• Types of sorting algorithms include: bubble sort, selection sort, insertion sort, merge sort, quick sort, heap sort, counting sort, radix sort, and bucket sort.

• Bubble sort compares adjacent elements and swaps them if they are in the wrong order.

• Selection sort selects the smallest element and swaps it with the first element, then selects the second smallest and swaps ...read more

Questions related to SAP ABAP concepts and terminology.

• Data dictionary concept and table creation steps

• TMG maintenance

• One step and two step

• Search help and types of search help

• Lock objects

• Difference between structure and table

• Views and types of views

Enhancements are ways to modify SAP standard functionality. There are various types of enhancements and exits available.

• Enhancements are used to modify SAP standard functionality without changing the original code

• Types of enhancements include user exits, customer exits, BAdIs, enhancement spots, and enhancement frameworks

• Exits are identified by searching for function modules with names containing 'EXIT_' or 'SMOD_'

• Classic BAdIs are implemented using function modules, while ke...read more

Questions related to SAP ABAP scripting and smart forms.

• SAP Script and Smart Forms are used for creating and printing forms in SAP systems.

• SAP Script has client dependency while Smart Forms are client independent.

• SAP Script uses function modules like OPEN_FORM, WRITE_FORM, and CLOSE_FORM.

• Smart Forms use function modules like SMARTFORM_FILL_OUT, SMARTFORM_GET_SMARTFORMS_LIST, and SMARTFORM_GET_PRINT_PDFS.

• SAP Script has fewer features compared to Smart Forms.

• SAP Script has wind...read more

Answers to questions asked in a Graduate Engineer Trainee interview

• OOPs concepts include encapsulation, inheritance, polymorphism, and abstraction

• Inheritance is a mechanism where a new class is derived from an existing class

• C++ is an object-oriented programming language while C is a procedural programming language

• Code to print sum of prime numbers between 1 to 100: [code snippet]

• Primary key is a unique identifier for a record in a table while foreign key is a field in a table...read more

Explaining recent Terraform project, accessing storage account blob container from multiple subscriptions, Azure DevOps variable group and pipeline, and brief on Ansible role.

• Recently worked on Terraform project to provision Azure resources

• Defined variables in Terraform configuration for resource names and sizes

• Accessed storage account blob container from multiple subscriptions using shared access signature (SAS) tokens

• Current project infrastructure in Azure includes virtual ...read more

To create a calculator program, use a GUI framework and implement basic arithmetic operations.

• Choose a programming language and a GUI framework such as JavaFX or Tkinter.

• Implement the basic arithmetic operations such as addition, subtraction, multiplication, and division.

• Add functionality for decimal points, clear button, and negative numbers.

• Test the program thoroughly to ensure accuracy and usability.

Questions related to SAP Abap reports and debugging

• Events in classical reports are start-of-selection, end-of-selection, and top-of-page. In interactive reports, events are at-line-selection, at-user-command, and top-of-page.

• AT PF status is used to define the status of the screen, while user command is used to define the actions that can be performed on the screen.

• The function module used in a report depends on the requirement. For example, if we need to convert a date from o...read more

Interview questions for Software Engineer position

• Array is a collection of elements of the same data type, while LinkedList is a collection of nodes that contain data and a reference to the next node

• Binary search is a search algorithm that divides the search interval in half at every step, reducing the search space by half

• Code complexity refers to the level of difficulty in understanding and maintaining a piece of code

• Deadlock is a situation where two or more processes are un...read more

To eliminate repeated array from a given string

• Convert the string to an array using split() method

• Use Set object to remove duplicates from the array

• Convert the array back to string using join() method

Defects found in production should be immediately reported and a plan should be made to fix the issue.

• Report the defect to the development team and stakeholders

• Analyze the impact of the defect on the system and users

• Prioritize the defect based on severity and impact

• Create a plan to fix the defect and test the fix thoroughly

• Deploy the fix to production after testing

• Monitor the system to ensure the defect has been resolved

Services in Angular are singleton objects that provide functionality to components. They can be called using dependency injection.

• Services are used to share data and functionality across multiple components

• They can be created using the 'ng generate service' command

• Services can be injected into components using the constructor

• To call a service API, use Angular's HttpClient module

• Data can be bound to components using property binding or two-way binding

Program to print a pattern of stars in a pyramid shape

• Use nested loops to print the pattern

• The outer loop controls the number of rows

• The inner loop controls the number of stars in each row

Questions related to Power BI

• Calculate function is used to create new columns based on a formula while filter function is used to filter data based on a condition.

• Pivot table is used to summarize and aggregate data while unpivot table is used to transform data from wide to long format.

• Optimization techniques include reducing data model size, using calculated columns instead of measures, and minimizing data refresh frequency.

• Types of gateways include personal, on-premises, and...read more

Incremental load is performed by identifying new data and adding it to the existing data set.

• Identify new data based on a timestamp or unique identifier

• Extract new data from source system

• Transform and map new data to match existing data set

• Load new data into target system

• Verify data integrity and consistency

Answers to various technical questions related to automation testing and software development.

• findElements vs findElement: findElements returns a list of web elements matching the locator, while findElement returns the first web element matching the locator.

• Set vs Map: Set is a collection of unique elements, while Map is a collection of key-value pairs.

• Program for occurrences of characters: Write a program to count the occurrences of each character in a given string.

• Program f...read more

Interview questions on software engineering concepts and projects

• Discussed my background and experience

• Explained my projects and their significance

• Defined sorting and provided insertion sort code

• Explained searching and provided binary and linear search code

• Discussed OOP concepts such as polymorphism and encapsulation

Answers to Power BI related questions.

• sum function adds up the values in a column, while sumx function adds up the result of an expression evaluated for each row in a table

• X Velocity is a feature in Power BI that allows for faster data processing and analysis

• Types of filters in Power BI include visual level filters, page level filters, and report level filters

• Types of connection mode in Power BI include Import, DirectQuery, and Live Connection

Regression is testing to ensure changes do not affect existing functionality. Retesting is testing to ensure defects have been fixed.

• Regression testing is done to ensure that changes made to the software do not affect the existing functionality.

• Retesting is done to ensure that defects found during testing have been fixed.

• Regression testing is done after every change to the software.

• Retesting is done after a defect has been fixed.

• Regression testing is automated to save time an...read more

Concurrent hashmap allows multiple threads to access and modify the map concurrently without causing data inconsistency.

• Concurrent hashmap is thread-safe and allows multiple threads to access and modify the map concurrently.

• It uses a technique called lock striping to divide the map into segments and apply locks to each segment instead of the entire map.

• This allows multiple threads to access different segments of the map concurrently without causing data inconsistency.

• Concurre...read more

Microservice architecture is a design approach where an application is composed of small, independent services that communicate over well-defined APIs.

• Break down the application into smaller, loosely coupled services that can be developed, deployed, and scaled independently.

• Each service focuses on a specific business capability and communicates with other services through APIs.

• Spring Boot provides a convenient framework for building microservices by offering features like emb...read more

The interview questions cover topics like introducing oneself, predicting program output, writing programs, Selenium components, Cucumber, and API encryption.

• Introduce yourself confidently, highlighting relevant experience and skills.

• To predict the output of a program that throws DivideByZeroException, understand how the exception is handled in the code.

• Write a program to find factorial using loops or recursion.

• To reverse the words in a string, split the string into words, re...read more

Order by sorts the result set while group by groups the result set based on a column

• Order by is used to sort the result set in ascending or descending order

• Group by is used to group the result set based on a column

• Order by can be used with multiple columns while group by can only be used with one column

• Order by is used after the select statement while group by is used before the select statement

Module pool programming events, process before output and process after input, default screen number.

• Events in module pool include initialization, start-of-selection, end-of-selection, and others.

• Process before output is used to modify screen elements before they are displayed, while process after input is used to validate user input.

• The default screen number is 1000.

I worked on a project that involved sentiment analysis of customer reviews using Naive Bayes algorithm.

• The project involved collecting customer reviews from various sources.

• Preprocessing the data by removing stop words, stemming, and tokenizing.

• Used Naive Bayes algorithm for sentiment analysis.

• The algorithm was chosen because of its simplicity and effectiveness in text classification tasks.

• The accuracy of the model was evaluated using cross-validation techniques.

Yes, changing infrastructure in AWS management console will change statefile.

• Any changes made in the AWS management console will be reflected in the statefile.

• The statefile is a record of the current state of the infrastructure.

• For example, if you add a new EC2 instance in the management console, it will be reflected in the statefile.

Spring Boot can be used to expose Rest APIs easily.

• Create a Spring Boot project with necessary dependencies.

• Define the API endpoints using @RestController and @RequestMapping annotations.

• Implement the API logic in methods annotated with @GetMapping, @PostMapping, etc.

• Use @RequestBody and @PathVariable annotations to handle request data.

• Configure the API using application.properties or application.yml file.

• Test the API using tools like Postman or Swagger UI.

Steps to create, reprocess and debug an IDoc in SAP ABAP.

• To create an IDoc, define the message type, basic type, and segment structure in WE31.

• Create a function module to populate the IDoc data and trigger the IDoc creation using WE19.

• To reprocess an IDoc, use transaction BD87 and select the IDoc to be reprocessed.

• Check the error message and correct the issue before reprocessing the IDoc.

• To debug an IDoc, set a breakpoint in the function module used to create the IDoc.

• Use tra...read more

Python data structures are containers that hold data in an organized manner, each with its own advantages and differences.

• Python lists are versatile and can hold different data types.

• Tuples are immutable and can be used as keys in dictionaries.

• Sets are unordered and eliminate duplicate elements.

• Dictionaries store data in key-value pairs for efficient retrieval.

Code for addition and multiplication of matrix in C programming.

• Use nested loops to iterate through each element of the matrix

• For addition, add corresponding elements of both matrices and store in a new matrix

• For multiplication, use dot product of rows and columns to calculate each element of the new matrix

I am comfortable with Java programming language.

• Proficient in object-oriented programming concepts

• Experience in developing web applications using Spring framework

• Familiarity with Java libraries and tools such as Hibernate and Maven

Annotations are used in Java while decorators are used in Python.

• Annotations are used to provide metadata to the code and can be accessed at runtime.

• Decorators are used to modify the behavior of a function or class.

• Annotations are declared using the @ symbol in Java while decorators use the @ symbol in Python.

• Annotations are part of the language syntax in Java while decorators are implemented using functions in Python.

To open command prompt in Windows, press Win+R and type 'cmd' or search for 'Command Prompt' in Start menu.

• Press Win+R and type 'cmd'

• Search for 'Command Prompt' in Start menu

• Right-click on Start menu and select 'Command Prompt'

• Use Windows PowerShell instead of Command Prompt

Questions related to Azure DevOps Engineer role

• Terraform workspaces are used to manage multiple environments with the same codebase

• Null resource in Terraform is used to execute arbitrary code that doesn't create any resources

• Git fetch downloads changes from the remote repository but doesn't merge them with the local branch

• Load balancer in Azure distributes incoming traffic across multiple virtual machines

• Application gateway in Azure is a web traffic load balancer that can als...read more

Yes, we can write int func() and int func(int a) in a single class.

• We can overload the function with different parameters.

• The function with no parameter is called default constructor.

• Example: class MyClass { int func(); int func(int a); };

• Both functions can have different implementations.

Functional interface is an interface with only one abstract method, can be implemented using lambda expressions.

• Functional interface has only one abstract method

• Can be implemented using lambda expressions

• Used in Java to achieve functional programming

Request filter for API requests is a mechanism to intercept and process incoming requests before they reach the intended endpoint.

• Request filters can be implemented using frameworks like Spring Security in Java.

• They can be configured to support different forms of authentication such as basic authentication, OAuth, JWT, etc.

• Authentication mechanisms can be specified in the filter configuration to validate incoming requests before processing.

Answering a question about willingness to allocate and providing a program to pass data through a function.

• Yes, I am willing to allocate.

• To pass data through a function, we can define the function with parameters that will receive the data and then call the function with the data as arguments.

• For example, if we have a function that adds two numbers, we can pass the numbers as arguments when calling the function.

• function addNumbers(num1, num2) { return num1 + num2; }

• var result...read more

To copy data of all GDG versions into a single PS file using JCL.

• Use IDCAMS utility to define a temporary GDG base.

• Use SORT utility to merge all the GDG versions into a single file.

• Use IEBGENER utility to copy the merged file to a PS file.

• Delete the temporary GDG base using IDCAMS utility.

A circular cake can be cut into 8 equal pieces with 3 cuts only by cutting the cake into quarters and then making a diagonal cut.

• Cut the cake into quarters with two cuts, creating four equal pieces.

• Make a diagonal cut from the center of the cake to the edge, dividing each quarter into two equal pieces.

• This will result in eight equal pieces of cake with only three cuts.

To configure and verify custom DNS in Azure AD, follow these steps:

• Create a DNS zone in Azure DNS

• Add a custom domain to Azure AD

• Create a CNAME record in the DNS zone that points to the Azure AD domain

• Verify the custom domain in Azure AD

• Update the DNS registrar to use the Azure DNS name servers

• Test the custom DNS by accessing Azure AD resources using the custom domain

Regression testing is performed to ensure that changes or updates to a software application do not introduce new defects or impact existing functionality.

• Regression testing is done after making changes to the software application.

• It helps in identifying any unintended side effects of the changes.

• It ensures that previously working features are not broken due to the changes.

• Regression testing is typically performed during the testing phase of the software development lifecycle....read more

I have gained knowledge and skills in ID related issues through self-learning and practical experience.

• I have a strong passion for technology and have actively pursued learning about ID related issues outside of my degree.

• I have taken online courses, attended workshops, and participated in hands-on projects to enhance my knowledge in this area.

• I have also sought guidance from experienced professionals and engaged in self-study to stay updated with the latest developments.

• I ha...read more

Client mode is better for very less latency due to direct communication with the cluster.

• Client mode allows direct communication with the cluster, reducing latency.

• Standalone mode requires an additional layer of communication, increasing latency.

• Client mode is preferred for real-time applications where low latency is crucial.

A linked list is a linear data structure where each element is a separate object with a pointer to the next element.

• Consists of nodes that contain data and a pointer to the next node

• Can be singly or doubly linked

• Used for dynamic memory allocation, implementing stacks and queues, and more

Fact table contains quantitative data while dimension table contains descriptive data.

• Fact table stores data related to business processes and events

• Dimension table stores descriptive information about the data in the fact table

• Fact table is usually larger than dimension table

• Fact table is connected to dimension table through foreign keys

• Example: Sales fact table and product dimension table

A join is a SQL operation that combines rows from two or more tables based on a related column between them.

• Types of joins include inner join, left join, right join, and full outer join.

• Inner join returns only the matching rows from both tables.

• Left join returns all rows from the left table and matching rows from the right table.

• Right join returns all rows from the right table and matching rows from the left table.

• Full outer join returns all rows from both tables, with NULL v...read more

When a spark job is submitted, various steps are executed at the backend to process the job.

• The job is submitted to the Spark driver program.

• The driver program communicates with the cluster manager to request resources.

• The cluster manager allocates resources (CPU, memory) to the job.

• The driver program creates DAG (Directed Acyclic Graph) of the job stages and tasks.

• Tasks are then scheduled and executed on worker nodes in the cluster.

• Intermediate results are stored in memory o...read more

Fibonacci series is a sequence of numbers where each number is the sum of the two preceding ones.

• The first two numbers of the series are always 0 and 1

• The next number is the sum of the previous two numbers

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

• Pseudo code: 1. Initialize variables a=0, b=1, c=0 2. Print a and b 3. Repeat steps 4-6 until desired number of terms 4. c=a+b 5. Print c 6. a=b, b=c

Using Java streams to print odd numbers between 1 to 10 and greater than 5

• Use IntStream.range() to generate numbers from 1 to 10

• Filter the numbers using filter() to get odd numbers

• Use filter() again to get numbers greater than 5

• Print the numbers using forEach()

There are two types of subscriptions in Power BI Report Server.

• The two types of subscriptions are Power BI Report Server Standard and Power BI Report Server Enterprise.

• The Standard subscription allows for a single server deployment, while the Enterprise subscription allows for a distributed deployment.

• The Enterprise subscription also includes additional features such as high availability and disaster recovery.

• Both subscriptions require a license for each user accessing the re...read more

Program to print unique elements in an array in Java

• Create a HashSet to store unique elements

• Iterate through the array and add each element to the HashSet

• Print the HashSet to get the unique elements

Yes, I can remove all the pcs from the lab and keep them in another lab right now.

• Ensure all the necessary equipment and tools are available for the move

• Coordinate with the lab staff to ensure a smooth transition

• Label and document each PC for easy identification and setup in the new lab

• Ensure proper packaging and handling to prevent any damage during the move

Hibernate framework provides ORM capabilities, simplifies database access, and improves performance.

• Hibernate reduces boilerplate code by providing ORM capabilities.

• It simplifies database access by abstracting away the underlying SQL.

• Hibernate improves performance by caching data and reducing database round trips.

• It supports lazy loading, which improves performance by loading data only when needed.

• Hibernate supports multiple database vendors and provides transaction managemen...read more

Answering questions related to VMware, BSOD, troubleshooting, and patching tools.

• VMware is a virtualization software that allows multiple operating systems to run on a single physical machine.

• Standard switch is a virtual switch that connects virtual machines to the physical network, while DV switch is a distributed virtual switch that allows for centralized management of network configurations.

• BSOD stands for Blue Screen of Death, which is an error screen displayed on Windows...read more

Performance optimization in Spark involves tuning configurations, optimizing code, and utilizing caching.

• Tune Spark configurations such as executor memory, number of executors, and shuffle partitions.

• Optimize code by reducing unnecessary shuffles, using efficient transformations, and avoiding unnecessary data movements.

• Utilize caching to store intermediate results in memory and avoid recomputation.

• Example: In my project, I optimized Spark performance by increasing executor me...read more

Code to reverse a string and search an element.

• To reverse a string, use a loop to iterate through the string and append each character to a new string in reverse order.

• To search for an element in a string, use the indexOf() method or a loop to iterate through the string and check each character.

• Example: function reverseAndSearch(str, elem) { let reversed = ''; for(let i = str.length - 1; i >= 0; i--) { reversed += str[i]; } return reversed.indexOf(elem) !== -1; }

An array stores one type of element in sequential memory blocks for faster access.

• Arrays are useful for storing and accessing data in a specific order.

• They can be used to store numbers, characters, or other data types.

• Arrays can be multidimensional, allowing for more complex data structures.

• Accessing elements in an array is done using an index, starting at 0.

• Arrays can be resized dynamically in some programming languages.

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

• Abstraction helps in reducing complexity and increasing efficiency.

• It allows us to focus on the essential features of an object or system.

• For example, a car can be abstracted as a vehicle with certain properties like speed, fuel efficiency, and seating capacity.

• Abstraction can be achieved through interfaces, abstract classes, and encapsulation.

Conditional property in Spring beans allows for conditional bean creation based on specified conditions.

• Conditional property is used to conditionally create beans based on certain conditions.

• It is configured using @Conditional annotation on the bean definition class.

• Examples include @ConditionalOnProperty, @ConditionalOnClass, @ConditionalOnMissingBean, etc.

Pagination in REST API responses can be enabled by using query parameters like 'page' and 'limit'.

• Use query parameters like 'page' and 'limit' to specify the page number and number of items per page.

• Implement logic in the backend to fetch and return the appropriate subset of data based on the page and limit values.

• Include metadata in the response to indicate total number of items and current page number.

• Example: /api/users?page=2&limit=10 will return the second page of 10 use...read more

Implementing JUnit test for a REST API

• Create a test class for the REST API endpoints

• Use @RunWith(SpringRunner.class) and @SpringBootTest annotations

• MockMvc to perform HTTP requests and validate responses

• Use @Autowired to inject dependencies for testing

• Assert statements to verify expected results

Answers to questions related to automation testing using Selenium

• Overloading is when a method has the same name but different parameters in the same class, while overriding is when a subclass provides its own implementation of a method already defined in its superclass

• Locators in Selenium are used to identify web elements on a web page

• The syntax of xpath locator is //tagname[@attribute='value']

• Methods to write test cases include boundary value analysis, equivalence partitioni...read more

Software testing methodologies are techniques used to test software for quality and functionality.

• There are several types of testing methodologies such as black box testing, white box testing, and gray box testing.

• Black box testing focuses on testing the functionality of the software without knowledge of its internal workings.

• White box testing involves testing the internal workings of the software, including code and algorithms.

• Gray box testing is a combination of black and w...read more

Custom middleware are functions that have access to the request and response objects in an Express application's request-response cycle.

• Custom middleware can be used to perform tasks such as logging, authentication, error handling, etc.

• Middleware functions can be added to the request handling chain using the 'use' method in Express.

• An example of custom middleware implementation is adding a function to log request details before passing it to the route handler.

Device Manager can be opened in Windows using multiple methods.

• Press Windows key + X and select Device Manager

• Open Run dialog box (Windows key + R) and type devmgmt.msc

• Search for Device Manager in Windows search bar

• Right-click on This PC/My Computer and select Manage, then select Device Manager from the left pane