Defence Research & Development Organisation Senior Research Fellow Interview Questions and Answers

Use SQL query with ORDER BY and LIMIT to find the second highest salary.

• Use SELECT statement to retrieve salary column from the table.

• Use ORDER BY clause to sort the salaries in descending order.

• Use LIMIT 1,1 to get the second highest salary.

Use SQL query with GROUP BY and window function to check for duplicate rows.

• Use GROUP BY to group rows with same values together

• Use COUNT() function to count the number of occurrences of each group

• Use window function like ROW_NUMBER() to assign a unique number to each row within a group

DO 178 B/C is a software development standard for airborne systems.

• DO 178 B/C is a set of guidelines for developing software for airborne systems.

• It ensures that software is reliable, safe, and meets regulatory requirements.

• The process includes requirements analysis, design, coding, testing, and verification.

• Compliance with DO 178 B/C is often required for certification of avionics software.

Agile is a software development methodology that emphasizes flexibility, collaboration, and iterative development.

• Agile focuses on delivering working software in short, iterative cycles called sprints.

• It values customer collaboration and responding to change over following a strict plan.

• Scrum and Kanban are popular frameworks used in agile development.

• Daily stand-up meetings, sprint planning, and retrospectives are com...read more