# 4K

Technical Consultant interview questions shared by candidates

## Top Interview Questions

Sort: Relevance|Popular|Date
Technical Consultant was asked...March 11, 2015

### Find the unique value in an array

Example: while (start Check for equal to target value / \ (1) (3) | | | ----&gt; start = (this leaf index) : if target is &gt; parent | ----&gt; end = (this leaf index) : if target =. Use index 8 and 3 in the array above as two prime examples. Furthermore, it would take a stroke of luck to find the unique value "1" take this for example: You have a struct named MyStruct with members ID which is type int and Value which is type int. If you randomly generated 'n' number of these and all except one were duplicates, how would you find the unique value? Less

public struct MyStruct : IEquatable, IComparable { // Saved for the sake of not having to recalculate every time its called (Specifically for this example.) private int _hashCode; public MyStruct(int id, int value) { ID = id; Value = value; _hashCode = 0; } public int ID { get; } public int Value { get; } public int CompareTo(MyStruct other) { return GetHashCode() == other.GetHashCode() ? 0 : GetHashCode() (MyStruct a, MyStruct b) { return a.GetHashCode() &gt; b.GetHashCode(); } public static bool operator {Value}"; } public override bool Equals(object obj) { return obj is MyStruct &amp;&amp; obj.GetHashCode() == GetHashCode(); } #endregion } Less

internal class Program { private static void Main(string[] args) { // Create a unique value var unique = new MyStruct("Unique".GetHashCode(), 0x200); // Prepare for all test cases var executionArray = new Func[] { executeFindCustomStructWithLinq, executeFindUniqueWithHashSet, executeFindUniqueWithBinaryTree }; // Execute test cases and get results var resultsTypeArray = executionArray.Select( method =&gt; new {Name = nameof(method), Result = method(unique)}); // print the results from the case resultsTypeArray.ToList().ForEach(item =&gt; WriteResults(item.Name,unique,item.Result)); Console.ReadKey(); } private static void WriteResults(string methodName, MyStruct orig, MyStruct target) { Console.WriteLine(\$"{methodName}: {orig} == {target}"); } private static IList CreateDataSet(MyStruct unique) { var random = new Random(); var amount = random.Next(0X0, 0x100); var myStructFactory = MyStructFactory.Instance; var dataSet = new List((amount*2) + 1); dataSet.AddRange(myStructFactory.Create(amount)); // create a copy of the base data set var holdingBuffer = new MyStruct[dataSet.Count]; dataSet.CopyTo(holdingBuffer, 0); // Insert Unique somewhere in the set dataSet.Insert(random.Next(0, dataSet.Count), unique); // add duplicated base dataset dataSet.AddRange(holdingBuffer); return dataSet; } #region ExecutionExamples private static MyStruct executeFindUniqueWithBinaryTree(MyStruct unique) { // Keep in mind this would only work if we knew the value before trying to parse the data set. var dataSet = CreateDataSet(unique); var orderedDataSet = dataSet.OrderBy(@struct =&gt; @struct).ToArray(); var start = 0; var identifiedUnique = new MyStruct(); var end = orderedDataSet.Count(); while (start (); var identifiedUnique = new MyStruct(); for (var i = 0; i a ^= b); return identifiedUnique; } #endregion } Less

### Is the Salesforce.com/Force.com platform a "relational database"?

I think it falls under the object-relational umbrella. Sure it does relationships, but it does more than that, and with the abstraction of the API you never really get at the full relational structure of the underlying oracle DB. Less

Answer number four is good I accidentally marked it as a negative

Yes it is, the platform is built on top of an oracle relational database.

### Technical SQL questions, Database Questions, Questions about products that SAP has, tell me about your education in under a minute.

just be honest. If you know the answer than obviously answer but if you are guessing.... then just tell the truth that you do not know and are guessing. Less

I was not able to negotiate and honestly I didn't feel the need to. I was offered a pretty high salary and bonus and did not feel it was necessary to negotiate. Less

### Question paper was divided in 4-5 sections. 1st four being technical and the last 1 was English exam. Out of 4 technical sections, 1st two were multiple choice questions on Object oriented programming, sql,html,dbms. Last 2 were case studies to draw flowchart/BP diagrams and to showcase Project Management knowledge. Over all the test - Medium tough.

Hello, tu peux m'expliquer un peu les questions sql? MP si tu prefers

Do u still remeber the questions? It will really help

Non

### can we write "public static void main()" as " void public static main()" ?

No.

No. Because public - so that any class can access it static - so that the JVM can access it without the need to instantiate the class object void - because it does not return anything main - this is just the method name. public - so that any class can access it static - so that the JVM can access it without the need to instantiate the class object void - because it does not return anything main - this is just the method name. Less

No public - so that any class can access it static - so that the JVM can access it without the need to instantiate the class object void - because it does not return anything main - this is just the method name. public - so that any class can access it static - so that the JVM can access it without the need to instantiate the class object void - because it does not return anything main - this is just the method name. Less

### Implement indexOf() (find the index of the first occurence of given number, in an array of sorted numbers)

Binary search with a slight modifications to ensure you search left for the first instance Less

// Time - O(logN) // Space - O(1) // modified binary search tree to find the first occurrence of 'k' in the sorted array private static int indexOf(int[] sortedArr, int k) { int left = 0; int right = sortedArr.length - 1; while(left k) { right = mid - 1; } else { left = mid + 1; } } return -1; } Less

// Time - O(logN) // Space - O(1) // modified binary search tree to find the first occurrence of 'k' in the sorted array private static int indexOf(int[] sortedArr, int k) { int left = 0; int right = sortedArr.length - 1; while(left k) { right = mid - 1; } else { left = mid + 1; } } return -1; } Less

### Implement strcmp() (string compare)

/* Time - O(n) where n is the time length of either a or b Space - O(1) Compare whether the two input strings are equivalent */ private static boolean strCmp(String a, String b) { if(a.length() != b.length()) { return false; } for(int i=0; i Less

/* Time - O(n) where n is the time length of either a or b Space - O(1) Compare whether the two input strings are equivalent */ private static boolean strCmp(String a, String b) { if(a.length() != b.length()) { return false; } for(int i=0; i Less

def strcmp(str1, str2): if str1 == str2: return True return False Less

### I have ping pong balls that I want to ship across the ocean in a freight ship. How many can you fit?

- What is the shape of the ping pong balls? The shape of a ball is a ball, man =) It's better if you find the answers by yourself on this questions. The key element they want to know is how can you think and look for the answers in the world around you. You should better predict all measurable values, than ask about them Less

and predict doesn't mean you just say ....hmm let it be 22. No. You should say that you saw a stap on one of balls with it's mass equal to 1g. And you saw a picture with a cargo ship near a man in dock so it's like 10 floor building and each floor is 3m high...so calculate Less

Make sure to ask clarifying questions. - How big are the ping pong balls? - What are the dimensions of the ship? - What is the shape of the ping pong balls? Less

### How would you make sure that a Proof of Concept can be seen as a success?

I pointed out the importance of establishing hard-facts - for example by measuring the time required by knowledge workers to do a particular job without the solution in place, then with RPA assisting them, and finally comparing and expressing the results. Less

I had a horrible experience interviewing with this company as while. I have been selling Digital automation platforms for 18 years and they did not seem to be familiar or appreciate any of the work experience I had brought to the the table. They also told me they were a unicorn and they needed very special people and they interview over 10 people a day. ? I realized when they told me that my secondary market was full of impressive candidates something was wrong? Very un-impressed with this experience and I work for an outstanding company currently , they found me? Less

The key in these questions is to cover the fundamentals, and be ready for the back-and-forth with the interviewer. Might be worth doing a mock interview with one of the UiPath or ex-UiPath Presales Technical Consultant experts on Prepfully? They give real-world practice and guidance, which is pretty helpful. prepfully.com/practice-interviews Less