Technical Consultant Interview Questions
4K
Technical Consultant interview questions shared by candidates
Find the unique value in an array
5 Answers↳
Example: while (start Check for equal to target value / \ (1) (3) | | | ----> start = (this leaf index) : if target is > parent | ----> 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() > b.GetHashCode(); } public static bool operator {Value}"; } public override bool Equals(object obj) { return obj is MyStruct && 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 => new {Name = nameof(method), Result = method(unique)}); // print the results from the case resultsTypeArray.ToList().ForEach(item => 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 => @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"?
5 Answers↳
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.
4 Answers↳
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
↳
Thank you for your response
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.
4 Answers↳
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()" ?
3 Answers↳
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)
3 Answers↳
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)
3 Answers↳
/* 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?
3 Answers↳
- 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?
3 Answers↳
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
how do you compare two java string object if they have the same string stored in them ?
3 Answers↳
The equals method returns a boolean primitive. This is so that it can be used to drive an if, while or other looping statement. It can be used where you would use the == operator with a primitive. The operation of the equal method and == operator has some strange side effects though when used to compare Strings. This is one occasion when the immutable nature of Strings, and the way they are handled by Java(uses Pooling), can be confusing. There are two ways of creating a String in Java. The one way does not use the new operator. Thus normally a String is created String s = new String("Hello"); but a slightly shorter method can be used String s= "GoodBye"; << like in C (as == comes from C) Generally there is little difference between these two ways of creating strings, but such questions as this one require you to know the difference. The creation of two strings with the same sequence of letters without the use of the new keyword will create pointers to the same String in the Java String pool. The String pool is a way Java conserves resources. To illustrate the effect of this String s = "Hello"; String s2 = "Hello"; if (s==s2){ System.out.println("Equal without new operator"); } String t = new String("Hello"); string u = new String("Hello"); if (t==u){ System.out.println("Equal with new operator"); } From the previous objective you might expect that the first output "Equal without new operator" would never be seen as s and s2 are different objects, and the == operator tests what an object points to, not its value. However because of the way Java conserves resources by re-using identical strings that are created without the new operator, then s and s2 will have the same "address" and the code does output the string "Equal without new operator" However with the second set of strings t and u, the new operator forces Java to create separate strings. Because the == operator only compares the address of the object, not the value, t and u have different addresses and thus the string "Equal with new operator" is never seen. ANS : The equals method applied to a String, regardless of how that String was created, always performs a character by character comparison, its safer than == which depends on how it was created - if new was used the pointer ref would be different even for the same contents, if assignment was used then pooling uses the same reference for both same words thus pointer ref would be same. Less
↳
I don't think either answer is right, in Java strings objects wither created by =new String("xxx") or "xxx" are only reference to an internally stored string. So if you test == you are testing if the reference is the same i.e. String s1="xxx" String s2="xxx" the expression s1==s2 would evaluate false as the are actually different expressions so you can use equals("xxx") or compareTo("xxxx"). I like using compareTo("xxx")==0 to test whether strings point to the same value. Less
↳
There could be two answers to the question depending upon how the string objects are created. If created using String constructor like str1 = new String("str1") in that case the equals() method is to be used. However if created using direct assignment like str1="str1" the we could use references to compare like str1==str2; the concept is of the string pool. Less