Monday 17 December 2018

UiPath Certification - Sample Questions and Answers - Lesson 10 PDF Automation

Here is the sample question and answers from the Lesson 10 from the UI Path

1)Will the Read PDF with OCR activity open the PDF document on the screen in order to read it?

  No

2)What is the easiest way to get the invoice number from a native PDF file?

  Open the PDF with Acrobat and scrape only relevant information

3) Which of the following activities requires the PDF file to be opened with Acrobat Reader in order to read it?

    Get Text

4) Which of the following statements regarding the Read PDF with OCR activity are true?

   It works with native .pdf files
   It allows you to specify the range of pages to be read

5) How can you specify the location of a PDF file?

    As a relative path
    As a full path to the PDF


NOTE : This sample questions are only for the reference and not to be considered as actual questions. As always, its recommended to go through the training materials which will have loads of information on the technical part.

UiPath Certification - Sample Questions and Answers - Lesson 9 Excel and Database Tables

Here is the sample question and answers from the Lesson 9 from the UI Path

1)What happens if you use the Write Range activity with the Range property set to “” to write a datatable to an excel file that already contains data?
  
  It will overwrite the existing data.

2)Can Excel related activities be used without having the Excel Application installed?
  
   Yes but only for xlsx files

3)What is the Output Data Table activity used for?
  
   Saves all data from the Data Table to a string variable.


4)What activity can be used to read an entire sheet from a excel file?
 
   Read Range


NOTE : This sample questions are only for the reference and not to be considered as actual questions. As always, its recommended to go through the training materials which will have loads of information on the technical part.

UiPath Certification - Sample Questions and Answers - Lesson 8 Advanced Citrix Automation

Here is the sample question and answers from the Lesson 8 from the UI Path

1) Can a Pick Branch activity be used alone?
    No, it can only be added inside a Pick activity body.

2) How do you reset a clipping region?
     With a Set Clipping Region activity

3) What does the Find Image activity return?
     An UI element object.

4) If a Click Image activity was created with an image of an icon, and meanwhile that icon becomes highlighted, will the activity still work?
    Yes, if the clipping region avoids the background of the icon.
    No, if the accuracy is too high.

NOTE : This sample questions are only for the reference and not to be considered as actual questions. As always, its recommended to go through the training materials which will have loads of information on the technical part.

UiPath Certification - Sample Questions and Answers - Lesson 7 Image and Text Automation

Here is the sample question and answers from the Lesson 7 from the UI Path

1) Click Image and Click Text are not 100% reliable in Citrix environments. What method can be used instead (when applicable) to have safer actions?
   Setting focus on a reliable element and then navigating around the app using keyboard (up/down arrows, tab, etc) or using keyboard shortcuts.

2) What activities can be used to interact with applications in a Citrix environment?
Click OCR Text
Type Into
        Click Image

3)What method would be more reliable when clicking on a specific text label in an application running in a Citrix environment, given the fact that its font size might be easily changed?
   Using the Click OCR Text activity.

4) Having an app in a Citrix environment with multiple text-boxes that look the same (size/style), how can you identify one of them to type into?
   
    By clicking relative to an unique text/image next to the textbox

5) How can you improve accuracy when scraping with OCR a region that contains only digits?
       Use Google OCR with “Numbers Only”



NOTE : This sample questions are only for the reference and not to be considered as actual questions. As always, its recommended to go through the training materials which will have loads of information on the technical part.

UiPath Certification - Sample Questions and Answers - Lesson 6 SELECTORS

Here is the sample question and answers from the Lesson 6 from the UI Path

1) Can you store a Selector in a variable?
   Yes, of type String

2) How can you see the full list of attributes of Ui elements?
   By using the UiExplorer tool.

3) What is the Highlight activity useful for?
   For troubleshooting and verifying selectors

4) Can UiExplorer be used to record UI interactions?
   No

5) Can variables be used to build dynamic selectors?
   Yes


NOTE : This sample questions are only for the reference and not to be considered as actual questions. As always, its recommended to go through the training materials which will have loads of information on the technical part.

UiPath Certification - Sample Questions and Answers - Lesson 5 ADVANCED UI INTERACTION

Here is the sample question and answers from the Lesson 5 from the UI Path


1) Which of the text extraction methods can return the hidden text from a UI element?
    FullText

2) The main advantage of the OCR method is:
     It works on every application even if it’s running in a virtual environment.

3) What is the best activity for scraping tables from a web page?
    Data scraping wizard

4) By using the Full Text scraping method, the robot is able to:
   Get hidden information

5) What text extraction method can you use to get text position?
   Native
   OCR


NOTE : This sample questions are only for the reference and not to be considered as actual questions. As always, its recommended to go through the training materials which will have loads of information on the technical part.

UiPath Certification - Sample Questions and Answers - Lesson 4 Recording

Here is the sample question and answers from the Lesson 4 from the UI Path


1. When is it recommended to use Desktop recording?
   
     When you automate more steps in the same window

2. What actions can you record using Automatic Recording?
    Type Into
    Click

3. Can you combine automatic recording with step-by-step recording in the same recording sequence?
    Yes

4. How do you stop the recording?
     Escape

5. What type of container will Basic Recording generate?
     No container

NOTE : This sample questions are only for the reference and not to be considered as actual questions. As always, its recommended to go through the training materials which will have loads of information on the technical part.

UiPath Certification - Sample Questions and Answers - Lesson 3 DATA MANIPULATION

Here is the sample question and answers from the Lesson 3 from the UI Path


1. Which of the following data types are included in the Collections category?
List
Array

2.Which of the following statements are true regarding the Output DataTable activity?

  Returns the data contained in a DataTable as a string in a csv format

3.If the dtNewHires datatable has 4 columns, in this order : [ID, Name, Age, Sex] and 2 rows: [1, Daniel, 38, M] ; [2, Andra, 24, F],
what is the result of the expression dtNewHires.Rows(0)(1)?
Daniel

4.What key combination allows you to automatically create a variable from an activity’s property field?

  Ctrl + K

5)What type of variables can be used as output for the Read CSV activity?

DataTable variables


NOTE : This sample questions are only for the reference and not to be considered as actual questions. As always, its recommended to go through the training materials which will have loads of information on the technical part.

UiPath Certification - Sample Questions and Answers - Lesson 2 Variables and Data Types

Here is the sample question and answers from the Lesson 2 from the UI Path


1.What happens if you rename a variable from the Variables tab?
The name will be automatically updated in all the activities that use it.

2.Which activity can you use if you want to test if a condition is true or false?
Flow Decision activity
If activity

3.Which activity can you use if you want to loop through a collection of items?
   For Each activity

4.What is the activity designed to represent a decision inside a Sequence?
   The If activity

5. What data types can be stored inside an array?
        Integer
        Double
        Boolean
        String


NOTE : This sample questions are only for the reference and not to be considered as actual questions. As always, its recommended to go through the training materials which will have loads of information on the technical part.

UiPath Certification - Sample Questions and Answers - Lesson 1

UiPath Certification Notes/answers

UiPath, is Robotic Process Automation tool, which empowers and equip yourself the latest digital technology in automation.

One can enroll for the RPA Developer foundation technical trainings. Here is the https://academy.uipath.com link to register and enroll for the same. As part of this online training, one needs to complete total number of 13 chapters mandatorily and fulfill the certification assessment.

There will be 3 chances to complete the certification. Each chapter has test assessment, which needs to be completed before moving on to the next chapter.

Here are the sample questions which are part of the certification assessment and the quiz answers for each of the chapter.

NOTE : This sample questions are only for the reference and not to be considered as actual questions. As always, its recommended to go through the training materials which will have loads of information on the technical part.

Lesson 1 : Introduction to UI Path.

1.Can you run multiple instances of the same process, in parallel?
    
    Yes, on different robots.

2.What is a reusable component?
   
   A workflow that implements a very common action repeated throughout all your automations.

3.Scheduling a process is done from:
    
   Orchestrator Server.

4.Is it possible to create other activities than the existing ones in UiPath Studio?
   
   Yes, you can create a Custom Activity.


Saturday 27 October 2018

Generate Random number using SQL Query

Generate Random number

Here is the script to generate the random 10 digits number using SQL. And of course, this can be modified accordingly to suit the requirements.


Select SUBSTR('0000000000'||TO_CHAR(ROUND(DBMS_RANDOM.VALUE(1,10000000000),0)),-10) from dual;


This Select query generates a 10 digit random number. This will be useful for using generating primary keys when using on the primary key tables.




Monday 1 October 2018

Example of FORALL Insert statement

FORALL Insert statement.

As we all know, FORALL is much faster than the FOR LOOP for processing.It is usually used for the BULK processings records.

Here is simple example of the usage of the FORALL Insert statement.

TYPE cm_per_tbl_type IS TABLE OF per_table%ROWTYPE INDEX BY PLS_INTEGER

l_per_tbl_type cm_per_tbl_type;

IF l_per_tbl_type .count > 0
THEN

          FORALL l_cnt IN l_per_tbl_type.FIRST .. l_per_tbl_type.LAST
          INSERT INTO cmx_per_table
          values  (l_per_tbl_type(l_cnt).per_id,l_per_tbl_type(l_cnt).per_name);
END IF;

The same can be modified according to the requirements and be used.