TCS PL/SQL Interview Questions
- What are the environments in your company?
- How to know which version is currently running in your database?
- Do you have any experience in data modeling?
- How to disable all triggers in a table?
- How many triggers are you created?
- How many triggers created on one table?
- Which will fire default first statement level or row level trigger?
- What is bulkcollect? And any restrictions in bulkcollect?
- What is the use of limit clause in bulkcollect?
- How to debugg your code?
- How to trace error handling?
- How to find which line error was raised?
- What are the methods there in save exceptions?
- What is functional based index? Write syntax?
- How to update complex view?
- Can you alter procedure with in package?
- Is it possible to open cursor which is in package in another procrdure?
- What is substr()&instr()?
- Difference between case and decode?
- Can you use sysdate in check constraints? If no, why?
- Difference between column level constraints & table level constraints?
- What is optimizer?
Also read: Various Companies PL/SQL Interview Questions
No comments:
Post a Comment