Don't remember the exact question, but it was a variant of a leetcode hashmap implementation, it was easy but I messed up because of nerves and cramming. Most of their codebase is in Python. So if you know how to write some great Python code, learn about the inner workings of the GIL, etc. You should be good. Questions are easy to medium so don't make the mistake I did and go calmly, get a good night's sleep. There is no need to cram and you'll do well.
Asked me about the difference between PATCH vs PUT vs POST when dealing with Rest APIs
Screening round What is CAP theorem? Given a stackoverflow page how will you design it? What is index in databases? SQL vs NoSQL REST API protocols Coding interview: Happy number leetcode easy Maximize the amount stolen by burglar (DP) leetcode medium
Some of the projects I have worked on.
How many years i have experience.
questions related nodeJS and javascript
Linux Questions: 1. How to identify if the installed OS is running Fedora / RedHat / CentOS / or Ubuntu? 2. Write a small shell script that captures the CPU% usage of a given running process every 10 seconds? (Hint: You can use ps -p <pid> -o %cpu,cmd command to get the CPU% of a given process) 3. What is the difference between the following two commands? $ ./start_test.sh & and $ nohup ./start_test.sh & 4. Given the following text string, use any Linux command to extract the following: version number date build 4.7.0dev-20190424-5f2997a38e In the above example: The version number is: 4.7.0 The date is: 20190424 The build is: 5f2997a38e Python Questions: 1. Given two text files: file1.txt: Apple Orange Pineapple Grape Grapefruit file2.txt Grape Strawberry Fig Pineapple Write a function to return the union of both files in descending order. So in the above example, it should return: Strawberry Pineapple Orange Grapefruit Grape Fig Apple 2. What are decorators in Python? 3. What are Generators in Python? QA Test Coverage Questions: Let’s say we have a function that evaluates the intersection of two given polygons. The function returns True if the two polygons intersect, and returns False if the two polygons do not intersect. How would you test this function? What approach(es) would you use to determine whether the test coverage is sufficient or not? 3. When you verify a bug fix, what action(s) do you usually take? SQL Questions: Let’s say the following SQL query gives you a result set like this: SELECT s.Manager, s.Countries, s.Year, SUM(s.Sales) from Sales s GROUP BY s.Manager, s.Countries, s.Year ORDER BY year ASC; Manager Countries Sales Year p_tomlinson@acme.com USA 16,000,000 2017 p_tomlinson@acme.com USA 24,000,000 2018 m_mcdonald.acme.com USA 45,000,000 2019 Modify the above SQL query so that only the rows where the annual sales more than 20,000,000. Expected output: Manager Countries Sales Year p_tomlinson@acme.com USA 24,000,000 2018 m_mcdonald.acme.com USA 45,000,000 2019 2. Write a SQL query so that if the Result_Code column is 1, set the Status column to Passed. If the Result_Code column is 0, then set the Status column to Failed. Sample table:: Test_Case_Name Start_Time Result_Code avg() test 2019-01-02 00:02:04 1 sum() test 2019-01-02 00:04:13 1 abs() test 2019-01-02 00:07:44 0 length() test 2019-01-02 00:08:08 1 Expected output: Test_Case_Name Start_Time Result_Code Status avg() test 2019-01-02 00:02:04 1 Passed sum() test 2019-01-02 00:04:13 1 Passed abs() test 2019-01-02 00:07:44 0 Failed length() test 2019-01-02 00:08:08 1 Passed 3. Write a SQL query to find the word from a table that has the most occurrence. (Note: If tie-break, then both words shall be returned.) Sample table:: fruits orange apple orange pineapple apple orange apple apple apple orange orange Expected output: fruits count apple 5 orange 5 For Senior QA: Write a multithreading class that generates 100 files with 10000 lines each. If you were doing white box testing for the above code, how would you test it? If you were doing black box testing for the above code, how would you test it?
Technical interview: - Generally talked about what I have done in previous companies
What are you looking to get out of this position?
Have you got experience working with stakeholders to define product requirements?
Viewing 2191 - 2200 interview questions