
Birlasoft


100+ Birlasoft Interview Questions and Answers
Cursors declared in procedures are local to the procedure, while those declared in package specifications can be accessed by multiple procedures within the package.
Cursors declared in procedures are only visible within that specific procedure.
Cursors declared in package specifications can be shared and accessed by multiple procedures within the package.
Package-level cursors can be useful for reusing the same query logic across multiple procedures.
Q2. Write a program given String s="rao2022"; Integer int=22,Add two numbers and print result on output A)String s1=s.replaceall("[a-z]",""); Int a=Integer.parseint(s1); Int result=a+b; System.out.println(result);
A program to add two numbers and print the result given a string and an integer
Extract the integer from the string using regex
Parse the extracted integer and add it to the given integer
Print the result on the output
Q3. According to you, which is the most difficult part of Project Management? Stakeholder Management and Communication Management are really difficult. Any Project Manager would sure check his Scope, Cost, and Sche...
read moreThe different bean scopes available in Spring are singleton, prototype, request, session, and application.
Singleton scope: Default scope, only one instance per Spring container
Prototype scope: New instance created each time bean is requested
Request scope: Bean is created once per HTTP request
Session scope: Bean is created once per HTTP session
Application scope: Bean is created once per ServletContext
Triggers are automatically executed in response to certain events, while stored procedures are pre-written scripts that can be manually executed.
Triggers are event-driven and automatically executed when a specified event occurs in the database.
Stored procedures are pre-written scripts that can be manually executed by users or applications.
Triggers can be used to enforce data integrity rules or audit changes in the database.
Stored procedures can be used to encapsulate complex ...read more
A trigger in a database management system is a set of instructions that automatically execute in response to certain events on a table or view.
Triggers are used to enforce business rules, perform data validation, and maintain data integrity.
They can be set to execute before or after INSERT, UPDATE, or DELETE operations on a table.
Examples of triggers include auditing changes to a table, updating related tables when a record is modified, or enforcing referential integrity.
Clustered index physically reorders the data in the table while non-clustered index does not.
Clustered index determines the physical order of data in the table, while non-clustered index does not.
A table can have only one clustered index, but multiple non-clustered indexes.
Clustered index is faster for retrieval but slower for insert and update operations, while non-clustered index is the opposite.
Example: Primary key in a table is usually implemented as a clustered index, wh...read more
JavaScript design patterns are reusable solutions to common problems in software design.
Some common design patterns in JavaScript include Module, Singleton, Observer, Factory, and Prototype.
Module pattern helps in creating encapsulated modules with private and public methods.
Singleton pattern ensures a class has only one instance and provides a global point of access to it.
Observer pattern allows objects to subscribe and unsubscribe to events and be notified of changes.
Factor...read more
The Spring Bean Factory Container manages the life cycle of beans in Spring applications.
Beans are created and initialized in the Spring context
Beans can be configured to have different scopes like singleton, prototype, etc.
Beans can have initialization and destruction callbacks defined
Beans can be wired together using dependency injection
SSRS is a server-based reporting platform that allows users to create, manage, and deliver reports.
SSRS allows users to create interactive, tabular, graphical, or free-form reports from various data sources.
Reports can be published to a centralized report server for easy access by users.
Users can schedule report generation and delivery, as well as subscribe to reports for automated distribution.
SSRS supports a wide range of data sources including SQL Server, Oracle, ODBC, OLE...read more
Merge transformation combines two datasets into one, while Merge-Join transformation combines two datasets based on a common key.
Merge transformation combines rows from two datasets into a single dataset without any condition.
Merge-Join transformation combines rows from two datasets based on a common key or condition.
Merge transformation is used for combining unrelated datasets, while Merge-Join is used for joining related datasets.
Example: Merge transformation can be used to...read more
Q12. How many years of experience in Linux System Administrator?
I have 5 years of experience as a Linux System Administrator.
5 years of experience in managing Linux servers and systems
Proficient in troubleshooting, maintenance, and security of Linux systems
Experience with shell scripting, automation, and monitoring tools
Certifications like RHCSA or LPIC demonstrate expertise
Worked with distributions like CentOS, Ubuntu, and Red Hat
A state in React is a JavaScript object that stores data relevant to a component and can be updated over time.
State is initialized in a component's constructor using this.state = {}
State can be updated using this.setState() method
State changes trigger re-rendering of the component
ROWID is a unique identifier for a row in a table, while ROWNUM is a pseudo-column that assigns a unique number to each row retrieved from a query.
ROWID is a physical address of a row in a table, while ROWNUM is a virtual column generated by a query result set.
ROWID remains constant for a row even if the row is updated, while ROWNUM changes based on the order of rows retrieved from a query.
ROWID is unique within a table, while ROWNUM is unique within a result set.
Junk dimension contains non-additive, unrelated attributes. Degenerate dimension is a dimension key without its own dimension table.
Junk dimension combines several low-cardinality attributes into a single dimension table.
Degenerate dimension is a dimension key stored in fact table, not having its own dimension table.
Example of junk dimension: combining flags like 'is_active', 'is_deleted' into a single table.
Example of degenerate dimension: order number in a sales fact table.
Types of facts in data warehousing include additive, semi-additive, and non-additive facts.
Additive facts: can be summed up across all dimensions. Example: sales amount.
Semi-additive facts: can be summed up across some dimensions but not all. Example: inventory levels.
Non-additive facts: cannot be summed up across any dimension. Example: average temperature.
Slice is a method that extracts a portion of an array without modifying the original array, while splice is a method that adds or removes elements from an array.
Slice returns a shallow copy of a portion of an array based on start and end index parameters.
Splice can add new elements to an array or remove existing elements by specifying the start index and number of elements to remove.
Example: const arr = [1, 2, 3, 4, 5]; arr.slice(1, 3) will return [2, 3], while arr.splice(1, ...read more
Conditional split transaction in SSIS is used to route data based on specified conditions.
Conditional split is a control flow component in SSIS.
It evaluates a specified condition for each row of data and routes the rows to different outputs based on the result.
Example: Route all orders with quantity greater than 100 to one output and all others to a different output.
In Java, 'throw' is used to throw an exception explicitly, while 'throws' is used in method signature to declare the exceptions that the method can throw.
throw is used to throw an exception explicitly within a method
throws is used in method signature to declare the exceptions that the method can throw
throw is followed by an exception object, while throws is followed by exception class names separated by commas
Example: throw new Exception();
Example: public void method() throws...read more
Q20. What is agile? How you trained your team for agile development? What action item came out of sprint retro and how you handled? What techniques you follow in estimation? Who are stake holders of PI planning?
Agile is a project management methodology focused on iterative development and collaboration.
Agile is a project management methodology that emphasizes iterative development, collaboration, and flexibility.
Trained team for agile development by conducting workshops, providing resources, and coaching on agile principles and practices.
Action items from sprint retrospectives are discussed with the team, prioritized, and assigned to team members for implementation.
Estimation techni...read more
Prototype chain in JavaScript is the mechanism by which objects inherit properties and methods from other objects.
In JavaScript, each object has a private property which holds a link to another object called its prototype.
If a property or method is not found on an object, JavaScript will look for it in the object's prototype, and so on up the chain.
This allows for inheritance in JavaScript, where objects can inherit properties and methods from their prototypes.
React context is a built-in feature for passing data through the component tree, while React Redux is a library for managing global state in React applications.
React context is used for passing data down the component tree without having to pass props manually at every level.
React Redux is a library that provides a centralized store for managing global state in a React application.
React context is built into React, while React Redux is a separate library that needs to be inst...read more
SQL join queries are used to combine rows from two or more tables based on a related column between them.
Different types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
INNER JOIN returns rows when there is at least one match in both tables.
LEFT JOIN returns all rows from the left table and the matched rows from the right table.
RIGHT JOIN returns all rows from the right table and the matched rows from the left table.
FULL JOIN returns rows when there is a mat...read more
JRE is for running Java applications, while JDK is for developing and running Java applications.
JRE stands for Java Runtime Environment and is used for running Java applications.
JDK stands for Java Development Kit and is used for developing and running Java applications.
JDK includes JRE, as well as development tools such as compiler and debugger.
JRE does not include development tools, only the necessary components to run Java applications.
The layers of the IoT protocol stack include application, transport, network, link, and physical layers.
Application layer: Handles data exchange between devices and applications. Examples include MQTT, CoAP.
Transport layer: Ensures data delivery between devices. Examples include TCP, UDP.
Network layer: Manages device addressing and routing. Examples include IPv4, IPv6.
Link layer: Handles communication between directly connected devices. Examples include Ethernet, Wi-Fi.
Physic...read more
Q26. Rate yourself out of 5 in Core Java and Spring.
I would rate myself 4 out of 5 in Core Java and 3 out of 5 in Spring.
Strong understanding of object-oriented programming concepts in Core Java.
Experience in developing Java applications using frameworks like Spring MVC and Spring Boot.
Proficient in using Spring features like dependency injection, AOP, and MVC architecture.
Familiarity with Spring Data JPA for database operations.
Knowledge of Spring Security for implementing authentication and authorization.
Experience in writin...read more
The 'this' keyword in Java refers to the current instance of a class.
Used to refer to the current object within a method or constructor.
Can be used to differentiate between instance variables and local variables with the same name.
Can be passed as an argument to other methods or constructors.
Example: this.variableName = value;
Q28. What is the difference between regression vs Impact testing
Regression testing checks if changes in code affect existing functionality, while impact testing checks the effect of changes on related components.
Regression testing ensures that changes in code do not affect existing functionality
Impact testing checks the effect of changes on related components
Regression testing is focused on testing the same functionality repeatedly
Impact testing is focused on testing the impact of changes on other components
Regression testing is usually a...read more
Q29. What new features are introduced in Apex latest version.
Apex latest version introduces new features like Lightning Web Components, Apex Recipes, and improved debugging capabilities.
Lightning Web Components allow developers to build reusable components using modern web standards like JavaScript and HTML.
Apex Recipes provide pre-built code snippets for common use cases, making development faster and easier.
Improved debugging capabilities include enhanced error messages and better tools for troubleshooting code issues.
Q30. 1. Difference between overloading and Overriding 2. Explain POM and it's Advantage 3. Is Java pure object oriented programming language? 4. can we override constructor? 5. have you used overriding and overloadi...
read moreAnswers to common interview questions for Selenium Automation Tester position
Overloading is when a class has multiple methods with the same name but different parameters, while overriding is when a subclass provides a specific implementation for a method that is already defined in its superclass.
POM (Page Object Model) is a design pattern in Selenium automation testing where web pages are represented as classes, and the web elements on the page are defined as variables within...read more
Event Emitter is a class in Node.js that allows objects to emit and listen for events.
Event Emitter is a core module in Node.js that provides an implementation of the observer pattern.
It allows multiple functions to be attached to a single event, which can be triggered synchronously or asynchronously.
Example: const EventEmitter = require('events');
Example: const myEmitter = new EventEmitter();
Example: myEmitter.on('event', () => { console.log('an event occurred!'); });
Example...read more
Q32. What is Well Architected Framework? how to use in Migration?
Well Architected Framework is a set of best practices for designing and improving cloud architectures.
It consists of five pillars: Operational Excellence, Security, Reliability, Performance Efficiency, and Cost Optimization.
It provides a consistent approach for customers and partners to evaluate architectures and implement designs that will scale over time.
In migration, the Well Architected Framework can be used to assess the current architecture, identify areas for improveme...read more
Q33. What is regression testing A) Checking the application whether there is any impact on existing application due to add/delete of feature is called regression testing.
Regression testing is the process of testing changes made to an application to ensure that existing functionality still works as expected.
It involves re-executing test cases that have been previously run to ensure that changes made to the application have not introduced new bugs or broken existing functionality.
Regression testing is typically performed after a new feature or bug fix has been implemented.
It can be done manually or through automated testing tools.
Examples of re...read more
Q34. Explain any critical P1 kind issue ? How did you fix it and root cause?
Resolved critical P1 issue related to server downtime
Identified root cause as a hardware failure in the server
Coordinated with IT team to replace faulty hardware and restore server functionality
Implemented measures to prevent similar issues in the future, such as regular hardware maintenance checks
Communicated updates and progress to stakeholders to ensure transparency and minimize impact on business operations
Q35. What are the different Cluster Managers available in Spark ?
Apache Spark supports several cluster managers including YARN, Mesos, and Standalone.
YARN is the default cluster manager for Spark and is used for Hadoop-based clusters.
Mesos is a general-purpose cluster manager that can be used with Spark, Hadoop, and other frameworks.
Standalone is a simple cluster manager that comes bundled with Spark and is suitable for testing and development purposes.
Node.js is a runtime environment that allows JavaScript code to run on the server side.
Node.js uses an event-driven, non-blocking I/O model, making it lightweight and efficient.
It uses the V8 JavaScript engine from Google Chrome to execute code.
Node.js allows developers to use JavaScript for both client-side and server-side development.
It has a large ecosystem of libraries and frameworks, such as Express.js for building web applications.
Node.js can be used to build scalable n...read more
Q37. If user os is crash how to identify deta is lost or not
To identify if data is lost after a user OS crash, check for backups and recovery options.
Check for backups of the data on external drives or cloud storage
Use recovery software to attempt to retrieve lost data
If no backups or recovery options are available, data may be lost
Q38. As a consultant, how will you resolve if user is unable to do Shipment?
I would troubleshoot the issue by identifying the root cause and providing alternative solutions to ensure the shipment is completed successfully.
Communicate with the user to understand the specific issue they are facing
Check the system for any technical errors or glitches that may be preventing the shipment
Offer alternative shipment methods or solutions, such as using a different carrier or delivery service
Provide step-by-step guidance to the user on how to troubleshoot the ...read more
Q39. What is the difference between RDBMS and DBMS?
RDBMS is a type of DBMS that stores data in a structured manner using tables with relationships.
DBMS is a general term for any software that manages data, while RDBMS is a specific type of DBMS.
RDBMS stores data in tables with predefined relationships between them.
RDBMS enforces ACID properties (Atomicity, Consistency, Isolation, Durability) to ensure data integrity.
Examples of RDBMS include MySQL, Oracle, and SQL Server.
Examples of non-RDBMS DBMS include MongoDB and Cassandr...read more
Q40. How to handle performance issue in Oracle Apex.
Performance issues in Oracle Apex can be handled by optimizing SQL queries, reducing network latency, and caching data.
Optimize SQL queries by using indexes, reducing unnecessary joins, and avoiding full table scans.
Reduce network latency by minimizing the number of round trips between the client and server.
Cache data to reduce the need for repeated database queries and improve response times.
Closures are functions that have access to variables from their containing scope even after the function has finished executing.
Closures allow functions to access variables from their outer scope
They maintain a reference to the variables even after the outer function has finished executing
Closures are commonly used in event handlers and callbacks
Q42. How u have implemented weblogic in your project.
I have implemented WebLogic in my project by configuring and deploying applications on the WebLogic server.
Configured WebLogic server by setting up domains, servers, and clusters
Deployed applications on WebLogic server using deployment descriptors
Managed application resources and services through WebLogic Console or WLST scripts
Configured connection pools, data sources, and JMS resources
Implemented security measures like SSL, authentication, and authorization
Monitored server ...read more
Q43. In SSIS, difference between merge and union all transformation
Merge combines two sorted datasets into one, while Union All combines two datasets without sorting.
Merge Transformation requires sorted input datasets, while Union All does not.
Merge Transformation combines two datasets into one based on a common key column.
Union All Transformation simply appends two datasets together.
Merge Transformation can remove duplicates, while Union All cannot.
Merge Transformation can have up to four inputs, while Union All can only have two.
Q44. How immutability achieved by classes other than String
Immutability can be achieved by classes through using final keyword, returning new instances in methods, and using defensive copying.
Use final keyword to make class variables immutable
Return new instances in methods instead of modifying existing ones
Use defensive copying to prevent modification of internal state
Q45. Difference between Server side condition, client side condition
Server side condition is evaluated on the server before the page is sent to the client, while client side condition is evaluated on the client side after the page is received.
Server side condition is processed on the server before the page is rendered to the client
Client side condition is processed on the client's browser after the page is received
Server side conditions are typically used for security and data validation
Client side conditions are often used for user interface...read more
A PL/SQL cursor is a pointer used to fetch and manipulate data in a database table.
PL/SQL cursor is used to retrieve data row by row from a result set.
It allows for processing individual rows returned by a query.
Cursors are typically used in loops to iterate through query results.
Example: DECLARE cursor_name CURSOR FOR SELECT * FROM table_name;
Q47. SAP Testing steps and what are the systems do you use?
SAP testing involves various steps including planning, preparation, execution, and reporting. Different systems are used for testing such as SAP Solution Manager, HP Quality Center, and JIRA.
Planning the testing approach and identifying test scenarios
Preparing test data and test scripts
Executing tests and recording results
Reporting defects and retesting fixes
Systems used for testing include SAP Solution Manager, HP Quality Center, and JIRA
Q48. List all the Annotation used in your project Explain difference between @component and @bean
Annotations used in project: @Component, @Bean. Difference: @Component is a generic stereotype for any Spring-managed component, while @Bean is used to explicitly declare a Spring bean.
Annotations used in project: @Component, @Bean
@Component is a generic stereotype for any Spring-managed component
@Bean is used to explicitly declare a Spring bean
Q49. What is Warehouse Inspection vs Quality Inspection?
Warehouse inspection focuses on the overall condition and organization of a warehouse, while quality inspection focuses on the specific quality of products or materials.
Warehouse inspection involves checking for safety hazards, proper storage practices, and organization of inventory.
Quality inspection involves examining products or materials for defects, consistency, and adherence to quality standards.
Warehouse inspection may include checking for proper labeling, cleanliness,...read more
Q50. Life Cycle of Spring Bean, difference between java versions, difference between throw and throws, exception, abstraction, polymorphism and so on.
Questions related to Spring Bean, Java versions, exception handling, and OOP concepts.
Spring Bean goes through various stages in its lifecycle such as instantiation, initialization, and destruction.
Java versions have differences in terms of features, performance, and security. For example, Java 8 introduced lambda expressions and streams.
throw is used to throw an exception explicitly while throws is used to declare the exceptions that a method may throw.
Exception handling is ...read more
Q51. What is Authorization and Authentication.
Authentication verifies the identity of a user, while authorization determines what actions they are allowed to perform.
Authentication confirms the identity of a user through credentials like passwords or biometrics.
Authorization determines the level of access a user has to resources or actions.
Examples: Logging into a system with a username and password is authentication. Being able to view/edit specific files based on user roles is authorization.
Q52. What are the features of the Apache Spark ?
Apache Spark is a fast and general-purpose cluster computing system.
Distributed computing engine
In-memory processing
Supports multiple languages
Machine learning and graph processing libraries
Real-time stream processing
Fault-tolerant
Scalable
Q53. How is Spark different from Map reduce ?
Spark is faster than MapReduce due to in-memory processing and DAG execution model.
Spark uses in-memory processing while MapReduce uses disk-based processing.
Spark has DAG (Directed Acyclic Graph) execution model while MapReduce has Map and Reduce phases.
Spark supports real-time processing while MapReduce is batch-oriented.
Spark has a higher level of abstraction and supports multiple languages while MapReduce is limited to Java.
Spark has built-in libraries for SQL, streaming,...read more
Q54. What is the difference between RDD and coalesce ?
RDD is a distributed collection of data while coalesce is a method to reduce the number of partitions in an RDD.
RDD is immutable while coalesce creates a new RDD with fewer partitions
RDD is used for parallel processing while coalesce is used for reducing the number of partitions
RDD can be created from Hadoop InputFormats while coalesce is a method of RDD
Example: rdd.coalesce(1) merges all partitions into a single partition
Q55. What is the difference between Abstraction and Encapsulation
Abstraction is hiding unnecessary details while Encapsulation is hiding implementation details.
Abstraction focuses on the outside view of an object while Encapsulation focuses on the inside view of an object.
Abstraction is achieved through abstract classes and interfaces while Encapsulation is achieved through access modifiers like private, public, protected.
Abstraction is used to reduce complexity and increase efficiency while Encapsulation is used to protect the data from u...read more
Q56. What is difference between index and subscript and how do you define them?
Index is the position of an element in an array, while subscript is the variable used to access elements in an array.
Index is a fixed value that represents the position of an element in an array.
Subscript is a variable used to access elements in an array by specifying the position.
Example: In an array arr[5], 5 is the index, while arr[i] uses the subscript i to access elements.
Q57. Write a program to remove duplicate in drop-down
Program to remove duplicates in a drop-down
Create a list to store unique values
Loop through the drop-down options
Check if the option is already in the list
If not, add it to the list
Update the drop-down options with the unique values
Q58. what is migration strategy in Migration?
Migration strategy in Migration involves planning and executing the movement of data, applications, and infrastructure from one environment to another.
Assess current environment and identify dependencies
Define target environment and establish migration plan
Test migration process and validate data integrity
Execute migration with minimal downtime
Monitor and optimize performance post-migration
Q59. How delivery execution will be done considering the customer satisfaction in mind
Customer satisfaction is a top priority in delivery execution.
Regular communication with the customer to understand their needs and expectations.
Establishing clear project goals and timelines.
Ensuring quality control measures are in place.
Providing timely updates and addressing any concerns or issues promptly.
Conducting post-project reviews to gather feedback and identify areas for improvement.
Q60. What will done for team upskilling and creating reusable components out of an project assignment
Team upskilling and creating reusable components will be achieved through training, knowledge sharing, and documentation.
Identify skill gaps and provide relevant training sessions
Encourage knowledge sharing through regular team meetings and presentations
Document best practices and reusable components for future reference
Create a knowledge repository for easy access to information
Encourage team members to take ownership of their learning and development
Provide opportunities fo...read more
Q61. What are immutable classes other tham String
Immutable classes other than String
Integer
Double
Boolean
LocalDate
Q62. What is React ,Why it is used in modern days apps
React is a JavaScript library for building user interfaces, known for its efficiency and flexibility.
React allows for the creation of reusable UI components, making development faster and more efficient.
It uses a virtual DOM to improve performance by only updating the necessary parts of the UI.
React is popular for single-page applications and dynamic web interfaces.
It is widely used in modern web development due to its declarative and component-based approach.
React Native all...read more
Q63. What is CAF? what is the benefit?
CAF stands for Common Assessment Framework. It is a tool used to assess the needs of individuals and families to provide appropriate support and services.
CAF is a holistic assessment tool used in social care to identify the strengths and needs of individuals and families.
It helps professionals to work together to provide coordinated support and services.
The benefits of CAF include early intervention, improved outcomes for individuals and families, and better coordination of s...read more
Q64. What is difference between missleware and filter?
Missileware is a type of software used in missile systems, while a filter is a program that screens data.
Missileware is designed to control and guide missiles, while filters are used to sort and block data.
Missileware is typically used in military applications, while filters are used in various industries such as email and internet security.
Examples of missileware include guidance systems for missiles, while examples of filters include spam filters and content filters.
Q65. What is react and how it works how it is all about, hooks and redux
React is a JavaScript library for building user interfaces.
React allows developers to create reusable UI components.
It uses a virtual DOM to efficiently update the UI.
React Hooks provide a way to use state and other React features in functional components.
Redux is a state management library that can be used with React to manage application state.
Q66. What is conditional split transformation
Conditional Split Transformation is a data flow transformation in SSIS that routes data based on specified conditions.
It is used in SSIS to split data based on conditions
It has one input and multiple outputs
Each output has a condition that determines whether the data is sent to that output
It can be used to filter data, route data to different destinations, or perform different transformations on data based on conditions
Q67. Which framework works best in Agile adoption scenario?
There is no one-size-fits-all framework for Agile adoption, as it depends on the organization's specific needs and context.
Different frameworks like Scrum, Kanban, SAFe, and LeSS can work well depending on the organization's size, industry, and culture.
Scrum is popular for its simplicity and focus on iterative development, while Kanban is more flexible and suitable for continuous delivery.
SAFe (Scaled Agile Framework) is often used in larger organizations to scale Agile pract...read more
Q68. What makes you drive the value for customer and how do you achieve it
I drive value for customers by prioritizing their needs, providing timely solutions, and ensuring their satisfaction.
Understanding customer requirements and expectations
Communicating effectively and promptly
Taking ownership of issues and following through to resolution
Seeking feedback and continuously improving processes
Going above and beyond to exceed customer expectations
Middlewares are functions that have access to the request and response objects in Node.js, allowing for additional functionality to be added to the server.
Middlewares can be used to perform tasks like authentication, logging, error handling, etc.
They are executed in the order they are defined in the code.
Examples of middlewares include body-parser for parsing incoming request bodies, morgan for logging HTTP requests, and express-validator for validating request data.
Q70. What is kibana and any other monitor tool experience.
Kibana is a data visualization tool used to analyze and monitor logs and metrics.
Kibana is part of the Elastic Stack (ELK stack) and is used to visualize data stored in Elasticsearch.
It allows users to create interactive dashboards and visualizations to analyze log data and metrics.
Other monitor tools experience may include tools like Grafana, Prometheus, Nagios, etc.
Q71. What are RDD in Pyspark ?
RDD stands for Resilient Distributed Datasets in Pyspark, which are fault-tolerant collections of elements that can be processed in parallel.
RDDs are the fundamental data structure in Pyspark.
They are immutable and can be cached in memory for faster processing.
RDDs can be created from Hadoop Distributed File System (HDFS), local file system, or by transforming existing RDDs.
Examples of transformations include map, filter, and reduceByKey.
Actions like count, collect, and saveA...read more
Q72. How many types of facts?
There are two types of facts: objective and subjective.
Objective facts are based on measurable data and can be proven true or false.
Subjective facts are based on personal opinions and experiences.
Objective facts include the temperature outside, the weight of an object, and the time of day.
Subjective facts include whether a movie is good or bad, whether a painting is beautiful or ugly, and whether a food tastes good or bad.
Q73. How many types of Dimensions?
There are three types of dimensions: conformed, degenerate, and junk.
Conformed dimensions are shared across multiple fact tables.
Degenerate dimensions are attributes that do not have a dimension table.
Junk dimensions are a collection of flags and indicators that do not fit in any other dimension.
Q74. Explain Var and const with their respective scopes in javascript
Var and const are variable declarations in JavaScript with different scopes. Var has function scope while const has block scope.
Var has function scope, meaning it is accessible within the function it is declared in.
Const has block scope, meaning it is accessible only within the block it is declared in.
Var can be redeclared and reassigned, while const cannot be reassigned but can be mutated.
Var is hoisted to the top of its function scope, while const is not hoisted.
Q75. Find 2nd Highest number from an array
Find 2nd highest number from an array of strings
Convert array of strings to array of integers
Sort the array in descending order
Return the second element in the sorted array
Q76. Types of joins and examples in detail
Types of joins in SQL with examples
Inner Join: Returns rows when there is a match in both tables
Left Join: Returns all rows from the left table and the matched rows from the right table
Right Join: Returns all rows from the right table and the matched rows from the left table
Full Outer Join: Returns rows when there is a match in either table
Cross Join: Returns the Cartesian product of the two tables
Q77. what is JSX. What is virtual DOM
JSX is a syntax extension for JavaScript that allows writing HTML-like code in React. Virtual DOM is a lightweight copy of the actual DOM used for efficient updates.
JSX is a syntax extension for JavaScript used in React to write HTML-like code within JavaScript files
Virtual DOM is a lightweight copy of the actual DOM used by React to improve performance by minimizing actual DOM updates
JSX elements are transpiled into regular JavaScript function calls before being rendered to ...read more
Q78. What is long term objective?
To continuously enhance my skills and knowledge in technology, leadership, and business to become a trusted advisor for clients.
Continuous learning and development in technology trends and solutions
Building strong leadership and communication skills
Developing a deep understanding of business processes and strategies
Becoming a trusted advisor for clients by providing innovative and effective solutions
Q79. Which services are used in the cloud
Various services like compute, storage, networking, databases, analytics, AI/ML, IoT, and more are used in the cloud.
Compute services (e.g. AWS EC2, Azure Virtual Machines)
Storage services (e.g. AWS S3, Google Cloud Storage)
Networking services (e.g. AWS VPC, Azure Virtual Network)
Database services (e.g. AWS RDS, Azure SQL Database)
Analytics services (e.g. AWS Redshift, Google BigQuery)
AI/ML services (e.g. AWS SageMaker, Azure Machine Learning)
IoT services (e.g. AWS IoT, Azure...read more
Q80. what is DBMS and RDBMS ?
DBMS stands for Database Management System and RDBMS stands for Relational Database Management System.
DBMS is a software system that manages and organizes data in a database.
RDBMS is a type of DBMS that stores data in tables with relationships between them.
RDBMS uses SQL (Structured Query Language) to manipulate and retrieve data.
Examples of popular RDBMS include MySQL, Oracle, and Microsoft SQL Server.
Q81. Explain internal working of has map
HashMap is a data structure that stores key-value pairs and uses hashing to quickly retrieve values based on keys.
HashMap internally uses an array of linked lists to store key-value pairs.
When a key-value pair is added, the key is hashed to determine the index in the array where it will be stored.
If multiple keys hash to the same index, a linked list is used to handle collisions.
To retrieve a value, the key is hashed again to find the index and then the linked list is searche...read more
Q82. What is scope creep. How to handle it?
Scope creep refers to the uncontrolled expansion of project scope. It can be managed by setting clear project boundaries, conducting regular scope reviews, and implementing change control processes.
Scope creep occurs when there is an uncontrolled expansion of project scope beyond its original boundaries.
It often happens when new requirements or features are added without proper evaluation or approval.
To handle scope creep, it is important to establish clear project boundaries...read more
Q83. How to join domain steps
Joining a domain involves a few simple steps.
Ensure the computer is connected to the network
Open System Properties and click on 'Change'
Enter the domain name and provide credentials
Restart the computer for changes to take effect
Q84. what is diff between implicit and explicit wait
Implicit wait is set globally for all elements, while explicit wait is applied only to specific elements.
Implicit wait is set once at the beginning of the test script
Explicit wait is used for specific elements with different wait times
Implicit wait is defined for the entire duration of the WebDriver object
Explicit wait is defined for a specific condition or element to wait for
Q85. what are the different types of charts in tableau
Tableau offers a variety of chart types to visualize data effectively.
Bar chart - used to compare different categories
Line chart - shows trends over time
Pie chart - displays parts of a whole
Scatter plot - shows relationships between two variables
Heat map - visualizes data using color intensity
Tree map - displays hierarchical data using nested rectangles
Q86. What are Closer Function?
Closer functions are functions that have access to the parent scope even after the parent function has closed.
Closer functions are nested functions within another function.
They have access to variables and parameters of the parent function.
They can access variables even after the parent function has finished executing.
Q87. what is your project exp in SCM module
I have 5 years of project experience in implementing and optimizing SCM modules.
Implemented end-to-end supply chain solutions for a global manufacturing company
Optimized inventory management processes to reduce costs and improve efficiency
Led cross-functional teams in implementing new SCM software systems
Developed and implemented KPIs to measure supply chain performance
Q88. Explain SSRS Architecture
SSRS Architecture is a three-tier architecture consisting of a client, application server, and database server.
Client sends a request to the application server
Application server processes the request and retrieves data from the database server
Data is then sent back to the application server and rendered in the client
Report Server manages the report processing and rendering
Report Manager provides a web-based interface for managing reports
Q89. Internal implementation of Collections in java
Java Collections framework provides a set of interfaces and classes to store and manipulate groups of objects.
Collections framework includes interfaces like List, Set, and Map, along with classes like ArrayList, HashSet, and HashMap.
Internal implementation of collections varies based on the specific collection type.
For example, ArrayList uses an array to store elements, while LinkedList uses a doubly linked list.
HashMap uses a hash table to store key-value pairs efficiently.
Q90. find repeating numbers from array using stream api.
Using Java Stream API to find repeating numbers in an array of strings.
Convert array of strings to Stream
Use Collectors.groupingBy to group by each element
Filter the map by count > 1 to find repeating numbers
Q91. Shared experience on assets managers and Configuration
Experience in managing assets and configuration is crucial for successful asset management.
Experience in tracking and maintaining assets to ensure they are utilized efficiently
Knowledge of configuration management to standardize and control changes to assets
Ability to optimize asset performance and reduce downtime through effective management
Experience in implementing asset tracking systems and software for streamlined management
Examples: Implementing RFID technology for trac...read more
Q92. Ale configurations in SAP PI PO
ALE configurations in SAP PI PO
ALE (Application Link Enabling) is used for exchanging data between different SAP systems
ALE configurations in SAP PI/PO involve setting up logical systems, ports, partner profiles, and distribution models
ALE can be used for both inbound and outbound communication
ALE can be configured using transaction codes such as SALE, BD64, and WE20
Q93. machine learning concept explanation in detail
Machine learning is a subset of artificial intelligence that involves training algorithms to make predictions or decisions based on data.
Machine learning involves using algorithms to analyze and learn from data
It can be supervised, unsupervised, or semi-supervised
Examples include image recognition, natural language processing, and recommendation systems
Q94. Joins in sql and hive tables
Joins in SQL and Hive tables involve combining data from multiple tables based on a common column.
Use JOIN keyword to combine tables based on a common column
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id
Q95. Purchase sale of goods journal entry
Purchase sale of goods journal entry
When goods are purchased, the journal entry would be a debit to the inventory account and a credit to accounts payable or cash.
When goods are sold, the journal entry would be a debit to accounts receivable or cash and a credit to sales revenue.
If there are any discounts or returns, adjustments would need to be made to the journal entries.
The journal entries should be recorded in the general ledger and posted to the appropriate accounts.
Q96. How to solve a complex customer issue.
To solve a complex customer issue, gather all relevant information, analyze the problem, communicate effectively, collaborate with team members, and provide timely updates.
Gather all relevant information about the issue from the customer.
Analyze the problem thoroughly to understand the root cause.
Communicate effectively with the customer to manage expectations and gather additional details.
Collaborate with team members or other departments if necessary to find a solution.
Prov...read more
Q97. find duplicate element frequency in an array.
Find duplicate element frequency in an array of strings.
Create a HashMap to store each element and its frequency.
Iterate through the array and update the frequency in the HashMap.
Print out elements with frequency greater than 1.
Q98. What is Blockchain?
Blockchain is a decentralized, digital ledger that records transactions in a secure and transparent manner.
It is a distributed database that stores information across a network of computers.
Each block in the chain contains a cryptographic hash of the previous block, creating an unbreakable chain of data.
It is used in cryptocurrencies like Bitcoin and Ethereum, but also has potential applications in industries like finance, healthcare, and supply chain management.
Q99. Write a code to find duplicate from string
Code to find duplicates in a string array
Iterate through each string in the array
Use a hashmap to store each character and its count
Check if the character count is greater than 1 to find duplicates
Q100. Explain Java 8 features
Java 8 introduced several new features including lambda expressions, functional interfaces, streams, and default methods.
Lambda expressions allow you to write code in a more concise and readable way.
Functional interfaces are interfaces with a single abstract method, which can be implemented using lambda expressions.
Streams provide a way to work with collections of objects in a functional style.
Default methods allow interfaces to have method implementations.
Optional class help...read more
Interview Process at Birlasoft

Top Interview Questions from Similar Companies








Reviews
Interviews
Salaries
Users/Month

