Write a function that takes in two sorted lists and outputs a sorted list that is their union.
Data Interview Questions
132,905 data interview questions shared by candidates
They asked probability question: 1) The probability that item an item at location A is 0.6 , and 0.8 at location B. What is the probability that item would be found on Amazon website. 2). I have table 1, with 1million records, with ID, AGE (column names) , Table 2 with 100 records with ID and Salary then the interviewer gave me the following SQL script SELECT A.ID,A.AGE,B.SALARY FROM TABLE 1 A LEFT JOIN TABLE 2 B ON A.ID = B.ID + WHERE B.SALARY > 50000 ( HE ASKED TO MODIFY THIS LINE OF QUERY) How many records would be returned? 3. Give a csv file with ID, and Quantity columns, 50million records and size of data is 2gig, write a program in any language of your choice to aggregate the QUANTITY column.
Calculate the average word length. For the given set of words return the average word length.
Given a dictionary, print the key for nth highest value present in the dict. If there are more than 1 record present for nth highest value then sort the key and print the first one (alphabetically). N can be higher than the number of elements in the dictionary.
100 even number in ascending order first 50 number average is N then all the number average is a N+49 B N+50 C N+55
Write a function to count the number of times each character appears in a string and rewrite the string in that format. Eg. "I am back." should become "i1 2a2m1b1c1k1.1"
Two players are at deuce in a tennis match - player 1 has 60% of winning the point, player 2 has 40% chance. What are the odds of player 1 winning?
Given a list of ints, balance the list so that each int appears equally in the list. Return a dictionary where the key is the int and the value is the count needed to balance the list. [1, 1, 2] => {2: 1} [1, 1, 1, 5, 3, 2, 2] => {5: 2, 3: 2, 2: 1}
SQL questions on promotions, sales schema. what %age of products have both non fat and trans fat. find top 5 sales products having promotions what %age of sales happened on first and last day of the promotion Mysql was used and interviewer asked to if this can be done without subquery. Python:- [1,None,1,2,None} --> [1,1,1,2,2] Ensure you take care of case input[None] which means None object. find s in missisipi.
Write a function to return the number of times a character appears in a string. The character can be the empty string.
Viewing 31 - 40 interview questions
See Interview Questions for Similar Jobs
Computer OperatorDatacenter TechnicianNoc OperatorConfiguration Management AnalystCirculation ManagerMedical ClerkManager AnalyticsMailroom ClerkMail SorterMedical Office ReceptionistMedical Office ClerkMail Room ClerkMedical Record Retrieval SpecialistManual Software TesterMedical Office SpecialistManager Marketing AnalyticsMedical Claims ProcessorMedical Billing ClerkMarketing Analytics Manager