| Other SQL PLSQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| wht is the difference between truncat,drop in sqlserver
wht is the difference between function and stored procedure
| Apollo | 1 |
| If I have a table T with 4 rows & 2 columns A & B. A has
values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL
query which can Swap the values of A & B for all records.
(Do not use a sub-query) | | 2 |
| How to return more than one value from a function? | | 7 |
| What is ON DELETE CASCADE? | | 2 |
| how to connect oracle in unix prompt? | Polaris | 2 |
| How can analyze query after generating explain plan ? | Thermotech | 1 |
| What is difference between CHAR and VARCHAR2?What is the
maximum SIZE allowed for each type? | Saama-Tech | 2 |
| 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 |
| can we update a view which is created from two tables | | 8 |
| When the mutating error will comes? and how it will be
resolved? | | 1 |
| What is a join?Explain the different types of joins? | Saama-Tech | 3 |
| Where the Pre_defined_exceptions are stored ? | | 1 |
| What is integrity constraints? | Ramco | 3 |
| What are the return values of functions SQLCODE and SQLERRM ? | PreVator | 2 |
| why should required for Indexed by table in pl/sql | | 2 |
| How to display the contents of a current record fetched in
a reference cursor? | | 1 |
| If an unique key constraint on DATE column is created, will
it validate the rows that are inserted with SYSDATE? | | 2 |
| How to perform a loop through all tables in pl/sql? | MBT | 3 |
| What is Referential Integrity? | | 2 |
| How can I pass the inner procedure value to outer
procedure ? | | 2 |
| |
| For more SQL PLSQL Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
