what are window functions, explain rank and dense rank explain joins and no of outputs for each join for a given table, where vs having clause second highest salary for each department partition vs bucketing, when to choose each, python code to remove duplicate from a list list vs tuple vs dict. py thon code to find combinations from list [2,3,5] where sum is 8.
Explain about Domain Name System.
Do you have any experience with Neo4j? Do you have any experience working Aurora?
The looked at my resume and then offered me the job.
Java Backend and DevOps, Spring, Hibernate, Microservices.
React, Springboot, designing , behavioral questions
Online assessment (get 1 question + maybe half a question right to move forward ; 325 or 350pt >) 4 rounds Technical. Systems design, behavioral, Case study Technical was very easy System design was very easy Behavioral - easy Case study - I had no idea what this was about, how to pace myself, what questions I needed to ask or what... (again the interviewer gave me such a hard time)
STAR type questions. One hint, if you're interviewing for an engineering position- they don't seem to care about your technical expertise, so showing a portfolio, or demonstrating past work, is unnecessary, and seemingly detrimental to your chances of receiving an offer. Just answer the behavioral questions.
Soql query to get second hight amount of opportunity of an account. What is shadow dom? How can we pass data from one component to another LWC. One code question involving maps and sets in apex. Sharing questions.
Problem 1 : Given an input n stairs, return the possible permutations to reach nth stair. Constraints: you can move at the most 1 step or two steps at a time. input_1 : n = 0 output_1 : [[0]] input_2 : n = 1 output_2 : [[0,1], [1]] input_3 : n = 2 output_3 : [[0,1,2], [1,2], [0,2], [2]] Design Question : Design an E-commerce website like Amazon/walmart. Problem 2 : Design a stack and implement all the methods in the stack. Problem 3 : Implement queue with stack.
Viewing 61 - 70 interview questions