UHG Interview question For RPA & .Net Profile

7- June-2019

UHG Interview question
First Round Is Telephonic: In telephonic round they have asked similar question, that asked in 2nd round
Second Round: SQL:
1	What is Primary Key
2	Can we pass call a store procedure in a query? For e.g. Select * from Store procedure
3	Can we pass call a Function in a query? For e.g. Select * from Function
4	What type of parameter you have pass in Store procedure?
5	Can we get a table from a store procedure and store procedure don’t have any return type
6	Can we create a store procedure that have some parameter, but during the call of parameter we don’t pass any parameter?
7	What is View.
8	Why View comes in practice?
9	Which kind of information we have performed with the view.
10	What is RANK function in View.
11	Is there any way to make a store procedure that is not readable for other person?
12	Whenever we have created a database what are the primary file create in SQL
13	Have you heard about MDF file? What is the role of that file?
14	What is trigger
15	Suppose you have a view, can you pass a parameter in the select query of that view.
16	What is Temp DB in SQL
17	What IS DML And DDL Commands
18

C# Inter View Question
1	What is Optional parameter in
2	Can we create a array that store diff data type value
3	What is Generic
4	Difference in list and Array List
5	Delegate in C#.
6	Have you ever used delegate in your project?
7	What is Multi-Threading in C#
8	What is PARAM
9	OOPS concept
10	Difference Between Abstraction and Inheritance
11	How abstraction can achieve?
12	Interface in C#
13

3rd Round with Manager

1.       Write a program of number swapping without using third variable

2.       Find out the second highest salary from Employee Salary Table

3.       Write a multi-threading program and Explain

4.       What Kind of project you are working On RPA

5.       Can we call a Exe from RPA  

Share:

Read More

EY company interview questions on RPA with .Net profile

Hi Friends

I am sharing my experience.

RPA:

1. How we use Rest API in AA.
2. How to use .net DLL in AA.
3. How to fetch Excel data in AA.
4. Can we store all Excel data in a single variable ,or can we hold all Excel data in AA.
5 How we get all Excel row and last row of Excel in AA.
6 supposed you have a excle data in

Prod.| Quantity| price | total price
Pen.      5                  10
 
Now you have to calculate total price and finally result should be store in database and final report ssrs report should be generated.


Condition:
Looping and travesing is only the best way .
Either put formula in Excel last row .

Which one is better.-

7.Genreic in RPA
----------------------------------------------

MVC

What is MVC
WHAT is modal view controller
Route config and app config
How there is a communication between all three.

How route config code work.

Supposed previous problem you have how you can read the data .
How can you do this exercise in MVC
Loos coupling and tight coupling

======================={
Bootsrap



What type of control u used
How to set dynamic control
Can a control change Dynamic

Share:

Read More

Automation Anywhere interview at Wipro 2019

Hi friends!

I am sharing some AA interview questions asked in Wipro.



1. Tell me about your project.
2. How many process you have used in Automation anywhere.
3. You are well in .net why you not choose Blue prism.
4. How to select a tool for project.
5. Who dicide which tool , should use for your current project.
6. Criteria on which you have select AA.
7. Money matter for selection or other thing else.
8 what is ATP
9. Meta bot in AA.
10. PDF integration steps
11. Differnece between  As-IT ot To-be diagram
12. How you see PDd documents.
13. Have you heard about key strock document.
14 . Difference between key strock document and pdd document.

That's are some questions asked in Wipro for first round.

Share:

Read More

RPA INTERVIEW at UI path company

H
friends,

Last week I gave an interview with the ui
Path. I am sharing my experience with all of you.

There is a logical test conducted by hackerrank.com

Test have 12 question
10 some logical reasoning
2 for programming.

Total time to complete the task is 90 min.

Programming questions:

 1. Find the perfect string in a string A string is called perfect string If all of it's element exist exactly k time.
String 1102021222 and k = and is 62

2. Count no of element in pair of exactly k repetition of element
131 and k =1
And (1,3)(3,1)


I passed this test

Second round :
It's a Skype round take 1 hr of test.

Interview questions asked
1. Tell me about your self
2. Tell me about your project
3. What you know about RPA.
4. What is the real meaning of RPA as per your knowledge.
5. How many process you have used in RPA.
6. What is inner bot and frontend bot.
7. How we check error or debugg our program.
8.your team and work approach
9. Your role in your team
10. How to handle a process that have multiple table data .
11. If a client have different Excel file . And you want to merge in a. Single file but all data should be  standard ,how you can done with RPA .
12 .what is DLL
13. How can you create a DLL for which project you create a DLL.


Some programming questions.

1.How can check type of a variable.
Logic behind a sting have another string.
3. 4 person crossing a bridge.they have a single tourch
But some condition there .
1 .Aleast 2 at a time
2. With  at tourch
3. One can cross the birge in 1 min, second in 2 min ,third in 5 min ,4 in 12 min

In what pattern they cross the bridge
What is the minimum time they take for cross the bridge.

Share:

Read More

Top 30 RPA Interview Question 2018-2019

Top 30 RPA Interview Question 2018-2019

In this article you will find out top 30 question asked in RPA.

Automation Anywhere Interview Questions

UiPath Interview Questions

Blue Prism  Interview Questions

1.	Tell me about your self
2.	Your current role and responsibility
3.	Describe your current project
4	Describe how you implement each business step technically in your RPA
5	How Many process and object you have created in RPA
6	Describe the process Activity in Details for your RPA
7	What is the stage available in in process studio but not in object studio and vise versa
8	Describe each process stage and object stage
9	What are the session variable
10	What are the environment variable
11	Difference btw session and environment variable
12	Have you scheduled any job in RPA describe in details
13	How many BOT are using in the environment
14	We should not store the user id and password in the environment variable , how to store credential in RPA
15	Excel Business Object in Details
16	What is Environment locking in RPA
17	Can we use environment locking in work Queue
18	Architecture of your RPA tool
19	How you solved any network related issue in RPA
20	Exception handling in RPA
21	What are the best practice in RPA
22	Have you work on email automation, describe in details
23	What is code stage
24	What is internal vBOS`
25	How to use custom holiday list in RPA
26	Multibot Architecture describe
27	Issue face in your RPA toll during development
28	How to select a tool
29	How to make PDD
30	Have you make any SDD .

Share:

Read More

Count All Distinct Pairs with a difference equal to k. 1 repetition is allowed

Count All Distinct Pairs with a difference equal to k. 1 repetition is allowed 

This problem is a test conduct by hackerrank site.

In this problem an array is given with some integer value and a set value k is also given, now the task is find the distinct pair of record with a set of K value

public static int kDifference(List<int> a, int k) { //write code here }

static void Main(string[] args) { Console.WriteLine("Enter the No you want to add"); int aCount = Convert.ToInt32(Console.ReadLine().Trim()); //aCount have user input List<int> a = new List<int>();// creating a list for (int i = 0; i < aCount; i++) { int aItem = Convert.ToInt32(Console.ReadLine().Trim()); a.Add(aItem);//adding value in list } Console.WriteLine("Enter the set No K Value"); int k = Convert.ToInt32(Console.ReadLine().Trim()); int result = kDifference(a, k);//calling method Console.WriteLine(result); Console.ReadLine(); }

Solution:

 I am too much comfortable with array that’s why I am using array to solve this

problem.

Main logic behind the problem is :

For eg:

string 1 3 5 and k =2

where k represent 2 distinct string i.e (1,3) and (3,5) , one value repetition is allow logic:  1-3==k or 3-5==k where k =2 then count++;

1– 3= 2 which is true

3– 5 = 2 which is also true

public static int kDifference(List<int> a, int k) { int[] arr = new int[a.Count]; int count = 0; int l=0; foreach (var item in a) { arr[l] = item; l++; } for (int i = 0; i < a.Count - 1; i++) { for (int j = i + 1; j < a.Count; j++) { if (arr[i] - arr[j] == k || arr[j] - arr[i] == k) count = count + 1; } } return count; }

Share:

Read More

Count number of similar element of an array in Pair using C#

Problem

John works at a clothing store. He has a large pile of socks that he must pair by color for sale. Given an array of integers representing the color of each sock, determine how many pairs of socks with matching colors there are.

For example, there are  socks with colors . There is one pair of color  and one of color . There are three odd socks left, one of each color. The number of pairs is .

Function Description

Complete the sockMerchant function in the editor below. It must return an integer representing the number of matching pairs of socks that are available.

sockMerchant has the following parameter(s):

·         n: the number of socks in the pile

·         ar: the colors of each sock

Input Format

The first line contains an integer , the number of socks represented in .
The second line contains  space-separated integers describing the colors  of the socks in the pile.

Constraints

·          

·          where 

Output Format

Return the total number of matching pairs of socks that John can sell.

Sample Input

9

10 20 20 10 10 30 50 10 20

Sample Output

3

Explanation

No of Unique pair in an Array using C#

John can match three pairs of socks.

This Problem is taken from Hacker rank

Share:

Read More