Microsoft Corporation SQL Developer Interview Questions and Answers for Experienced

• Q1. Js basics like var, let and const
  Add Answer
• Q2. Angular basic questions
  Add Answer

So basically the questions were from strings, arrays, bitwise operators and some mathematical logic based questions. There were 10 questions and they will provide you a laptop and you have to complete all of them in 3 hours (java, c++)
Just be prepared on the above mentioned topics the questions were of easy level if your concept is clear you can crack it easily then there will one more round there they will ask theoretical questions once these both technical rounds are clear you're all set to go for HR round. So this is for 1-2yrs exp guys for freshers they also have to go through aptitude round and question pattern is similar

• Q1. Basic oops concepts some tricky ques
  Add Answer
• Q2. Questions from collection framework
  Add Answer
• Q3. Multithreading basic questions
  Add Answer

• Q1. Basic hr questions
  Add Answer

• Q1. System design majorly on HLD
  View Answers (1)

• Q1. Basic js questions
  Add Answer

• Q1. Basic JS concepts and programming related to them
  Add Answer
• Q2. HTML, CSS questions
  Add Answer
• Q3. Framework knowledge
  Add Answer

• Q1. Problem solving related to algorithms and data structures
  Add Answer

• Q1. Javascript basics, design patterns. Angular basics. Few DSA questions ( very easy category)
  Add Answer

• Q1. Javascript deep dive. Promises internals. JS engine. Asynchronous patterns. Few questions on javascript code. Basics of HTML
  Add Answer

• Q1. A manager from other team will interview you. They will ask questions related to team conflicts and its resolutions. Questions on day to day activities. How to ...read more
  Add Answer

• Q1. Questions related to your aspiration vs SAP visions. Other personality related questions. One advanced DSA question. The DSA question came as a surprise to me a...read more
  Add Answer

Quant and verbal related questions

• Q1. All questions related to SQL and some python questions
  Add Answer
• Q2. Explain about VIEW in SQL
  View Answers (1)

Round duration - 123 minutes
Round difficulty - Medium

This was an online assessment round that consisted of 4 sections:

1) Cognitive Assessment (20 questions- 20 minutes): It had 2 sections.

English: (10 questions), which composed of comprehension-based and basic grammar questions,
Numerical Ability: (10 questions), which composed of questions on geometry, trigonometry, quadratic equations, probability, statistics, etc.

2) Technical Assessment (20 questions-20 minutes): It consisted of MCQs on Data Structures & Algorithms, DBMS, OOPs, OS, and Computer Networks.

3) Coding Assessment (2 questions- 60 minutes) The 2 questions were:

Similar to this -----/
Similar to this -----/

4) Gamified Assessment (3 tasks- 23 minutes): This section composed of mind game-based questions that had to be done according to the given instructions.

• Q1. Digit Count In Range You are given an integer ‘K’, and two numbers ‘A’ and ‘B’. You need to count the occurrences of the given digit ‘K’, in the range [A, B]. N...read more
  View Answers (3)
• Q2. Wildcard Pattern Matching Given a text and a wildcard pattern of size N and M respectively, implement a wildcard pattern matching algorithm that finds if the wi...read more
  View Answers (4)

Round duration - 60 minutes
Round difficulty - Medium

The interview was scheduled for 9 Jan 21 from 6:00 pm. The interviewer started with “Tell me about yourself”. Then he asked some CS fundamental questions. I was asked about the singleton class and then about the memory layout in C++, then he moved on to the next question. He pasted a code snippet in the chatbox and asked me to tell the output. I copied the code to my local editor and explained my approach to finding the output. The code was related to the concept of virtual function and destructor in C++. After that, he asked me how much memory will be used by a struct that is storing 2 char variables and 1 int variable.

After that, he started with questions on data structures and algorithms and I was asked three questions.

• Q1. Print Binary Tree Given a binary tree of integers, you need to print the binary tree in a 2-D array of string such that - 1. There should be ‘H’ number of rows ...read more
  View Answers (3)
• Q2. Unbounded Knapsack You are given ‘N’ items with certain ‘PROFIT’ and ‘WEIGHT’ and a knapsack with weight capacity ‘W’. You need to fill the knapsack with the it...read more
  View Answers (4)
• Q3. Minimum Cost To Make String Valid Ninja has been given a string ‘STR’ containing either ‘{’ or ‘}’. 'STR’ is called valid if all the brackets are balanced. ...read more
  View Answers (3)