| Other SQL PLSQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the basic structure of PL/SQL ? | | 5 |
| can we use out parameter in a function?Give an example. | Logica-CMG | 2 |
| Types of locks in database ? | TCS | 5 |
| what is difference between procedure and function,
procedure and trigger? | iFlex | 3 |
| difference between cursor and procedure in a package | | 2 |
| what is the command for user data type? | | 2 |
| How to trace the errors in pl/sql block code? | | 2 |
| What is difference between Procedures and Functions ? | Hi-Caliber-IT | 5 |
| Which clause of an UPDATE statement allows you to affect
only certain rows of a table?
1. The WHERE clause
2. The SET clause
3. The ROWS AFFECTED clause
4. The ORDER BY clause
| HCL | 5 |
| What is the difference between anonymous block and named
blocks? | | 2 |
| What are two virtual tables available during database
trigger execution ? | | 2 |
| wht is the difference between sqlaserver2000 and 2005 | ABC | 1 |
| why should required for Indexed by table in pl/sql | | 2 |
| what are the advantages of package?
| iFlex | 6 |
| Explain UNION,MINUS,UNION ALL, INTERSECT? | | 1 |
| can i give user defined exception in a package | | 2 |
| What is a bitmap index? | Choice-Solutions | 3 |
| if we give update table_name set column_name= default.
what will happen?
its given in pl sql block.what will hapen? | iFlex | 5 |
| How to add Foreign key in a table after the creation of the
table? | Satyam | 3 |
| Which one of the following join types will always create a
Cartesian Product?
1. CROSS JOIN
2. LEFT OUTER JOIN
3. RIGHT OUTER JOIN
4. FULL OUTER JOIN
5. INNER JOIN | | 2 |
| |
| For more SQL PLSQL Interview Questions Click Here |
Site Map
