Skip to contentSkip to footer

Tech Lead Interview Questions

Salaries
Interviews

2,928 tech lead interview questions shared by candidates

2 round. Basic question and some managerial related questions. Matlab related,solver,step size ,Adas related ,vehicle dynamics,performance analysis,Misra guidelines,maab guidlines. Previous experience question.introduction,online solving problem ,modeling.automtive spice, various features of automotive Thanks
avatar

Tech Lead

Interviewed at KPIT Technologies

3.4★
Feb 10, 2023

2 round. Basic question and some managerial related questions. Matlab related,solver,step size ,Adas related ,vehicle dynamics,performance analysis,Misra guidelines,maab guidlines. Previous experience question.introduction,online solving problem ,modeling.automtive spice, various features of automotive Thanks

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 651 - 660 interview questions

Glassdoor has 2,928 interview questions and reports from Tech lead interviews. Prepare for your interview. Get hired. Love your job.