Skip to contentSkip to footer

Lead Engineer Interview Questions

Salaries
Interviews

7,959 lead engineer interview questions shared by candidates

1.OOPS concepts, program on shape and creating the different shapes dynamically 2.Stack concepts 3.Banking Domain basic terms and how processing and routing occurs 4.C basics and program snippets with similar outputs and their explanation
avatar

Lead Engineer

Interviewed at HCL

3.5★
Feb 6, 2016

1.OOPS concepts, program on shape and creating the different shapes dynamically 2.Stack concepts 3.Banking Domain basic terms and how processing and routing occurs 4.C basics and program snippets with similar outputs and their explanation

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.3★
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 1821 - 1830 interview questions

Glassdoor has 7,959 interview questions and reports from Lead engineer interviews. Prepare for your interview. Get hired. Love your job.