Skip to contentSkip to footer

Senior Lead Software Engineer Interview Questions

Salaries
Interviews

484 senior lead software engineer interview questions shared by candidates

Technical questions : More about SOLID principles , OOP concepts and basic Android questions. Behavioral questions : more about soft skills and how you behave in different situations. what was your last challenge and how you solve that.
avatar

Senior Android Developer and Team Lead

Interviewed at Humanoo

3.8★
Jul 19, 2023

Technical questions : More about SOLID principles , OOP concepts and basic Android questions. Behavioral questions : more about soft skills and how you behave in different situations. what was your last challenge and how you solve that.

Asked the below questions in the written test. 1. Define Packages and advantages of using packages 2. What information you require for designing a table? 3. What is bulk collect in PLSQL? Illustrate with an example. 4. How can one protect PLSQL source code? 5. Assume that a structure of an employee table is as given below and the employee table data as given below. EMP NO | ENAME | MGR |SAL |HIRE DATE | DEPT NO| 7369 | Smith | 7902 | 800 | 17-Dec-80 | 10 7521 | Wart | 7698 | 1250| 22-Feb-81| 30 6. Write a Query to get the running total of salary on department wise. 7. Write a hierarchical query to get the employee reporting to manager. 8. what are ref cursors? give an example. What are week and strong cursors. 9. Write about application tuning or SQL tuning for performance upgrade. 10. What are the ways of executing a dynamic SQL 11. How a commit or rollback done in table level trigger. 12. What is the difference between a foreign key and a reference key. 13. Name few 11g PLSQL features introduced in oracle 11G. 14. What are exceptions. Name oracle predefined exceptions that you have used in application development. 15. What oracle supplied that you have used/known. 16. What are Varrays/Nested tables. Below questions in the F-F. 1. Tell me about yourself. 2. What is Clustered index? 3. What are all the different types of indexes? 4. oracle 11g new PLSQL features. 5. How to do application/SQL performance tuning.
avatar

Tech Lead/Senior Oracle PLSQL Developer

Interviewed at 3i Infotech

3.4★
Sep 11, 2016

Asked the below questions in the written test. 1. Define Packages and advantages of using packages 2. What information you require for designing a table? 3. What is bulk collect in PLSQL? Illustrate with an example. 4. How can one protect PLSQL source code? 5. Assume that a structure of an employee table is as given below and the employee table data as given below. EMP NO | ENAME | MGR |SAL |HIRE DATE | DEPT NO| 7369 | Smith | 7902 | 800 | 17-Dec-80 | 10 7521 | Wart | 7698 | 1250| 22-Feb-81| 30 6. Write a Query to get the running total of salary on department wise. 7. Write a hierarchical query to get the employee reporting to manager. 8. what are ref cursors? give an example. What are week and strong cursors. 9. Write about application tuning or SQL tuning for performance upgrade. 10. What are the ways of executing a dynamic SQL 11. How a commit or rollback done in table level trigger. 12. What is the difference between a foreign key and a reference key. 13. Name few 11g PLSQL features introduced in oracle 11G. 14. What are exceptions. Name oracle predefined exceptions that you have used in application development. 15. What oracle supplied that you have used/known. 16. What are Varrays/Nested tables. Below questions in the F-F. 1. Tell me about yourself. 2. What is Clustered index? 3. What are all the different types of indexes? 4. oracle 11g new PLSQL features. 5. How to do application/SQL performance tuning.

Viewing 91 - 100 interview questions

Glassdoor has 484 interview questions and reports from Senior lead software engineer interviews. Prepare for your interview. Get hired. Love your job.