L&T PLSQL Interview Questions

L&T Interview Questions

Rate your self in sql and pl/sql out of 5?
Tell me about your self and your current project?
What is dml, ddl, dcl, tcl commands?
What is joins? What is outer joins available, tell me about briefly?
What is view?
What is inline view?
What is sequence? Tell me the syntax?
What is no cycle and cycle, if we can not give no cycle what happened/
What is index? What type of indexes available?
What is cluster and bitmap index?
What is synonym? Tell me the syntax?
What is use of synonym?
Can we create a synonym on view?
What is Cursor? What is the use of cursor?
What type of cursors available? Explain?
Implicit and explicit
Write the syntax for cursor?
What is the procedure and function?
Tell me about the packages and uses?
What are the disadvantages of packages?
What is the concept of over loading and restrictions?
What is exception handling?
If I gave a select statement, it contains null data; I gave NO_DATA_FOUND AND OTHERS in exception block? What exception will handles and that procedure compiled or not?
What are nested tables, array?
What is materialized view?
What is trigger? Write the syntax?
What is instead of trigger?
What is Autonomous transaction and PRAGMA_INIT?
Write your company flow diagram?

Also read : Various Company Interview Questions