| Other SQL PLSQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is the difference between union and union all | Oracle | 11 |
| Wat is SGA ? | ABB | 1 |
| how to create object in plsql | Microsoft | 2 |
| what are the differences among these table level lock
modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE
MODE ? | HCL | 2 |
| What happens if a procedure that updates a column of table X
is called in a database trigger of the same table ? | | 1 |
| Write one update command to update seqno field of a table
on the basis of row number. | HCL | 3 |
| four procedures is are there should i write their in a package | | 2 |
| How to execute OS(operating system) command from pl/sql? | | 3 |
| full outer join syntax | | 2 |
| Can we use more than one null value for unique key? | A1-Technology | 18 |
| Given two tables Student(SID, Name, Course) and Level(SID,
level) write the SQL statement to get the name and SID of
the student who are taking course = 3 and at freshman level. | Oracle | 6 |
| I need a exceptoin in pl/sql block so that if any errors
occur in the block then no exception should errors should
raise? | | 1 |
| While inserting 10 rows using procedure, if 3rd entry is
having some error, what will be the output? How u will
handle that error? | iFlex | 8 |
| What is correlated sub-query? | Oracle | 3 |
| Can we write create command in the plsql block?if possible
how? | | 2 |
| How do you optimize SQL queries ? | Infosys | 4 |
| Write a query to find second highest salary of an employee.
| | 12 |
| What is a transaction? | | 4 |
| Can we use SQL%ISOPEN in implicit cursors? Does this
attribute works properly in Implicit Curosors? | | 2 |
| what is the forward decleration in packages? | | 1 |
| |
| For more SQL PLSQL Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
