| Other SQL PLSQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is a package ? What are the advantages of packages ? | Symphony | 1 |
| Difference between inline query and stored procedure? | Microsoft | 1 |
| what are the different types of joins? | Choice-Solutions | 3 |
| what is a sub query?how will you calculate working days in
a month using sub query? | InteQ | 3 |
| What is INSTEAD OF trigger ? | TCS | 5 |
| What is CYCLE/NO CYCLE in a Sequence? | | 1 |
| How to trace the errors in pl/sql block code? | | 2 |
| how a reference cursor works?what all adnvantages are
gained with it..specify the situation? | TCS | 2 |
| What is RAC in oracle? | | 2 |
| What is Raise_application_error ? | | 1 |
| can we call a procedure into another procedure?If yes means
how you can pass the perameters for the two procedures?
| | 2 |
| What is a REF CURSOR? Compare strong and week ref cursor types. | | 3 |
| Which one of the following is a reason that an INSERT
statement might cause an error instead of executing
correctly?
1. The INSERT statement was attempting to insert a record
into a view that was created from more than one table.
2. The INSERT statement was attempting to insert a record
using a combination of constants and values from an
existing table.
3. The INSERT statement was attempting to insert a record
with a non-NULL value into a table that has that column
defined as NULL.
4. The INSERT statement was attempting to insert a record
into a table by selecting a record from that same table.
5. The INSERT statement was attempting to insert a record
into a view rather than a table.
| Sonata | 1 |
| What is the usage of NVL? | Infosys | 5 |
| if we give update table_name set column_name= default.
what will happen? | iFlex | 2 |
| what is the difference between to_char and to_date
functions? | | 1 |
| i have doubt that any one tell ref cursor comes in sql
pl/sql? pls clarify? | | 2 |
| What are the differences between Database Trigger and
Integrity constraints ? | | 3 |
| what is global variable in pl/sql | | 1 |
| hi this is nakka i have been looking for 1+ exp in oracle
sql,plsql developer positions also have knoledge on d2k
i am not getting proper walkins how to know it? where can
i find it? | | 1 |
| |
| For more SQL PLSQL Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map
