| Other SQL PLSQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| how will u find statistics of a database objects?
| iFlex | 1 |
| what is explain plan? | | 4 |
| when a procedure /package is getting invalidated?
| TCS | 3 |
| full outer join syntax | | 1 |
| How the execution will be done in exceptions? | | 2 |
| What are the return values of functions SQLCODE and SQLERRM ? | PreVator | 2 |
| in a package one procedure is wrong package shows valid or not | | 2 |
| what is definer rights invoke rights? | | 1 |
| How can analyze query after generating explain plan ? | Thermotech | 1 |
| how to get second highest salary in SQL(as/4000 | iGate | 14 |
| In a package if we have 10 procedures or functions,How to
know which will execute first? | | 1 |
| what is the purpose of update command in oracle? | MBT | 6 |
| Can a table have two primary keys? | HCL | 18 |
| what are the advantages of primary key over unique+notnull | Oracle | 5 |
| What are two parts of package ? | Infosys | 2 |
| How to convert ms-excel file to oracle table? | | 2 |
| How many LONG columns are allowed in a table? | | 3 |
| What are user defined stored procedures ? | BirlaSoft | 2 |
| what is difference between stored procedures and
application procedures,stored function and application
function?
| | 1 |
| how to create user in sql and how to set password for that? | | 3 |
| |
| For more SQL PLSQL Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
