2 technical rounds, 1 manager round.

MVC lifecycle, middleware, polymorphism, authentication, authorization, throw vs throw ex, IEnumerable vs IEnumerator, SOLID, string vs StringBuilder.

SQL - index optimization, The Tuning Advisor, cursor/SQL loops - while.

JD/Q - 20 project - 15

Code: First name, last name, country.

('Raj', 'Gupta', 'India') ('Raj', 'Gupta', 'India') ('Mohan', 'Kumar', 'USA') ('James', 'Barry', 'UK') ('James', 'Barry', 'UK') ('James', 'Barry', 'USA')

Deduplicate duplicates

With SELECT:

SELECT *, ROW_NUMBER() OVER (PARTITION BY f, l, c ORDER BY (SELECT NULL)) AS rn FROM x WHERE rn > 1

How can we sort the elements of the array in descending order in C#? int arr[] = {2, 3, 1, 4, 5};

Array.Sort(arr); Array.Reverse(arr);

C#

Dependency injection, encapsulation, abstraction vs. interface, access modifiers, sealed class vs. private class, filters, routes, constant vs. readonly vs. static, ref vs. out.

SQL

Index, SP vs. function, null vs. IS NULL, optimize.

Code:

Table: tblFru, columnName: Name, values: Apple, Orange

Table: tblVeg, columnName: Name, values: Brinjal, Cauliflower

Output:

"Apple - Brinjal"

"Apple - Cauliflower"

"Orange - Brinjal"

"Orange - Cauliflower"

SELECT * FROM tblFru CROSS JOIN tblVeg

Who don't have an address.

T- employ - name T- add - for(e)

SELECT name FROM e LEFT JOIN add ON e.id = add.EID WHERE add = NULL

Salary - 3rd highest

WITH x AS ( SELECT *, ROW_NUMBER() OVER (PARTITION BY s ORDER BY a) FROM )

try { throw new ArgumentNullException(); } catch (Exception ex) { throw new ArgumentNullException(); } catch (ArgumentNullException ex) { throw new ArgumentNullException(); }

public int Add(int a, int b) { return a + b; }

public int Add(long a, long b) { return a + b; }

Add(1, 2)

public int Add(int a, int b) { return a + b; }

public string Add(int a, int b) { return "a+b"; }

string s = Add(1, 2)

interface IA { int Add(int a, int b); }

interface IB { int Add(int a, int b); }

class C : IA, IB { int Add(int a, int b) { return (a + b); } }

int a = 2, int b = 3; /* pre */ for (var i = 1; i