10+ Sona Industries Interview Questions and Answers

To show duplicates in a database, use GROUP BY and HAVING clauses.

• Use GROUP BY to group the data by the column that may have duplicates.

• Use HAVING to filter the groups that have more than one row.

• Example: SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name HAVING COUNT(*) > 1;

Experienced front end developer with SQL skills. SQL query to list employees above age 23.

• Use SELECT statement to retrieve data from employees table

• Use WHERE clause to filter employees above age 23

• Example: SELECT * FROM employees WHERE age > 23;

Flows and flow actions are used in Pega to define the sequence of steps in a business process.

• Flows are visual representations of a business process that define the sequence of steps and actions required to complete a task.

• Flow actions are individual steps within a flow that represent a specific action or decision point.

• Flows and flow actions can be customized and configured to meet specific business needs.

• Examples of flow actions include creating a case, sending an email, or...read more

The APIs used in the projects include RESTful APIs, SOAP APIs, and custom APIs for data retrieval and integration.

• RESTful APIs were used for communication between client and server in a stateless manner.

• SOAP APIs were utilized for exchanging structured information in the form of XML messages.

• Custom APIs were developed for specific functionalities and integrations within the projects.

let is block scoped while var is function scoped in JavaScript.

• let is block scoped, meaning it is only accessible within the block it is declared in.

• var is function scoped, meaning it is accessible throughout the function it is declared in.

• Using let can help prevent variable hoisting issues.

• let allows you to redeclare a variable in the same scope, while var does not.

Pega is a BPM software that helps automate business processes and improve customer engagement.

• Pega provides a unified platform for process automation, case management, and customer service.

• It uses a model-driven approach to create applications without the need for coding.

• Pega's AI capabilities enable intelligent decision-making and predictive analytics.

• Pega is used by many industries including finance, healthcare, and government.

• Pega's low-code platform allows for faster deve...read more

Data structures are ways of organizing and storing data in a computer's memory, while algorithms are step-by-step procedures for solving problems.

• Data structures are used to efficiently manage and manipulate data, such as arrays, linked lists, trees, graphs, etc.

• Algorithms are the set of rules or steps to solve a particular problem, like sorting algorithms (e.g. bubble sort, quick sort) or searching algorithms (e.g. binary search).

• Understanding data structures and algorithms ...read more

Standalone and domain are two different modes of running a middleware server.

• Standalone mode runs a single server instance, while domain mode runs multiple server instances managed by a domain controller.

• In standalone mode, configuration is done on the server instance itself, while in domain mode, configuration is done on the domain controller.

• Standalone mode is suitable for small-scale deployments, while domain mode is suitable for large-scale deployments with high availabil...read more

Abstract classes are classes that cannot be instantiated and can have both abstract and non-abstract methods. Interfaces are contracts that define the methods that a class must implement.

• Abstract classes can have constructors while interfaces cannot

• A class can implement multiple interfaces but can only inherit from one abstract class

• Abstract classes can have instance variables while interfaces cannot

• Interfaces can have default methods while abstract classes cannot

• An abstract ...read more

HTML tags are used to structure content on a web page.

• <h1> - Heading tag

• <p> - Paragraph tag

• <a> - Anchor tag for links

• <img> - Image tag

• <ul> - Unordered list tag

The default port for JBoss is 8080.

• JBoss default port is used for HTTP traffic

• It can be changed in the server configuration file

• Other ports used by JBoss include 1099 for RMI and 4444 for JMX

• Example: http://localhost:8080/myapp

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 problems.

• Key concepts include encapsulation, inheritance, polymorphism, and abstraction.

• Encapsulation involves bundling data and methods that operate on the data into a single unit.

• Inheritance allows a class to inherit properties and behavior from another class.

• Polymorphism allows ...read more

A rule is a unit of logic that defines a specific behavior or action. A ruleset is a collection of related rules.

• A rule is a building block of Pega applications that defines a specific behavior or action.

• Rules are organized into rulesets, which are collections of related rules.

• Rules can be reused across different applications and rulesets.

• Rules can be versioned and managed using Pega's rule management tools.

• Examples of rules include decision rules, validation rules, and user ...read more

Promise callbacks are functions that are executed when a promise is resolved or rejected.

• Promise callbacks are defined using the then() and catch() methods.

• The then() method is executed when the promise is resolved.

• The catch() method is executed when the promise is rejected.

• Promise callbacks can be chained together using multiple then() methods.

• Example: promise.then(onResolved).catch(onRejected);

Case in Pega refers to a specific instance of a work item or task that needs to be completed.

• Cases are created when a user submits a request or when an automated process triggers a new case.

• Each case has a unique ID and contains all the information and data related to that specific task.

• Cases can be tracked and managed through Pega's Case Management tools.

• Examples of cases include customer service requests, insurance claims, and loan applications.

Arrays have fixed size, while lists can dynamically resize. Arrays store elements of the same data type, while lists can store different data types.

• Arrays have a fixed size, while lists can dynamically resize.

• Arrays store elements of the same data type, while lists can store different data types.

• Arrays are accessed by index, while lists are accessed by iterators or positions.

• Arrays are faster for accessing elements, while lists are better for inserting and deleting elements.