20+ Spicejet Interview Questions and Answers

To filter 1 lakh rows in Excel with specific filter, use Excel's built-in filtering feature.

• Open the Excel file and select the column you want to filter.

• Go to the Data tab and click on the Filter button.

• A drop-down arrow will appear next to each column header.

• Click on the arrow of the column you want to filter and select the specific filter criteria.

• Excel will automatically filter the rows based on the selected criteria.

To publish and run a process without an orchestrator, you can use the UiPath Robot Tray or the command line interface.

• Open the UiPath Robot Tray and navigate to the Processes tab.

• Click on the 'Publish' button to publish the process to a local folder.

• Once published, you can run the process by selecting it from the list and clicking on the 'Start' button.

• Alternatively, you can use the command line interface by navigating to the installation folder of UiPath Robot and running th...read more

Truncating removes all records from a table, while deleting removes specific records.

• Truncating is faster than deleting as it does not log individual row deletions.

• Truncating resets identity columns, while deleting does not.

• Truncating cannot be rolled back, while deleting can be.

• Truncating is a DDL operation, while deleting is a DML operation.

To delete a row in a datatable while iterating, use the Remove method of the Rows collection.

• Use a loop to iterate through each row in the datatable.

• Check the condition for deletion and use the Remove method to delete the row.

• Ensure to handle the index correctly to avoid skipping rows.

RE Framework is a template for building scalable and robust automation solutions in UiPath.

• RE stands for Robotic Enterprise Framework

• It is a template that provides a standard structure for building automation solutions

• It includes pre-built workflows for exception handling, logging, and reporting

• It follows a state machine design pattern to manage the flow of automation

• It is highly customizable and can be adapted to fit specific business needs

Document understanding involves several steps to extract information from documents.

• Preprocessing: Cleaning and preparing the document for analysis.

• Layout Analysis: Identifying the structure and layout of the document.

• Text Extraction: Extracting relevant text from the document.

• Data Extraction: Identifying and extracting specific data elements from the text.

• Entity Recognition: Identifying and categorizing entities mentioned in the document.

• Classification: Assigning documents t...read more

IQ Bot is a cognitive automation solution that can learn from human behavior to handle unstructured data.

• IQ Bot uses machine learning algorithms to understand and extract data from unstructured documents.

• It can be trained to recognize patterns and extract relevant information from various types of documents.

• IQ Bot can be integrated with RPA tools like UiPath to automate end-to-end processes.

• It can handle documents like invoices, purchase orders, receipts, and more.

• IQ Bot can ...read more

PDF extraction involves using software tools to extract text, images, and data from PDF files.

• Use RPA tools like UiPath, Automation Anywhere, or Blue Prism to automate the process of extracting data from PDF files.

• Utilize OCR (Optical Character Recognition) technology to extract text from scanned PDFs.

• Extract structured data from PDF forms using data extraction techniques.

• Consider using regex patterns to extract specific information from PDF documents.

• Verify the accuracy of e...read more

SQL queries are used to retrieve, manipulate, and manage data stored in a database.

• Write SQL queries using SELECT, INSERT, UPDATE, DELETE statements.

• Use WHERE clause to filter data based on specific conditions.

• Join tables using INNER JOIN, LEFT JOIN, RIGHT JOIN.

• Aggregate data using functions like COUNT, SUM, AVG.

• Group data using GROUP BY clause.

• Order data using ORDER BY clause.

Process mining is a technique to analyze business processes by extracting data from event logs.

• It involves discovering, monitoring, and improving processes

• It uses data mining and machine learning techniques

• It helps to identify bottlenecks, inefficiencies, and opportunities for improvement

• Examples include analyzing customer journeys, supply chain processes, and financial transactions

Add queue item is used to add an item to a queue in a queue-based transactional process. Add transaction item is used to add an item to a transaction in a state machine-based transactional process.

• Add queue item is used in queue-based processes where items are processed in a first-in-first-out manner.

• Add transaction item is used in state machine-based processes where items are processed based on predefined states and transitions.

• Add queue item adds an item to a queue, while A...read more

There are three types of selectors in UiPath: UiElement, aaname, and idx.

• UiElement selector is the default selector used by UiPath, based on the attributes of the UI element.

• aaname selector is based on the 'aaname' attribute of the UI element.

• idx selector is based on the position of the UI element in the application window.

Selectors can be made reliable by using unique attributes, adding wildcards, using reliable parent elements, and using dynamic selectors.

• Use unique attributes: Select elements with attributes that are unique to them, such as ID or name.

• Add wildcards: Use wildcards like asterisks (*) or question marks (?) to account for dynamic values in selectors.

• Use reliable parent elements: Select elements based on their parent elements that have stable attributes.

• Use dynamic selectors: Use...read more

API automation with UiPath

• UiPath provides activities and tools to automate API interactions

• Use HTTP Request activity to send HTTP requests and receive responses

• Extract data from API responses using JSON or XML parsing

• Handle authentication and authorization using headers or tokens

• Automate repetitive API tasks like data extraction, data synchronization, etc.

Credentials in UiPath can be stored in Orchestrator Assets, Windows Credential Manager, Config file, and Constants file.

• Orchestrator Assets: Securely store credentials in Orchestrator and retrieve them during automation.

• Windows Credential Manager: Store credentials in Windows Credential Manager and access them in UiPath.

• Config file: Store credentials in a separate configuration file and read them during automation.

• Constants file: Store credentials as constants in a separate f...read more

Classic folder is the traditional way of organizing files in UiPath, while modern folder is a newer feature with enhanced security and management capabilities.

• Classic folder is the original way of organizing files in UiPath, with limited security and management features.

• Modern folder is a newer feature in UiPath, offering enhanced security, management, and collaboration capabilities.

• Modern folders allow for better control over permissions and access rights compared to classic...read more

The REframe work is a framework used in Robotic Process Automation (RPA) development. It consists of stages and transitions.

• REframe work is a widely used framework in RPA development.

• It helps in structuring and organizing the automation process.

• The framework consists of various stages and transitions.

• Stages represent different phases of the automation process.

• Transitions define the flow of control between stages.

• Stages and transitions are defined using state machines.

• Each sta...read more

Yes, Excel can be used as a database for small-scale data management and analysis.

• Excel can be used to store and organize data in tables similar to a database

• Functions like VLOOKUP and PivotTables can be used for data analysis

• Excel can handle large amounts of data but may not be as efficient as a traditional database for complex queries

The output of click activity is the action of clicking on a specified element on the screen.

• The output is the successful click on the specified element.

• It triggers the action associated with the clicked element.

• The output can be a confirmation message or a change in the UI.

• If the click activity fails, an error message may be generated.

Credential Manager is used to securely store and manage credentials for RPA development.

• Credential Manager is a feature in RPA tools that allows developers to store and retrieve credentials securely.

• It helps in avoiding hardcoding of sensitive information like usernames and passwords in the code.

• Credentials can be stored in an encrypted format and accessed when required during automation execution.

• RPA developers can use Credential Manager APIs or activities provided by the RP...read more

A List variable is a data structure that stores a collection of elements, typically of the same type.

• List variables can hold multiple values and are commonly used to store and manipulate data.

• They can be indexed and accessed using numerical positions.

• List variables can be modified by adding, removing, or updating elements.

• Examples of List variables include a list of names, a list of numbers, or a list of tasks.

throw is used to explicitly throw an exception, while rethrow is used to rethrow an exception caught in a catch block.

• throw is used to raise an exception and terminate the current execution.

• rethrow is used to propagate an exception to the next higher level of the call stack.

• throw can be used anywhere in the code, while rethrow is used only inside a catch block.

• throw requires specifying the type of exception being thrown, while rethrow does not require specifying the type.

Document understanding is the process of extracting key information from documents using AI and machine learning.

• It involves analyzing and extracting data from various types of documents such as invoices, receipts, contracts, and forms.

• Document understanding helps automate data entry, improve accuracy, and streamline business processes.

• It uses techniques like optical character recognition (OCR), natural language processing (NLP), and machine learning algorithms to extract and...read more

Left click is a computer mouse action where the left button is pressed and released.

• Left click is a common action used to select items, open files, and interact with software.

• It is typically the primary button on a mouse and is used for most actions in computer applications.

• Examples include clicking on icons, buttons, links, and dragging items on the screen.