Oracle Interview Questions 03

                                                 Question For Experienced People




1)How do you identify  the problematic sql statements?

2)What is the process followed to tune sql statements?

3)What is explain plan?

4)What do you look for in explain plan?

5)I have 40 lines of code in plsql block, I got exception at 9 line,but still I want to continue from 10th line.How to achieve this?

6)How do you move your code from development to production ?

7)What tools do you use to move your code from development to production?



Ans

1) AWR (Identifying High-Load SQL Statements)

2) There is might be more process. Beginning with validation /cretion index ending , gather_stats, rewriting query, etcc. ending changing database parameters

3) Plan how ORACLE will execute the query

4)?
5) catching exception block.

6) ?

7) SVN, batch file, copy/paste, etc. look "6"

                             [NB:-Few questions base on your real time environment]