| Other SQL PLSQL Interview Questions |
| |
| Question |
Asked @ |
Answers |
| |
|
How to retrieve a second highest salary from a table?
Note:Suppose salaries are in duplicate values
eg:
Name Sal
Malli 60000
Pandi 60000
Rudra 45000
Ravi 45000
|
Sonata | 6 |
| package specification-3 procedures
package body-4 procedures how can i write for other
procedure in package body |
Reliance | 2 |
| what is the forward decleration in packages? |
| 1 |
| What is a transaction? |
| 4 |
| I want to know last five transactions or records from emp
table, from now? |
Wells-Fargo | 5 |
| What is the difference between anonymous block and named
block or stored procedure? |
| 6 |
| what is the purpose of update command in oracle? |
MBT | 7 |
| What is ON DELETE CASCADE? |
| 2 |
| How to create a view on a table which does not exists |
TCS | 4 |
| if i perform any operation on views such as insert, delete
etc will my base table get affected????? |
| 4 |
| what is sql optimization |
Fidelity | 1 |
| in table there r so many rows write a query which two rows r
updated last two day befor? |
Exilant | 3 |
| |
| For more SQL PLSQL Interview Questions Click Here |
Site Map
