Fluke Corporation Interview Question

1st Round - Online 1. 15 Questions MCQ(diffculity: Simple/Medium) 2. SQL Challange(diffculity: Simple) 3. String Challange(diffculity: Simple) 4. Array Challange(diffculity: Medium) 2nd Round: Technical Problem Statment 1: Have the function OverlappingRanges(arr) take the array of numbers stored in arr which will contain 5 positive integers, the first two representing a range of numbers (a to b), the next 2 also representing another range of integers (c to d), and a final 5th element (x) which will also be a positive integer and return the string "true" if both sets of ranges overlap by at least x numbers. For example: if arr is [4, 10, 2, 6, 3] then your program should return the string true The first range of numbers are 4, 5, 6, 7, 8, 9, 10 and the second range of numbers are 2, 3, 4, 5, 6. The last element in the array is 3, and there are 3 numbers that overlap between both ranges: 4, 5, and 6. If both ranges do not overlap by at least x numbers, then your program should return the string "false" Problem Statment 2: Write a SQL query to return all Supervisor Names with more than 20 employees directly reporting under them Employee table: Eid - Employee ID PK Ename - Name of the Employee DeptId - FK Department Table SupervisorId - Holds Eid whoever is the manager Department Table: DeptId DeptName 3rd Round: Technical Problem Statment 1: List<string> a, List<string> b use LINQ lambda expressions, give me a new List<string> that contains all elements that are common to a and b Problem Statment 2: List<string> a, List<string> b without using LINQ lambda expressions, give me a new List<string> that contains all elements that are common to a and b Problem Statment 3: List<string> a, List<string> b, give me a List<char> that contains all the characters that can be found in strings of both lists. ​ Ex: a="ted" , "dave", "bill" and b="tod", "zim", "mom" output: t, d - use linq Problem Statment 4: List<string> a, List<string> b, give me a List<char> that contains all the characters that can be found in strings of both lists. ​ Ex: a="ted" , "dave", "bill" and b="tod", "zim", "mom" output: t, d - without using linq Problem Statment 5: table customer: has customerid and customer name table address: has addressid, customerid, street name and number Give me all the customers who has address, even if they dont have address Problem Statment 5: table customer: has customerid and customer name table address: has addressid, customerid, street name and number Give me all the customers who has address