Udaan Software Engineer Interview Questions and Answers

Normalization organizes data to reduce redundancy and improve integrity in databases.

• Identify functional dependencies: Determine which attributes depend on others.

• First Normal Form (1NF): Ensure all entries in a column are atomic. E.g., split 'Phone Numbers' into separate entries.

• Second Normal Form (2NF): Remove partial dependencies. E.g., if 'StudentID' determines 'StudentName', separate into a new table.

• Third Normal ...read more

Understanding join and groupby queries is essential for data manipulation in SQL databases.

• JOIN combines rows from two or more tables based on a related column. Example: SELECT * FROM A JOIN B ON A.id = B.a_id;

• INNER JOIN returns records with matching values in both tables. Example: SELECT * FROM A INNER JOIN B ON A.id = B.a_id;

• LEFT JOIN returns all records from the left table and matched records from the right table. E...read more

Web server handles HTTP requests and responses, while application server executes application logic.

• Web server serves static content like HTML, CSS, JS files

• Application server executes dynamic code like Java, Python, Ruby

• Web server communicates with client, application server communicates with database

• Examples of web servers: Apache, Nginx, IIS

• Examples of application servers: Tomcat, JBoss, WebSphere

This question involves coding a pattern based on specified rules, typically using loops and conditionals.

• Identify the pattern structure (e.g., stars, numbers).

• Use nested loops for rows and columns.

• Example: For n=3, output could be: * ** ***

• Consider edge cases like n=0 or negative values.

My dream is to create innovative software solutions that positively impact people's lives and drive technological advancement.

• Building User-Centric Applications: I aspire to develop applications that prioritize user experience, like a health tracking app that motivates users to lead healthier lives.

• Contributing to Open Source: I dream of contributing to open-source projects, collaborating with developers worldwide to c...read more