| Other SQL PLSQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is pragma exception and how, when, where us | | 4 |
| How pl/sql source code can be protected? | | 1 |
| in a package one procedure is wrong package shows valid or not | | 2 |
| in procedure how to return a value | Wipro | 3 |
| what is cursor procedure | iGate | 1 |
| How to display the contents of a current record fetched in
a reference cursor? | | 1 |
| how instead of triger is helpful for mutating tables errors
handlling ? | Oracle | 2 |
| How will we see framework of a table? | Accenture | 2 |
| What is referential integrity ? | BirlaSoft | 2 |
| what is global variable in package | | 1 |
| How will you a activate/deactivate integrity constraints? | | 1 |
| Differences between UNIQUE and DISTINCT in select statements | Verinon-Technology-Solutions | 9 |
| How to delete same emp id in sql query for exmaple in emp
table emp id, empname, emp address. for example emp id =5,
repeated in two times in rows same id how to delete same
empid please any one of the write query send in my id | CGCI | 7 |
| What is clustered, non-clustured and unique index. How many
indexes can be created on a table ? | TCS | 2 |
| What is a database link? | | 2 |
| Does SQL*Plus contains pl/sql Engine? | TCS | 1 |
| What are the two parts of a procedure ? | Hi-Caliber-IT | 4 |
| how to create object in plsql | Microsoft | 1 |
| why should required nested tables, Object types, partition
tables and varying arrays. what is the difference between
these are all. give me example with explanation. | | 1 |
| wht is the difference between sqlaserver2000 and 2005 | ABC | 1 |
| |
| For more SQL PLSQL Interview Questions Click Here |